Red Gate forums :: View topic - Compare a large DB to another, no connection between
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

Compare a large DB to another, no connection between

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



Joined: 08 May 2014
Posts: 1
Location: Australia

PostPosted: Thu May 08, 2014 11:09 am    Post subject: Compare a large DB to another, no connection between Reply with quote

hi ,

I have a large DB (+50Gb) at a client site, I have full remote access to it, but is via Citrix not RDP/VPN , so is a remote terminal in a web browser

I have the same db on my side, I have made a lot of changes to the db (table structures/sProcs/Views etc) on my side.

I want to use SQLCompare which I have installed on MY side but NOT on the client side

Anyway to do that without comparing using a backup of the client's db ? (because too big to backup and FTP or Dropbox to myself).
Back to top
View user's profile Send private message AIM Address
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Mon May 12, 2014 10:19 am    Post subject: Reply with quote

Thank you for your forum post.

Firstly, providing SQL Compare running on your side of the connection can obtain a connection to the remote client database, you have two choices.

1. Perform the comparison as normal, the comparison may take a little longer to complete. On completion review the results and deploy the changes.

2. Connect to the remote client database. From the File menu select the option to 'Create snapshot...', to create a SQL Compare Snapshot file of the remote database. A SQL Compare snapshot is a binary representation of the database objects no actual rows of data are included. Compare the local database to the snapshot created, review the results and generate a deployment script. Copy the deployment script to the remote computer and run it to deploy the changes.

I hope the above answers your question.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Michelle Taylor



Joined: 30 Oct 2006
Posts: 528
Location: Red Gate Software

PostPosted: Tue May 13, 2014 10:54 am    Post subject: Reply with quote

If you can't connect to your SQL Server in any conventional way, but you can move files to the server, you could also use SQL Snapper to get the snapshot of the remote database.

You need to move the files RedGate.SQLSnapper.exe, RedGate.SOCCompareInterface.dll and System.Threading.dll from the SQL Compare install directory to any directory on the remote server, then run SQL Snapper and generate a snapshot.

Then you can move that snapshot file (which, just being the schema, should be considerably smaller than a backup file) back to your local machine and use that as the client DB copy.
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