Post reply

export data

  • March 19, 2009 at 9:56 am

    #207158

    Hello folks,

    i would like to export data from a server with sql server 2005 to other one with sql server 2000.

    at present, i do it with the Management Studio but i would like to do it by a different way.

    the reason for this issue is to grant to my development staff to do it.

    i would to know if it could do by T-SQL, i am amateur about Sql Server.

    thanks in advanced

    regards

    Thomas

  • March 19, 2009 at 10:09 am

    #962857

    This can be done with t-sql set up a linked server and use some insert statements to copy the data.

    Or you could use SSIS to create a script to load the data, save this script to SQL server and you can schedule it to run or run it manually.

    Though if you do not have much experience with SQL you may want to look at Redgates SQL data compare product ,as this will do all the data loading for you using a nice GUI..

  • March 20, 2009 at 9:04 am

    #963589

    thanks for the reply,

    i think the first solution it's ok for us.

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

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