Page 1 of 1
MySQL to MS SQL
Posted: Wed 01 Feb 2006 06:05
by ekarasu
Our product is working with MySQL (using MyDAC component) and we want to develop another version for MS SQL. My question is, is it easy to convert the current project for MSSQL using SDAC component? What are the important and painful issues in conversion? Ercan
Posted: Thu 02 Feb 2006 07:00
by Bernhard Geyer
Modify your application to use the Bridge-Pattern to encapsulate the DB-Access-Layer. All DB-Specifiy Code should be in only one unit.
If you have don this, you can add MS SQL-Support by adding one unit with using SDAC.
Posted: Thu 02 Feb 2006 08:00
by ekarasu
Does SDAC cover all the functions MyDAC has? I mean even if we do it with a DB layer, will there be additional precautions that we have to take for implementing certain functions (like backup, repair or table data type adaption)?
Posted: Mon 06 Feb 2006 10:27
by Ikar
SDAC is similar to MyDAC but there are some differences that depend on the SQL Server functionality and on the users' demand. For example: you can't use DROP ... IF EXISTS statement, because MSSQL Server doesn't allow this functionality.
Posted: Mon 06 Feb 2006 12:07
by Ikar
Some actions, like backup, repair etc are implemented on different servers in different ways. Therefore you should implement managing of these actions separately for each server (MySQL Server, MSSQL Server etc).