Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Synchronization Expand / Collapse
Author
Message
Posted Friday, April 16, 2010 4:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 16, 2010 4:44 AM
Points: 1, Visits: 0
I am using SQL Server 2005.

I am working on a project where there will be same database in different machine but there is no network between these machines. Each database will have the exact same schema but will be accessed by different groups of users.

What is the easiest way to synchronize the data? All data from workstations need to update in the main server database. I would like to have a single "master" database to keep in server

Is there any option to do through SQL server or do we need to write separate update script for each table? How do we copy data from one system and update to main server

- Thamaraikkani
tomhexcube@gmail.com
Post #904684
Posted Saturday, April 17, 2010 7:56 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 11:09 AM
Points: 689, Visits: 1,351
If the copy of the database is not going to have any of its own original data, then you have a couple of options.

- You could copy over a backup of the main database and restore the secondary database overwriting the data with current data on a regular basis

- You can create an SSIS package to export the data to flat files. The package can run on a schedule and you can sneakernet (as you have stated the two do not have any network connectivity) the files over to the secondary database. Another SSIS package or even a bcp job can import the data in


Joie Andrew
"Since 1982"
Post #905512
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse