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.
| Author |
Topic |
|
CEYC
Starting Member
2 Posts |
 Posted - 2004-08-02 : 17:22:45
|
| Hi,I'm trying to sync a table from one database to another (target) for that I'm using Transactional Replication. Is there a way to replicate a table so it does not lose its relations in the target database? Cause every time I sync them using this method the relationships are lost in the target database.ThanxCarlos |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-02 : 17:36:23
|
| You do not have to let replication create the tables for you. You could create the tables how you want them, then just have replication move the data over. So when you set it up initially and you are adding articles, click the button to the right of the table, then go to the third tab (snapshot tab), select delete all data in the existing table.Tara |
 |
|
|
CEYC
Starting Member
2 Posts |
Posted - 2004-08-02 : 18:27:21
|
| Tara, thanks for your answer, I changed the setting and it worked. |
|
|
|
|
|
|
Help, Replication Data...