All geek questions in one place

Best way to transfer data from one database (sql server 2008) to another db (sql server 2008) with a different schema

What is the best way to transfer data from one database (sql server 2008) to another db (sql server 2008) using another schema?

Is there a program for this?

thank you 4 your future asnwer

Regards

+3
source share
3 answers

Depending on how complex your needs are, you may want to learn SSIS .

+3
source

SSIS ( SQL-) . . , , , . , varchar datetime , (, "ASAP" ), , . mismathces, - , , , null. , , , . , . id, . .

+3

dest. dest ,

INSERT INTO Destination_Table (col1, col2, col3)
    SELECT colA, colB, colC
    FROM [SRC_MACHINE\SRC_SERVER].Source_Database.dbo.Source_Table

, ( ) SELECT JOIN .., .

, SQL Server Express ( SSIS).

+1

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

More articles:


All Articles