Wednesday, March 7, 2012

Migration of database from MS SQL to Pervasive SQL and vice versa

Hi,
would to know what are the ways to migrate DB/copy tables
(1) from MS SQL to Pervasive SQL and
(2) from Pervasive SQL to MS SQL
Thank you.
Regards. SallyOriginally posted by sallypeh
Hi,
would to know what are the ways to migrate DB/copy tables
(1) from MS SQL to Pervasive SQL and
(2) from Pervasive SQL to MS SQL

Thank you.
Regards. Sally

From Pervasive to SQL Server works well through the Import / Export Wizard (and DTS), using Pervasive's ODBC or OLE DB.
I have not had any reason to try it the other way, but it should work too.

Cheers,
Robert

No comments:

Post a Comment