View was deployed despite being unchecked

Forum for users of SQL Compare schema synchronization utility

View was deployed despite being unchecked

Postby fitparrothead » Tue Jan 31, 2012 3:30 pm

Today I was comparing my test database with my QA database. I had a view that was on both machines but the test database had a newer version that wasn't ready to be deployed to QA yet. I compared the two databases, selected all items, and unchecked one table and one view. I then created the script and ran it. However, the view was in the script and it was synced.

I made another change and was able to reproduce this same behavior again.
Posts: 1
Joined: Tue Jan 31, 2012 3:26 pm
Location: Juno Beach, FL

Postby james.billings » Wed Feb 01, 2012 8:27 pm

Hi, thanks for posting, and sorry you've had some trouble.

By default we'll often include dependencies. When you ran through the deployment wizard, did you spot if the checkbox was set to include dependencies? This may have been what then included the View.

If the problem persists, then we'll need to investigate a little more.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest