Page 1 of 1

use structure of old project to new when change database

Posted: Fri Sep 06, 2013 12:29 pm
by playstorm

Now I finish project which use MS SQL database already and I convert MS SQL to MySQl with same sturcture for create new project
but when I rerun my project with new connection to MYsql I lost every setting of old project so I must create all new
with same structure with old project

Can I create new project with New database with same structure of old database ? (MSSQL->MySQL)

Thanks :


Re: Can use structure of old project to new when changeDatab

Posted: Fri Sep 06, 2013 1:11 pm
by mobhar

No, you cannot. You cannot convert your project from one database engine to another by using the old database structure since there are the different data type among those database engines.

Hopefully, someday PHPMaker has the ability to convert it automatically, as well as if we are using Navicat to dump the database from one database engine to another.