MS SQL Server migration
От | Roman Fail |
---|---|
Тема | MS SQL Server migration |
Дата | |
Msg-id | 9B1C77393DED0D4B9DAA1AA1742942DA0E4BFB@pos_pdc.posportal.com обсуждение исходный текст |
Список | pgadmin-support |
I recently completed a data migration to Postgres 7.3.1 using the pgAdminII Migration Wizard. It is awesome, and so mucheasier to use than MS DTS. Thanks for such a great tool. However, I was unable to migrate a table with a VARBINARY column using the wizard. MS DTS was able to migrate the binarytable to postgres just fine, but had memory problems due to the size of the table (23 million tuples). So I endedup using bcp and a writing a hex2octal UDF to get the thing imported. (And thanks to Ian Harding for a lot of goodideas in his tech doc). Is binary migration going to be supported at some point? Clearly ODBC can do it, I'm guessing it's just a matter of writingthe routines. Second, I found that all my indexes migrated flawlessly, except for the unique primary key indexes! PostgreSQL and MSSQLhave a major difference when you use CREATE TABLE ... PRIMARY KEY. Postgres simply creates UNIQUE and NOT NULL constraints. MSSQL does all that, plus it creates a unique index for the column. Perhaps in future versions of the wizard,these indexes would also be migrated? I saw a bunch of indexes on all my migrated tables, and foolishly assumed thePK indexes were there as well. Roman
В списке pgadmin-support по дате отправления: