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 2000 Forums
 SQL Server Development (2000)
 Replication / Contrainst Question

Author  Topic 

lotek
Starting Member

42 Posts

Posted - 2005-10-03 : 16:50:51
I have two databases on the same sql server. (At some point they may be on different servers though). I want to replicate some of the data from database1 to database2 (a couple fields from a couple tables) so i can make key contraints and have cascade deletes etc. I have never got my hands dirty with replication and what not so im hoping for someone to give suggestions and point me in the right direction. Ideas?

Thanks
Matt

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-10-03 : 22:16:14
read replication in BOL and try it out first, if you encounter any problems, post it at the dts/replication forum and we'd help in any way we can



--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -