Solved

synchronizing / copy SQL 2008 between servers?

Posted on 2012-03-18
1
229 Views
Last Modified: 2012-03-18
I have MSSQL 2008 web version that is part of a website, and just got a new server.  Now I need to migrate my whole website to the new server. So that means I need to move the database, but I want to do so in a way that lets me keep my existing server live for now, while I setup mail, IIS, etc.  Is there a way I can configure SQL on my existing server to "push" all changes to my new server so that I know the DB on my new server will always be current and ready for live use?
0
Comment
Question by:arthurh88
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 5

Accepted Solution

by:
hafeezmca earned 500 total points
ID: 37734248
Hi,
You can use Sql Replication service to acheive this task.
The Microsoft documentation for replication is quite thorough. I would suggest using the following link as your starting point and then selecting the track/s that are most appropriate to you i.e. Architecture perhaps initially.

http://msdn.microsoft.com/en-us/library/ms151198.aspx

You should eventually get to specific replication implementation scenario tutorial that is appropriate for your environment.

There is a replication wizard as well to simplify the task.
Follow the below URL for the wizard:

http://msdn.microsoft.com/en-us/library/ms151154.aspx
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question