Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

synchronizing / copy SQL 2008 between servers?

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
arthurh88
Asked:
arthurh88
1 Solution
 
hafeezmcaCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now