|
Posted by aaron.reese on 10/24/06 10:33
provided you are not doing anything complicated (SQL syntax can vary
between databases), the only change you should need to make is to the
DBconnect call, where you will need to change the database type.
if you MySQL database server has phpmyadmin installed, then you can do
an SQL dump of your database which will create a script that will
create all the new tables and insert the data into your MS_SQL
database.
What reason do you have from moving from MySQL to MS_SQL. These days
you need a pretty good reason to move from free open-source databases
to ones which require licences. I suppose MS_SQL is easier to use for
client-server applications especially if written in .net or VB6.
Obiron
Navigation:
[Reply to this message]
|