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
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
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