Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Creating Database snapshot using Batch file

Author  Topic 

lnkiran0406
Starting Member

1 Post

Posted - 2012-11-06 : 11:12:44
Hi,


I need to create a batchfile using commandline redgate sql compare to create database snapshots and store them in a local drive.

I want to use my windows login to authenticate and then have to connect server to create the snapshot.

like,

C:\Program Files\Red Gate\SQL Compare 10\sqlcompare.exe /server name:WidgetStaging
/MakeSnapshot:"C:\Widget Snapshots\StagingSnapshot.snp"

Please help me with this
   

- Advertisement -