Red Gate forums :: View topic - SQL Compare command line dependencies
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

SQL Compare command line dependencies

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



Joined: 13 Mar 2014
Posts: 7
Location: Canada

PostPosted: Thu Apr 24, 2014 2:37 pm    Post subject: SQL Compare command line dependencies Reply with quote

Hi,

I'm trying to compare a database in a SIT environment with another database in the User Acceptance one.

The problem is that
1) This two networks do not talk to each-other and they never will (no connectivity between them is possible)
2) UAT environment is HIGHLY restricted when it comes the time to have software installed on it
3) The backups are huge so moving a backup across the wire for DB comparison sake is a no-no.

So, Schema Compare will not be able to do database compare (because of issue #1) and I can't use backups either (because of issue #3). I'm left with the possibility of using snapshots or Script Folders.

My problem now is that because of issue #2. I can't install a fully fledged version of SQL Compare 10 in UAT (sysadmins will never let me do that) but I'm thinking that maybe a downsized version containing only the minimal components allowing me to create a snapshot of the DB in UAT could be the way to go.

That's how I ended up with this question: Is it possible to install SQL Compare command line without the other SQL Compare components? does the command line have dependencies with the SQL Compare main software (the GUI and all the other software I will not be able to install) or is a standalone (xcopy) type of binary?

I highly doubt sqlcompare will work without the software installed, so if that is the case. Is there a way to create a snapshot or script folder without installing the software (or making a very minimal installation)?

Thanks!
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Thu Apr 24, 2014 2:57 pm    Post subject: Reply with quote

You could look at the automation pack- it's essentially command line versions of Compare (and some of the other tools) See here
Back to top
View user's profile Send private message
msurasky



Joined: 13 Mar 2014
Posts: 7
Location: Canada

PostPosted: Thu Apr 24, 2014 3:10 pm    Post subject: Reply with quote

Will Do

Thanks James!
Back to top
View user's profile Send private message
gbellicourt21



Joined: 07 May 2014
Posts: 1

PostPosted: Wed May 07, 2014 7:29 pm    Post subject: Reply with quote

Many thanks James for the tip. Will definitely try it out.
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