Home Forums SQL Server 2008 SQL Server 2008 Administration Ways to move only table data in database? RE: Ways to move only table data in database?

  • December 18, 2012 at 7:56 am

    #1569588

    mpradeep23 (12/18/2012)

    Hi

    i have two databases in different instances i need to transfer data between two tables are by querry can any one specify the ways for the above process

    Thanks in advance

    With best regards

    pradeep

    You can do this by using the script wizard. Basically right click database/task/generate script....this will open the script wizard, then script out the table you want and apply in the other database.

    SueTons.

    Regards,
    SQLisAwe5oMe.