April 16, 2010 at 4:48 am
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
April 17, 2010 at 7:56 pm
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"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply