Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-03 : 08:25:01
|
| shoban writes "I am using SQL server 2000 database. I'm trying to migrate the sql tables and data to postgres 7.2 on linux 7.1. I used SQL server's import/export data wizard to migrate the data.I found only tables are getting created on postgres and datas are not migrated. The error message is given below.Relation "ArchiveSet" does not exist <ArchiveSet - Table name>and when i tried to migrate a single table without any relationship, i'm getting error like thisError at Destination for Row number 1. Errors encountered so far in this task: 1.some junk character after 1. (i couldnt able to paste that junk character here)i think probably it should be some carriage return or line terminator.kindly help me out..Shoban" |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-09-03 : 09:42:27
|
| Don't know anything about postgres. Maybe try to send the tables out to flat files and then import into postgres. Flat files are pretty universal. I don't know if postgres supports foreign keys and relationships or not. If so, you may need to rebuild them after the data is imported. |
 |
|
|
|
|
|
Migrating SQL data to Postgres