script copying tables From to server on other machine.

  • Is it possible to script operation of copying table from a database on a Sql Server to other Sql Server in other machine ?

    thanks

  • Yes, is the short answer. are you talking about all of the data. there are various ways of doing this.

    including using SSIS or select into amongst others.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • not all the data , few tables need to be copied periodically

    how can i do that script?

    in a headlines please.

    best regards

  • You can create a linked server, then

    insert into Server_B.Database_B.dbo.Table_A

    select * from Database_A.dbo.Table_A

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

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