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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Migrate Ingres to SQL

Author  Topic 

cmw
Starting Member

5 Posts

Posted - 2002-10-02 : 06:39:15
Hi,

Anyone ever migrated Ingres to SQL.

I've only ever done SQL 6.5 to 2000 and now they want me to migrate an ingres db to SQL 2000.
Questions
is this simple via ODBC and DTS?
someone said get into MS Access first then use DTS from that
any advice would be welcome.

Cheers in advance
Chris

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-10-08 : 12:57:00
The easiest way I can see is use ingres to export to a text file and then use dts to import the text file. We go from a IDMS to a text file and the text file to SQL 2k every night here. seems to work decent.

-----------------------
SQL isn't just a hobby, It's an addiction
Go to Top of Page
   

- Advertisement -