Writing frmo Source Server to Destination Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Writing frmo Source Server to Destination Server

Author

Topic

tajdin
Starting Member

2 Posts

Posted - 2009-04-27 : 06:04:31

Hi,

I have Two SQL Servers - Main Server (ServerA) attached to Network and Local Server (ServerB) on local harddisk

Both these Servers have Difference DataBase DBAA and DBAB

Both Databases have common structured table (Same Fields) TableA and TableB

Now I want to add Write Data to Source Server from Destination Server, i.e.

From ServeA.DBAA.dbo.TableA to ServerB.DBAB.dbo.TableB

edit: moved to correct forum

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-04-27 : 06:32:11

It depends a little on what you mean by "write", there are many ways to do this. But from what I can understand you are looking for linked servers (look up "linked servers" in Books Online). They will let you write queries typically like this:

INSERT INTO ServerB.databasename.dbo.TableA (ColumnA, ColumnB)
SELECT ColumnA, ColumnB
FROM ServerA.databasename.dbo.TableA
WHERE ...

- Lumbago

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources