extra object (schema) when comparing source control to a DB

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

extra object (schema) when comparing source control to a DB

Postby ajmudrak@rutgers.edu » Fri Feb 14, 2014 6:45 pm

When performing a SQL Data Compare between a database I have in SQL Source Control and a live database, there is an extra object appearing in the Source Control version that actually does not exist. The extra object is a schema for a user that was not included in source control (filtered).

On the database that is linked to source control, the schema itself doesn't even exist. The user that it belonged to does, but that user account is filtered from source control, and was never committed.

On the destination live database I'm trying to copy the schema to, the schema doesn't exist, and it shouldn't.

When I checked out the source control copy of the database to a folder, and searched through the .SQL scripts, I couldn't find anything in there that included this schema.

Do you know why it might think that the schema exists and is trying to add it to my live destination database?

Thanks!

--
Andy
ajmudrak@rutgers.edu
 
Posts: 1
Joined: Fri Feb 14, 2014 6:35 pm

Postby Anu Deshpande » Tue Feb 18, 2014 11:29 am

We have logged a support ticket for you and will email you shortly.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Brian Donahue » Fri Jun 27, 2014 1:44 pm

Might be some backward-compatibility issue with SQL 2000, because back then schemas did not exist and were the same as users. I seem to recall some older versions of SQL Compare made a schema for a user when going from 2000 to 2005. (of course these days SQL 2000 support has been dropped entirely so I don't think the latest version would do that).

It's also possible that there is some object either owned by or has permissions set for that schema and it's being created as a dependency.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests