I've got a mysql database filled with data which I have to keep but migrate to ms sql server 2008.
I understand finish to finish in which the data is going, table to table however i have no clue how to pull off moving the information. I have looked online however it appears you will find 'solutions' that you've to download and run. I'd rather if at all possible make a move myself when it comes to writing scripts or code.
Can anybody recommend the easiest method to do that please?
There are several options here:
- Around the sql server side, you are able to setup an association for your old mysql db using something known as a linked server. This will help you to write sql code for sql server that returns data in the mysql tables. This can be used to construct Place or Choose INTO claims.
- You are able to write queries for mysql to export your computer data as csv, after which make use of the BULK Place options that come with sql server to effectively import the csv data.
- You should use Sql Server integration services to create slowly move the data over from mysql.
No matter that you simply choose, non-data items like indexes, foreign secrets, triggers, saved methods, and security must be moved by hand.
Used to do it once, a while ago. Firstly you could couple your mssql server towards the mysql server while using odbc mysql connector http://dev.mysql.com/downloads/connector/
following the connection is created you are able to write you database procedure while you would whether it were two mssql db's. Most likely simplest to create some sql batch scripts together with a cursor in which you tell you every every row of the table an pick a area basis where you'll need the area later on.
illustration of a cursor: http://www.mssqltips.com/tip.asp?tip=1599
if you choose to opt for the cursor, you are able to have fun with the parameter to improve performance. I especially recall the FORWARD_ONLY parameter giving a large boost.
Perhaps you have attempted tool from MSFT known as SQL Server Migration Assistance for MySQL ??? https://www.microsoft.com/download/en/details.aspx?id=1495