All geek questions in one place

Transfer MySQL data to SQL Server

I need to convert data that already exists in a MySQL database into a SQL Server database.

The caveat here is that the old database was poorly designed, but the new one is in the correct 3N form. Does anyone have any tips on how to do this? I have SSMS 2005.

  • Can I use this to connect to a MySQL database and create a DTS? Or do I need to use SSIS?
  • Do I need a script to output from a MySQL database and modify each statement to "insert" into the SQL Server database?

Has anyone gone through this before? Please, help!!!

+3
source share
6

. . , MySQL SQL Server MySQL ODBC. , MySQL SSMS, SQL Server.

!

+8

SSIS . , . , , fileds1 2 a, b, a. , , , , ..

, , . , , . , , , , , . , dataclean, , , - (, varchar, datetime db, , .

, , - , .

, , . .

+5

, "ETL" . , , , , , / , .

, , , , root. , .

0

, SSIS , , , script . SSIS ETL.

0

SSMS , " ". . , SSIS, , .

, . , ( , , , ).

, SSIS , , . MS SQL , SQL 3NF. , . , , SSMS. . , , , "STG_" - .

. , ( ). MS SQL, , , . MS SQL , , , . , , , .

0

Source: https://habr.com/ru/post/1724543/

More articles:


All Articles