PDA

View Full Version : Converting to MS SQL Server



Bryan Beswick
7-Mar-2006, 05:40 PM
I have two questions:

1) Does anyone know of any potential "gotchas" of using DataFlex 3.2 with MS
SQL Server and the connectivity kit?

2) I want to programmatically convert my database to SQL Server. The
ckmgr.src program is all interactive. Is there a simple way (other than
wading through tons of source) to make convert 100% unattended?.

Thanks,
Bryan

Ben Weijers
8-Mar-2006, 04:27 AM
Bryan,

If your original data uses construct that are illegal in SQL Server that
table cannot be converted and must be adjusted. This does not happen very
often.

In SQL Server the collating sequence can be specified when creating the
database. If this is a case insensitive collating sequence and your indices
rely on case sensitivity you may get conversion problems. Make sure the
collating sequence is correct.

We no longer deliver ckmgr with the CK. If you want to convert we recommend
the use of Database Builder. A standalone installation of Database Builder
is available for this purpose.

If you want to write the convert logic yourself you can. You can use the
ckmgr source code as starting point. If you want to make the porcess
completely unattended you can. You will probably have to use Embedded SQL to
create the database and such but it is possible.

Regards,

Ben Weijers
Data Access Worldwide