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?
arthurh88Asked:
Who is Participating?
 
hafeezmcaConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.