Home
Topics
Microsoft SQL Server Administration
SQL Server Replication
Tool to synchronize two SQL Server databases

Ask the Expert

Tool to synchronize two SQL Server databases

Denny Cherry, Contributor

How can I synchronize two SQL Server databases so that changes to one database, i.e., Insert/Update, will synchronize with the other database, and vice versa?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

You will want to use the merge replication tool to achieve this goal. Merge replication is designed to move data between multiple systems, where the data can be updated on any of the systems.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- replication

This was first published in March 2008

There are Comments. Add yours.

Sort by: Oldest Newest

Next

View All Comments

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- IDC analysts see more Internet of Things projects ahead
  
  At IDC Directions, analysts predict more Internet of Things projects in the near future.
- New BI reporting, data analytics tools give users a business edge
  
  More affordable and easier-to-use software is enabling companies in various industries to embrace the power of business intelligence and analytics.
- Cognitive computing for all? Think about it
  
  Machines like IBM's Watson are becoming as smart as we are. And soon the technology may become elementary to many more than just Big Blue.
Data Center
- Traditional IT silos face a hostile software-defined environment
  
  Think you got rid of data center silos when you adopted virtualization? Not so fast. Software-defined data center tools promise more silo-busting.
- Data center consolidation best practices: Lessons from the trenches
  
  Eliminate the inconsistencies between facilities with a data center consolidation plan. Enterprises share their experiences and advice for success.
- The right time to embrace server automation tools
  
  Understanding your organizations' circumstances and requirements can be the difference between server automation success and failure.
Data Management
- Think Big Analytics' Bodkin: Big data adoption means breaking silos
  
  Hadoop has the ability ultimately to break down siloed data stores, Ron Bodkin says in a Q&A.;
- Virtual assistant technology: More than just IBM Watson
  
  It might be all over the news, but IBM's megacomputer Watson isn't the be-all and end-all in virtual assistant technology.
- NoSQL database system, no problem?
  
  The slew of databases designed to handle the reams of data being produced today hold an allure, for sure. But the IT problem you’re trying to solve comes first -- or you could be in for it.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- The case for commodity hardware vs. Oracle Exadata architecture
  
  A former Oracle sales rep does a 180 by pushing his company not to buy an Exadata system, but to upgrade existing data center infrastructure instead.
- For Oracle disaster recovery, check your physical standby databases
  
  Database expert Michael Abbey explains what's needed to ensure that your Oracle physical standby databases are vetted and work properly.
- How to escape the no-win Oracle SLA as a DBA
  
  Escaping the no-win Oracle SLA as a DBA is all about tying technology to business, according to two Oracle Database experts.
Content Management
- BPM projects must come from top down, says Oracle Collaborate speaker
  
  While trends such as mobility have changed BPM from the bottom up, BPM projects should come from the top down, said an Oracle Collaborate speaker.
- Metadata landmines in SharePoint migrations
  
  Migrating to SharePoint, particularly from a third-party platform, can wreak havoc on metadata if you don't know what you're dealing with.
- Cloud, mobile up the ante for identity and access management strategy
  
  An identity and access management strategy has become more essential for enterprises now that data resides in the cloud and on mobile devices.
Windows Server
- Windows Server 2012 R2 updates come alongside light Patch Tuesday
  
  An RTF exploit gets patched for Microsoft Office in this month's Patch Tuesday update. Plus, Microsoft updates server and client OSes.
- Microsoft Azure continues cloud pricing game of limbo with AWS, Google
  
  Microsoft will lower its Azure cloud prices to match price cuts made by AWS and Google, but is it enough to attract new customers?
- Complete these critical steps to migrate to Windows Server 2012
  
  Make sure your enterprise follows these tips and tricks to make your Windows Server 2012 migration easier.

All Rights Reserved,Copyright 2005 - 2014, TechTarget