How do I get auto-numbered Access/MS SQL fields to migrate ?
От | Greg |
---|---|
Тема | How do I get auto-numbered Access/MS SQL fields to migrate ? |
Дата | |
Msg-id | 000001c2b98b$f052b4e0$0a00a8c0@atlas обсуждение исходный текст |
Список | pgadmin-support |
I am using pgAdminII to try to convert data in either Access or MS SQL Server 7 to a PostgreSQL database on a Suse box. I am trying to get the Northwinds database to convert as a proof of concept project. Apparently the AutoNumber field has problems converting. Any pointers would be helpful. My log errors are pasted here if it helps. TIA Greg Canter Creating table: Categories Creating sequence Categories_CategoryID_key An error occured at: 1/11/2003 10:59:46 AM: -2147467259: ERROR: Unable to locate type name 'lo' in catalog Rolling back... Done.Creating table: Categories Creating sequence Categories_CategoryID_key An error occured at: 1/11/2003 11:00:03 AM: -2147467259: ERROR: Unable to locate type name 'lo' in catalog Rolling back... Done.Creating table: Categories Creating sequence Categories_CategoryID_key An error occured at: 1/11/2003 11:03:15 AM: -2147467259: ERROR: parser: parse error at or near "," Rolling back... Done.Creating table: Categories Creating sequence Categories_CategoryID_key An error occured at: 1/11/2003 11:03:20 AM: -2147467259: ERROR: parser: parse error at or near "," Rolling back... Done.Creating table: Categories Creating sequence Categories_CategoryID_key An error occured at: 1/11/2003 11:03:21 AM: -2147467259: ERROR: parser: parse error at or near "," Rolling back... Done.Creating table: Categories Creating sequence Categories_CategoryID_key An error occured at: 1/11/2003 11:05:03 AM: -2147467259: ERROR: parser: parse error at or near "," Rolling back... Done.
В списке pgadmin-support по дате отправления: