What are the challenges you face when working across database platforms? Take the survey
Options

Comparer ver. 6.2.0.271

tibistibis Posts: 2
edited June 6, 2011 9:52AM in SQL Compare Previous Versions
Hello, please help me to exclud logins, users from comparasion results. The resulted script is like this:
/*
Script created by SQL Compare version 6.2.1 from Red Gate Software Ltd at 03.06.2011 08:58:22
Run this script on (local).RESUM_GScript to make it the same as (local).RESUM
Please back up your database before running this script
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'tibi')
EXEC sp_addlogin N'tibi', 'p@ssw0rd'
GO
EXEC sp_grantdbaccess N'tibi', N'tibi'
GO
PRINT N'Altering members of role operator_pontaj'
GO
EXEC sp_addrolemember N'operator_pontaj', N'tibi'
GO
BEGIN TRANSACTION
GO
IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT>0 BEGIN
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO
DROP TABLE #tmpErrors
GO

but in this case i want to have no differences.
I'm using sqlcomparer console app with xml arguments files.
I've tried:
<options>if,iw,incd,ifg,iup,iweo,iu</options>
or
<options>IgnoreUsers</options>
but the generated script is even more complex, like redefining procedures and other things.
I just want to get rid of login/members/role/user from resulted script.
Thank you.

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    You may need to "exclude" the object types you don't want to use.

    Look at the /exclude switch in the commandline help for information. You can get a textfile of the commandline parameters by running:

    sqlcompare /? /verbose > help.txt
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.