Import MySQL into MSSQL (free/easy)
I needed to move several medium size MySQL backend apps to SQL server 2005 and did not have a cool tool for doing it. I found a way that was suprisingly easy... To do this you will need to install the ODBC drivers for your version of MySQL; I'm using MySQL 5.
Then in your SQL Management Studio, modify and run the following code.
EXEC master.dbo.sp_addlinkedserver
@server = N'MYSQL',
@srvproduct=N'MySQL',
@provider=N'MSDASQL',
@provstr=N'DRIVER={MySQL ODBC 5.1 Driver}; SERVER=127.0.0.1; DATABASE=db_name; USER=user; PASSWORD=pass; OPTION=3'
Then write seperate scripts that contain an instance of the following pieces of code per table in your MySQL db. In my case I had about 40 tables, so I wrote a ColdFusion job to do it smartly and added SQL to drop the target table if it existed.
SELECT * INTO [target_mssql_db].dbo.[target_mssql_table]
FROM openquery(MySQL, 'select * from mysql_db_name.mysql_tablename')
One of my apps had some tables with LOTS of rows, so I also set my script up to only run 5 conversions at a time to avoid timing out MSSQL locks. This should also work on MSSQL 2000 and I'm sure at least a few versions back of MySQL.
3 comments - Posted by Russell Brown at 2:24 PM - Categories: ColdFusion | SQL | MS-SQL | Development
In
an amazing show of talent and aggressiveness from both riders, Rossi
was able to finally stop the train that is Stoner. Knowing full well
that if he let Stoner stay in front for long that he was pull away,
Valentino made multiple daring and aggressive passes in order to
maintain his lead providing for some of the most exciting and breath
taking racing the sport has seen in many years.
In
short: The Dark Night continues what I think Batman should have always
been: Dark, gritty, sadistic and ugly. Heath Ledger steals the movie
with an amazing representation that makes Jack Nicolson's version look
like a cotton candy parody.
At
first I was not in favor of Heath's voice, but after several short
dialogues I was convinced it was just what was needed... Ledger’s
physical acting was immense; his ever so slight facial adjustments, the
way he walked and even held a knife was phenomenal. He even pulled off
some full theater audiance laugh grabs while never leaving his dark
character. The storyline behind the Joker was also perfect. No BS story
no cause to fight for... nope he just enjoys to fuck with humanity and
test people and their limits!
Crash Testing
The Bad / Areas of improvement