October 18, 2005 at 11:26 pm
Hi All,
Can anyone tell me how to restore a MySQL dump into SQL Server 2000. Thanks in advance.
Regards,
JM
October 19, 2005 at 8:14 am
They are two different databases. You wouldn't be able to restore MySQL into SQL Server. You should be able to link the databases and copy the information from MySQL into SQL Server (DTS or some other commands).
-SQLBill
October 20, 2005 at 10:14 am
It depends on the form of the MySQL dump. If the schemas are identical and the dump is in the form of a set of insert statements you can do it with query analyzer. If the dump includes the table creation data as well and it's pure sql then you could also do it with query analyzer and enterprise manager. However if the dump is in the form of binary records you are out of luck. You still may run into problems even with the plain sql dump but they will be minor.
October 20, 2005 at 10:28 am
From somewhere on the IntarWeb:
"A MySQL dump is a bit slower than a raw backup because it creates all the SQL queries required to create the tables of that database, as well as all the insert queries required to place the information back into the database's tables. "
It would appear that you would need to execute the dump in the target database. Perhaps from the Query Analyzer.
You may need to tweek the dump to get it to work in MS SQL 2000.
jg
October 24, 2005 at 11:54 am
It sounds more like an Oracle 'export' ... so 'tweaking' it a bit and executing in QA should punch your ticket !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply