Post reply

Copying data between two SQL Server db having different schemas by using SSIS

  • July 15, 2014 at 8:17 am

    #293293

    Hi,

    I've two SQL databases, the first one having the schema named sch1 and the second one with the schema

    named sch2. I need to copy data of more tables belonged to the sch1 into the sch2 of the second SQL Server db

    and I'd like to create a SSIS 2012 pkg in order to achieve this goal.

    Any suggests to me, please?

    Thanks

  • July 15, 2014 at 8:56 am

    #1729500

    pmscorca (7/15/2014)

    Hi,

    I've two SQL databases, the first one having the schema named sch1 and the second one with the schema

    named sch2. I need to copy data of more tables belonged to the sch1 into the sch2 of the second SQL Server db

    and I'd like to create a SSIS 2012 pkg in order to achieve this goal.

    Any suggests to me, please?

    Thanks

    It's not clear how familar you are with SSIS or what tools you have available. I'm assuming you have SQL Server 2012 installed and have data tools available. If you're just starting out, it's probably best to use the export wizard in SSMS to generate a package to accomplish this task. Open SSMS connected to the server with the source data (sch1). Right click on the database containing the tables you want to copy. In the context menu, select Tasks-->Export Data. Walk through the wizard to set up the transfer to the second SQL Server (sch2). Be sure to check the mapping for each table to ensure it's what you want.

    Particularly if you're new to SSIS, I'd also suggest saving the package before running. That way later on you can create a project and import the package saved from the wizard. Examine how it works. Modify it if you'd like.

    If you are new to SSIS, check the Stairways series by Andy Leonard on SSIS: http://www.sqlservercentral.com/stairway/72494/

  • July 15, 2014 at 11:15 am

    #1729556

    Hi thanks, I've already used the Import / Export data wizard but it seems more interesting to import inside a SSIS project the import/export package saved on SQL Server or on file system in order to edit it.

    It seems the unique solution to copy data of more tables belonged to different schemas.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply