Thanks Carl. I found a tool called Full Convert<http://www.spectralcore.com/fullconvert/> that did conversion (small database only) from MSSQL to MySQL. I tried to test their Trial version and it converts completely with similar structure, fields, etc.. Because it's trial version, some more than 5 columns are named into 'TRIAL_COLUMN' instead of the actual one.
I am not sure if this tool is worth to use an reliable? I am still not confident and want to know of what are the other concerns to consider. Cheers. James On Mon, Jan 30, 2012 at 5:23 PM, Carl Kabbe <c...@etrak-plus.com> wrote: > I do this quite frequently. In our case, we are converting competitors > data so the process is to use Navicat (premium) to bring the data from > MSSQL to MySQL (in the same fields, etc.) and then use a program to convert > it into our format so it will run on our system. The only thing I have had > to do is add some indexes manually. > > Thanks, > > Carl > > On Jan 30, 2012, at 2:06 AM, James wrote: > > > Hi All, > > > > I am involved in a project to migrate our entire database from Microsoft > > SQL to MySQL. > > > > I would appreciate the help if anyone could share what tools will you > > recommend of converting SQL database to MySQL. > > > > Cheers. > > James > >
