Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best way to keep tables in-synch across servers?

Status
Not open for further replies.
JFoushee

JFoushee

Programmer
Oct 23, 2000
200
US
Hello.

There are two databases on two different servers.
Server 1, database X, has various tables, and I want Server 2, database Y to house a subset of the fields from the first one. Then, Server 2 has about 10 extra tables on 6 pulled from Server 1. It is important not to have the tables in the same database.

DTS can delete and re-pull the data from Server 1, but the foreign key constraints on Server 2 complicate matters. Data is not deleted from Server 1, so I'm not worried about orphan-data.

Before I go this route: Can I create a View of the data from Server 1, then put the foreign key constraints on a View?
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
2K
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
952
Volvere
V
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
927
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top