synchronizing / copy SQL 2008 between servers?
Posted on 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?