Database Synchronization

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Database Synchronization

Database Synchronization

Rate Topic

Display Mode

Topic Options

Author

Message

tomhexcube

Posted Friday, April 16, 2010 4:48 AM

Forum 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

Joie Andrew

Posted Saturday, April 17, 2010 7:56 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 553, Visits: 1,032

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 »

Permissions