Thomas
Reputation: 34188
How to sync data between two table in two different database
Suppose I have two sql server databases and having same schema. I want to synchronize data between two table of that two databases.
How could I do this? Is there any free open source good library which help me to develop this sort of apps or is there any already free dotnet apps which do the task?
Upvotes: 0
Views: 1692
Answers (3)
Can Gencer
Reputation: 8885
Take a look at SQL Server Replication. It is possible to replicate only parts of the database or the database as a whole.
Upvotes: 1
tucaz
Reputation: 6684
If it is Sql Server that you are using you also have the option of using Sql Server Replication.
Upvotes: 1
RoughPlace
Reputation: 1121
Do they need to be synchronized 24/7 or is overnight Synchronization acceptable?
Upvotes: 0
Related Questions
- How to synchronize data between two tables in different databases
- How to synchronize two tables stored in different databases
- How to synchronize 2 databases
- Synchronize two SQL Server 2008 databases
- Synchronizing 2 databases
- Synchronize data between two sql server 2008 database with ado.net sync framework
- Using C# to Sync two tables in different databases
- Syncing between two databases
- Sql server database synchronisation
- Synching two table in SQL Server