User profile for Jamie Clayton

Thanks for the reply. I had been using the <Exclude>User:BNE-MYCUSTOMER\~ApplicationGroupName (BNE)</Exclude> or <Exclude>User</Exclude> elements without much luck. I'm using Role based security within the database, so it tested the "Ignore users' permissions and role memberships" in the project properties for the SQL Compare GUI and got very close to the answer I was expecting. If I then remove all my <Exclude>User*</Exclude> entries and replace it with <options>IgnoreUsers</options> I get completely the wrong results in the output script file. (I got this from the "options enumeration" help file). [Comparison to a snapshot]. To answer your question about Objects dependant on the user, I'm not sure exactly how to find the answer to that. However all the objects in the database are using DBO.ObjectName and there are no other user/group owned objects as this an application database managed by out company. Here is how I'm doing it. 1. Have a *.bat file with the following cd C:\Data\Customers\xyz\SqlDatabaseMgmt\Managment DEL Results\*.sql SQLCompare.exe /argfile:SQLCompare_xyzTest.xml pause 2. Config .xml file with <?xml version="1.0" encoding="utf-8"?> <commandline> <snapshot1>C:\Data\Customers\xyz\SqlDatabaseMgmt\Managment\Snapshots\xyz_20070509.snp</snapshot1> <database2>xyz_Test</database2> <server2>sql.xyz.com.au</server2> <username2>mySecureUserName</username2> <password2>@password</password2> <scriptfile>C:\Data\Customers\xyz\SqlDatabaseMgmt\Managment\Results\xyz_Test.sql</scriptfile> <exclude>User:myApplication</exclude> <exclude>User:BNE-MYCUSTOMER\~ApplicationGroupName (BNE)</exclude> <exclude>Role:xyzUsersRole</exclude> <exclude>Role:db_datareader</exclude> <options>IgnoreUsers</options> <force/>  </commandline> I'm expecting to have the Results\xyz_Test.sql file to be blank (non existant) because the only differents are the user and role membership of that user "BNE-MYCUSTOMER\~ApplicationGroupName (BNE)". I guess I'm just having troubles working out the difference when driving the application from a command line (*.xml) file to the GUI, however I've got dozens of databases that are setup in similar ways, which I would like to compare nightly to ensure we don't have "db Administrators" breaking a database structure. / comments

Thanks for the reply. I had been using the <Exclude>User:BNE-MYCUSTOMER\~ApplicationGroupName (BNE)</Exclude> or <Exclude>User</Exclude> elements without much luck...

0 votes

Ok here is a simple example CREATE LOGIN [Jenasys] WITH PASSWORD=N'AshesTestMatch', DEFAULT_DATABASE=DB_2, DEFAULT_LANGUAGE=[British], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON GO USE [DB_1] GO /****** Object: User [dbo] Script Date: 11/17/2006 11:17:07 ******/ GO CREATE USER [dbo] FOR LOGIN [jenasys] WITH DEFAULT_SCHEMA=[dbo] USE [DB_2] GO /****** Object: User [jenasys] Script Date: 11/17/2006 11:17:31 ******/ GO CREATE USER [jenasys] FOR LOGIN [jenasys] WITH DEFAULT_SCHEMA=[dbo] If I use SQL Compare against these two database the program doesn't seem to understand the difference between the user/role/schema components and a sync will fall over. Does this make sense? I'm getting this a lot with clients as the setup database inconsistently via the IDE (aka IT Admin who have been given control of SQL Server). / comments

Ok here is a simple exampleCREATE LOGIN [Jenasys] WITH PASSWORD=N'AshesTestMatch', DEFAULT_DATABASE=DB_2, DEFAULT_LANGUAGE=[British], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON GO USE &...

0 votes

No problem, just give me a few days, to get the scripts together. I've got an application error to resolve in some of our software first. / comments

No problem, just give me a few days, to get the scripts together. I've got an application error to resolve in some of our software first.

0 votes

Brian, Sorry about the typo with your name. :oops: / comments

Brian, Sorry about the typo with your name. :oops:

0 votes

G'day Jonathan, Both of the databases I'm testing are hosted in SQL 2005 Standard edition. / comments

G'day Jonathan, Both of the databases I'm testing are hosted in SQL 2005 Standard edition.

0 votes

G'day Biran, :oops: I think it was a little unclear in my post, but I did try the [dbo] - [JenasysDesign] map owners. However behind the scenes dbo/Jenasysdesign had different users (=owners in SQL Compare - my assumption). This didn't work for me. All I can think is that there were different scheme/user maps behind the two. Anyhow, if your correct and [x].table <> [y].table, then shouldn't that be displayed in Compare 5.2's results screen. At the moment [y].table doesn't get shown at all. Can you confirm this, or is it a PEBKAC issue. / comments

G'day Biran, :oops: I think it was a little unclear in my post, but I did try the [dbo] - [JenasysDesign] map owners. However behind the scenes dbo/Jenasysdesign had different users (=owners in SQ...

0 votes

How can we help you today?

Jamie Clayton

Comments