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 |
|
mcintyre321
Starting Member
1 Post |
 Posted - 2005-04-08 : 09:27:13
|
| I work a for a firm that maintains a software product with a built in daily updated database. We make changes to various tables, each of which has identity columns to make the refs for new records. Note we only make new records with refs > 10000 in each row. I'll tell you why in a second.Whenever a change is made using our import tool, it gets logged, and once a day a DTS package is used to copy all the new and updated records into an Access database file. We send a copy of this to all our clients, who apply it using some custom software that DTS's it into temp tables and then uses some SPs to put it into the tables its meant to go into.The reason we dont go below 10000 is that these are reserved for new records as created by the clients... I've beeen asked to find out if SQL server can do all this without us having all this code and stuff to maintain, or if we need to write a better application (now we want to change the columns and stuff this is becoming a little bit tricky you see).anyhow, can SQL replication produce, once a day, or however often, a file which can be sent out to clients which will sync their tables (except below 10000)with ours? which kind of SQL replicationwould that be?thanks for your help folks |
|
|
|
|
|
Is SQL replication suitable for my situation?