copy data from one server to another

  • Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right now:

    if condition1 then

    rsDBorigin = DBorigin("select...FROM table1..")

    sql = "......" & rsDBorigin("col1")

    sql = sql & rsDBorigin("col2")

    set rsDBdestination = DBdestination.Execute(sql)

    if conditon2 then

    rsDBorigin = DBorigin("select...FROM table2..")

    Do While (NOT rsDBorigin.EOF)

  • you can transfer the data from one server to another, using linked server, openrowset, bcp for more info see SQL BOL.

  • Hi

    I'm not sure what's the specific question? 😉

    Greets

    Flo

  • KATHLEEN Y ZHANG (5/6/2009)


    Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right now:

    if condition1 then

    rsDBorigin = DBorigin("select...FROM table1..")

    sql = "......" & rsDBorigin("col1")

    sql = sql & rsDBorigin("col2")

    set rsDBdestination = DBdestination.Execute(sql)

    if conditon2 then

    rsDBorigin = DBorigin("select...FROM table2..")

    Do While (NOT rsDBorigin.EOF)

    Is there a question?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • DECLARE @post VARCHAR(512)

    SELECT @post = 'Hi, we have some asp code right now that transfers contents of three tables from one server to another. Here is how it works right now:'

    SELECT @post = REPLACE(@post, 'works', 'doesn''t work')

    EXECUTE SSC.dbo.usp_CreatePost @post

    :laugh:

  • Sorry, this one was sent before completed by mistake. Please refer to the next one.

    http://www.sqlservercentral.com/Forums/Topic711107-145-1.aspx

Viewing 6 posts - 1 through 5 (of 5 total)

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