Post reply

Data transfer between two identical databases

  • June 14, 2007 at 10:40 am

    #117506

    Hi,

    I am trying to create a package or script to transfer data between identical databases.

    1. They are relational databases (PK, FK).

    2. Using identity property.

    Would it be easy to just drop all objects and recreate them with data?

    Can someone help me with this ASAP.

    Thanks.

  • June 15, 2007 at 3:55 am

    #713188

    If the identical databases are both SQL Server, you could use the tansfer SQL Objects task in SSIS.

    In this task you can choose options of which tables, constraints etc.

    You can drop the tables and just recreate them with data, performance of course an issue with large amounts of data. Depending on what type of data you are importing will also define whether its wiser to append new items or import from scratch.

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

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