SQL Script File

ramone_johnny · May 14th, 2009, 09:19 PM

Hi guys,
I backed up a MySQL database just recently and have a text file (SQL Script File) on my local hard drive that Id like to restore if possible into MS SQL server. As I havent done this before I am unsure as to how its done.

I have both MS SQL 2000 Enterprise Edition and 2005 MS SQL Management Studio.

Cheers,
John

ramone_johnny · May 19th, 2009, 02:52 PM

Can anyone assist with this please???

happygv · May 20th, 2009, 12:32 PM

You may need to look at those scripts and change it a bit in terms of syntax. and some of the statements that are different between MYSQL and MSSQL atleast to start with the CREATE DATABASE statement. INSERT statements are different in MYSQL, with multiple row values done using one INSERT statement, but not the same on MSSQL.

You could have also looked for some tools that can transfer data from mysql to SQL server.

Hope that helps.

Cheers,

rstelma · May 20th, 2009, 03:28 PM

It's possible that you could create a database and import the data from your script file if in fact it does contain data.

It just depends on what is really in your file. Is it just the scripting for the schema of the database or is it data?