List:General Discussion« Previous MessageNext Message »
From:James Date:January 30 2012 10:13am
Subject:Re: Converting Microsoft SQL database to MySQL
View as plain text  
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 <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.
>
> 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
>
>

Thread
Converting Microsoft SQL database to MySQLJames30 Jan
  • Re: Converting Microsoft SQL database to MySQLCarl Kabbe30 Jan
    • Re: Converting Microsoft SQL database to MySQLJames30 Jan
  • Re: Converting Microsoft SQL database to MySQLhsv30 Jan
    • Re: Converting Microsoft SQL database to MySQLJohan De Meersman31 Jan
      • Re: MySQL-kind CSV; Converting Microsoft SQL database to MySQLhsv31 Jan
  • Re: Converting Microsoft SQL database to MySQLSQL Maestro Group31 Jan