MS SQL

mysql to mssql

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2009

Posts: 27

Reputation: kool.net is an unknown quantity at this point

Solved Threads: 0

kool.net

Offline

Light Poster

Mysql to MS sql

Oct 16th, 2009

hi,
can any one tell me how to i use my sql sever's databse itno ms sql 2008 server.
I tried to to do dat with the help of mysql backup file & execute it on ms sql server, but there are some syntax related problems.
please help me.
thanks in advance

•

Join Date: Apr 2009

Posts: 56

Reputation: baki100 is an unknown quantity at this point

Solved Threads: 11

baki100

Offline

Junior Poster in Training

Oct 16th, 2009

migrating from one rdbms to another is not as simple as dumping the sql scripts in the new rmdbs, unless you convert the entire script by hand a simpler solution is use a migrator tool to migrate and old dbms to a new one.

Last edited by baki100; Oct 16th, 2009 at 5:29 am.

http://eyeshield666.mybrute.com

•

Join Date: Feb 2009

Posts: 3,464

Reputation: sknake has much to be proud of

Solved Threads: 629

sknake

Offline

.NET Enthusiast

Oct 16th, 2009

You DTS or the Import/Export data wizard on SQL Server 2008 to copy the data. You should be able to set up an ODBC data source to connect to your MySQL database then let SQL Server handle the rest.

The table structures will be rough and unindexed so you should create a new set of tables by hand with proper indexes, relationships, datatypes, etc. After that just insert the data in to the newly created tables.

Scott Knake
Custom Software Development
Apex Software, Inc.