Red Gate forums :: View topic - Command Line: Compare 2 snapshots and script security change
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Command Line: Compare 2 snapshots and script security change

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
badpig521



Joined: 31 May 2013
Posts: 2
Location: United States

PostPosted: Mon Jun 03, 2013 4:21 pm    Post subject: Command Line: Compare 2 snapshots and script security change Reply with quote

How do I use the command line SQL COMPARE to compare 2 snapshots and use /scriptfile to only create the security change script or sync the users and roles for the database. This is what I am using now:

Code:
Invoke-Expression -Command "&'C:\Program Files (x86)\Red Gate\SQL Compare 10\sqlcompare.exe' /Snapshot1:$Path1\$database.snp /Snapshot2:$Path2\$database.snp /filter: /scriptfile:$scripts /force"
Back to top
View user's profile Send private message
badpig521



Joined: 31 May 2013
Posts: 2
Location: United States

PostPosted: Tue Jun 04, 2013 2:09 pm    Post subject: Reply with quote

Code:
Invoke-Expression -Command "&'C:\Program Files (x86)\Red Gate\SQL Compare 10\sqlcompare.exe' /Snapshot1:$Path1\$database.snp /Snapshot2:$Path2\$database.snp /filter:C:\SQL_SERVERS\SQL_COMPARE\sec.scpf /scriptfile:$scripts /force"


Worked using the /filter and a saved filter from the GUI
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group