Skip to content

Instantly share code, notes, and snippets.

@carlhoerberg

carlhoerberg/SyncDB.cmd

Created May 27, 2010 11:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save carlhoerberg/415714 to your computer and use it in GitHub Desktop.
Save carlhoerberg/415714 to your computer and use it in GitHub Desktop.
Download ZIP
Sync two MsSql databases
Raw
SyncDB.cmd
@echo off
setlocal
set path="%programfiles%\IIS\Microsoft Web Deploy";%PATH%
msdeploy -verb:sync -source:dbFullSql="Data Source=.\SQLEXPRESS;Initial Catalog=MyDB;Integrated Security=true",computerName=yourcomputer.com ^
-dest:dbFullSql="Data Source=.\SQLEXPRESS;Initial Catalog=MyDB;Integrated Security=true",dropDestinationDatabase=true
endlocal
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment