Jump to content

Trying to migrate to SQL Server 2005 using ODBC


This topic is 5694 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 !

Link to comment
Share on other sites

  • Newbies

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!

Link to comment
Share on other sites

This topic is 5694 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.