CREATE PRIMARY XML INDEX not understood
Opened this issue · 0 comments
zarzgalom commented
Attempting to migrate an ArcGIS database from MSSQL to PGSQL. Created the SQL dump, configured a conf file for the conversion script with all default behaviors. I did configure connection parameters to create the Kettle job. Pass the script the .conf file and it fails pretty quickly after with the following:
Line <CREATE PRIMARY XML INDEX [xmlprim_GDB_ITEMRELATIONSHIPS_Attributes] ON [sde].[GDB_ITEMRELATIONSHIPS]
> (16468) not understood. This is a bug at ./sqlserver2pgsql.pl line 2551, <$file> line 16468.
Looking at the SQL dump, the line mentioned (16468) is the very first instance of CREATE PRIMARY XML INDEX. It only appears a few times afterwards, but it seems to be a deadstop for sqlservertopgsql.pl.
I'm not sure what other information you might need. Let me know and I will do my best to provide it.