November 20, 2009 at 2:25 am
Is it possible to script operation of copying table from a database on a Sql Server to other Sql Server in other machine ?
thanks
November 20, 2009 at 2:29 am
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]
November 20, 2009 at 3:13 am
not all the data , few tables need to be copied periodically
how can i do that script?
in a headlines please.
best regards
November 20, 2009 at 8:00 am
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