Solved

synchronizing / copy SQL 2008 between servers?

Posted on 2012-03-18
1
221 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
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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.

763 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