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 |
|
JeremyVnc
Starting Member
2 Posts |
 Posted - 2007-09-04 : 11:28:04
|
| I'm pretty new to the whole replication method. I've been making c++ programs to replicate the databases using manual odbc classes. I'm ready to try something new if it would work for me. I have multiple databases. Basically I have a bunch of computers, each with a SQL server. These databases are the "publishers" due to the fact they are the databases that receiving new data. All of the publishers then upload their new information to the main SQL server. This seems not an issue but the trick is when the publisher uploads the information to the new SQL server, it then deletes the uploaded information from itself. This is basically the same model for everything I do. I was hoping someone might be able to tell me how to do this with replication/triggers and what versions of SQL Server 2005 that I would need to put on each of the publishers and subscriber (main).Thank you,Jeremy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-04 : 12:37:05
|
| Since you are deleting the data at the publisher and don't want that change replicated to the main database, you would need to disable the option to replicate delete commands. Make sure that only insert and update are selected. You can do this in the wizard. You should look into transactional and merge replication to see what will work best for you. You do not need to use triggers.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
JeremyVnc
Starting Member
2 Posts |
Posted - 2007-09-04 : 13:00:01
|
| Thanks for the reply. How would I go about deleting the information from the publisher while still not deleting the data from the subscriber. I'd like to have this be an autonomous or triggered replication. I was thinking transactional would be the ticket. I've never setup a replication before so I don't know how they work. I'm reading about them right now. Btw, to test this I've installed sql 2005 express with sql 2005 management studio.-Jeremy |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-04 : 13:04:47
|
| Like I said, you would specify that option in the replication wizard.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-04 : 23:02:59
|
| Keep in mind that sql2k5 express can only be subscriber of transactional replication. |
|
|
|
|
|
|
Will Replication work for me?