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

Showing status

rdobrichrdobrich Posts: 60
edited November 30, 2005 6:23AM in SQL Compare Previous Versions
Hi,
I just compare two databases, and have different result with old and beta SQl compare.
Old shows correctly result.
Beta shows in upper window some stored procedures and functions to be different ( they are identicly), but in detail windows shows that they are the same for every row.

I have screen shot, but I don't know how I can post it[/img]

Comments

  • Options
    I just found what was the problem.

    I options I have option 'ignore permision' uncheck.
    For that functions and stored procedures I have different permisions.
    I have permisions into role on that objects.

    When I try to sinchronize them nothing happens.
    I have the following script (the scripts are the same for including role filter or excluding. )

    I don't know how I can see difference in role security.

    /*
    Script created by SQL Compare from Red Gate Software Ltd at 30.11.2005 9:51:52
    Run this script on bogibatina.birin to make it the same as server3.birin
    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
    BEGIN TRANSACTION
    GO
    IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
    GO
    @TRANCOUNT>0 BEGIN
    PRINT 'The database update succeeded'
    COMMIT TRANSACTION
    END
    ELSE PRINT 'The database update failed'
    GO
    DROP TABLE #tmpErrors
    GO
  • Options
    Andras BAndras B Posts: 249
    edited December 21, 2005 1:23PM
    rdobrich wrote:
    I just found what was the problem.

    I options I have option 'ignore permision' uncheck.
    For that functions and stored procedures I have different permisions.
    I have permisions into role on that objects.

    When I try to sinchronize them nothing happens.
    I have the following script (the scripts are the same for including role filter or excluding. )

    I don't know how I can see difference in role security.

    Hi,

    could you send me just the permissions on this stored procedure pair. Also could you indicate which permission is assigned to a role or a user. My email is:
    Andras.Belokosztolszki "AT" red-gate.com

    Regards,
    Andras
    András Belokosztolszki, PhD
    Red Gate Software Ltd.
This discussion has been closed.