View was deployed despite being unchecked

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

View was deployed despite being unchecked

Postby fitparrothead » Tue Jan 31, 2012 4: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 4:26 pm
Location: Juno Beach, FL

Postby james.billings » Wed Feb 01, 2012 9: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: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests