The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Synchronizing databases

I have a SQL Server 2005 web database and a local SQL Server 2005 database. I want a tool that can synchronize both the database from the source (web) to the target (local).
Rohit Send private email
Tuesday, May 15, 2007
 
 
This tool works really well, although I haven't personally tested it with SQL2005: www.red-gate.com/products/SQL_Data_Compare/index.htm
Twin Bing Send private email
Tuesday, May 15, 2007
 
 
Whats wrong with the internal SQL Server Replication Funcinality?
Anon Ranter Send private email
Tuesday, May 15, 2007
 
 
1. SQL Express and workgroup versions don't have the replication feature.

2. An existing database may not have it enabled, and maybe they don't want it enabled.

3. It is a one-time synchronization, not an on-going constant replication.

If they want on-going replication, then they should use the SQL Server replication.
XYZZY
Tuesday, May 15, 2007
 
 
The synchronization I want to do is on a regular day-to-day basis.
Rohit Send private email
Wednesday, May 16, 2007
 
 
You can make your own tool to do it with Microsoft Synchronization Services for ADO.Net (currently in Beta).

If you don't want to use a beta toolkit, you can always study Microsoft Sync services to figure out how to do it yourself with straight SQL. It's not that hard.
Wayne B Send private email
Thursday, May 17, 2007
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz