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 |
|
konfortes
Starting Member
1 Post |
 Posted - 2014-06-22 : 06:49:48
|
| Hey,That a theoretical riddle I've been encountered.Is there any (not ssms built in feature) efficient way I can weekly deploy all data changes that been made to a single DB into a different deployed DB's with the same schema?instead of triggers for all my updates deletes and creates operations, log the statements into a file, and execute it on the deployed DBs might be the direction just that there is a problem with it for example create update update and delete for a single row will execute unnecessary create and 2 updates.any idea anyone? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-22 : 17:26:33
|
| Check our Snapshot and Transactional Replication.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Sql data deployment