Posts
Sort by recent activity
How Can I Increase Database Connection Timeout
When attempting to connect to a remote SQL Server machine, I'm experiencing connection timeouts. In SSMS I can change the connection timeout to a larger value and connect. I cannot find a place to ...
Why do I receive "installer has insufficient privileges to access <...>\Website\Download" ?
Attempting to update to 8.0.15.15813 I am receiving this error dialog while it's "Configuring SQL Monitor Web 8". Using built-in web server.I am logged into the machine as an admin. When I attempt ...
Images Seem To Be Being Reused When New Images Are Created
Here's our situation:
We perform nightly backups, and copy the BAK file to a location.
The next morning, I use the following script to create a new Image from the latest BAK file:# Script to create...
SQL Source Control 5 data-only migration script not syncing
Created a "data only" migration script for the sole purpose of updating one record in a table (we're experimenting with using this to deploy DML scripts).
The script:
/*
Use this migration script t...
Dependency Issue With New Stored Proc and Altered View
Here's our situation:
We use SQL Source Control to source control our database(s). We use SQL Compare command line to generate a deployment script for us to update test and other databases. We're h...
SQL Compare 10.7 Cmd Line Not Including Migration Scripts
On machines where we still have version 10.4 installed, our migration scripts are being included in the generated deployment scripts. However, on machines that have been updated to version 10.7, th...
Command Line Switch AddDatabaseUseStatement Not Working
I've added this to the command line, but my script doesn't have the USE statement. Here's a snippet from the powershell script that executes my comparison:
sql_compare /Database1:FACTSInfo /Version...
Release notes?
I am looking for a page with release notes for SQL Compare 10.3 (and all other SQL Toolkit products, for that matter).
Does one exist? If not, can someone please list the changes from 10.2 to 10.3...
Issue with committing a rolled-back object
We're using TFS as our repository. At some point, someone accidentally checked in (via SQL Source Control) a bogus copy of a stored procedure.
Instead of reverting the script/object in SSMS, I used...
Issue With Restoring Database After Checking In Changes
Here's the process I thought that we would follow. We're using version 3.1.
We have a production database with nightly backups, and need developers to restore that to their development environment ...