December 22, 2003 at 1:20 pm
I have a customer that has 3 remote sites and a central office. Each is running SQL 2K. The application is running in all sites.
This Applications is an invantory control system. No Comunications between sites. I keep the total inventory qty at central and remotes and both do operations (movemens,transactions) on the same item anytime.
I want to keep both inventories updated.
Is there a package that can merge informacion between remote and central office without being connected?
December 22, 2003 at 2:22 pm
No, you can't. You must have a conecction. It can be a Dial up connection.
Unless you manually transfer the changes by CD, diskette or wathever.
December 22, 2003 at 6:18 pm
Ok, That is what I plan to do, To transfer the informacion by CD daily. But this informacion that I transfer by CD will only be the changes since last update?
December 23, 2003 at 6:07 am
I don't think you can do it with SQL replication, only with snapshot. Because Transactional replication will save the changes into the SQL Log file, and merge replication saves changes in tables.
Maybe you could set Merge replication and get the changes from those tables but you will have to create a process to manually built the updates, deletes and inserts.
You could also create a process that saves the changes to temp tables (maybe with triggers) and saves those changes in the cd.
Or also could use snapshot replication that will always repicate the entire publication.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply