Comparer ver. 6.2.0.271
tibis
Posts: 2
Hello, please help me to exclud logins, users from comparasion results. The resulted script is like this:
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.
/* 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
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
Redgate Software