User profile for Jamie Clayton

Code to trigger snapshots

G'day, I've got a memory issue that I really want to measure at an exact point in the code tree to ensure that any modifications I make between run's are easy to compare results. Is there a way to ...

1 follower 1 comment 0 votes

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

SQL Compare - Exclude User problem

G'day, I'm currently remotely supporting a clients databases and using the SQLCompare.exe command line + *.xml configuration arguments file to compare databases with snapshots. One of the problems ...

2 followers 2 comments 0 votes

Command Line Script File syntax limiation.

G'day, In a group development/support environment I've setup a series of Command Line scripts + XML configuration files to report on the differences between database (SQL Compare). One of the prob...

1 follower 1 comment 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

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

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

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

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

Schema vs Ownership comparison.

G'day, Just stuck trying to get SQL Compare to work under the following senario. 1. Created a blank database. 2. Compared and existing database to the blank, to generate a "duplicated" script. 3. I...

3 followers 8 comments 0 votes

How can we help you today?

Jamie Clayton

Activity overview