Trying to migrate to SQL Server 2005 using ODBC

[Marc Scheuner]

Folks,

I'm tasked with migrating data from FM Server 8 to SQL Server 2005. I was trying to use the ODBC driver for FM Server, and the SQL Server 2005 Data Import functionality.

I keep having odd and inexplicable OLE and COM errors when trying to move the data (less than 100'000 rows - really not a huge amount).

Any ideas? Is there another way to do this efficiently (on about 25 tables or so)? What can I check or tweak to make the import work?

I have the same problems when trying to migrate the FM data to MS Access 2003, too.

Any help would be highly appreciated !

[mr_vodka]

Please do not double post

Link

[Marc Scheuner]

Sorry about the crosspost - I hadn' discovered the ODBC/JDBC group (who puts that under "web 2.0 technologies" anyway???).

Thanks for the link to the white paper - doesn't really help much, since I'm not really looking to learn how to use and make the most of FMPro - I need to find a way to migrate an existing database and app to SQL Server 2005.

Thanks anyway!

[Wim Decorte]

Probably just a lot easier to export from FM to text and then import into SQL...

[Marc Scheuner]

Maybe so - but that way, I loose all information about the fields (name, data type etc.) and have to re-create that manually..... not exactly the greatest solution..... but thanks!