I found a tool called Full
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.
On Mon, Jan 30, 2012 at 5:23 PM, Carl Kabbe <carl@stripped> 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.
> 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