MS-SQL DBDiffer

DBDiffer v1.0 readme

Overview

 DBDiffer is a tool, meant to help users finding differences between two SQL Server databases
 as far as tables, functions and stored procedures they contain are concerned.
 It’s a simple SSIS component which logs all differences between two provided databases.

 

Recquirements

       
  • Microsoft SQL Server Business Intelligence Studio or Microsoft Visual Studio BI

    •    

  • SQL Server must be installed on your C:> drive in the program files directory.
        Make sure the directory c:Program FilesMicrosoft SQL Server90DTSTasks
        exists on your system. Otherwise the installation will fail. We apologize for
        this, and we will try to solve that issue for the next version.

    •   

  • Two databases, not necessarily hosted on your local server.

    •   

  

 Installation

  After unzipping DBDiffer_v1.zip, you’ll find the following files:
  

      
  •  Readme   :    The current file

    •   
      

  • Install.bat  :    A BAT file, to be run for DBDiffer installation

    •   
      

  • gacutil.exe  :    The Global  Assembly Cache utility

    •   
      

  • DBDiffer.dll :    The DBDiffer core DLL

    •   

  To install DBDiffer, just double click the Install.bat file. You will have a confirmation
 message telling you whether the installation goes well.
 

Use

 

  •  Open Microsoft Visual Studio BI
     
     
  •  Create a new Integration Services project

    •  
     

  •  Add a new package to the project and open it for edition

    •   
     

  •  If it’s your first use of DBDiffer, you’ll need to register the component, in order
      to get it loaded in your toolbox panel by default. To perform this:
      
       -> Right click in the toolbox area, and select choose items
       -> Select the SSIS Control Flow Items tab
       -> Find the DBDiffer Task and check the relative checkbox
       ->  Click Ok
     

    •  

  •  Drag and drop the DBDiff component from the toolbox to the package edition area

    •  
     

  • Create needed Connection Managers:
     
       -> (02) OLEDB Connection
       -> (01) File Connection
      

    •  

  • Either double click on the DBDiff component to launch it’s configuration form or
      Select the component, and show the property panel to set the following properties:
      
       -> Source ConnectionManager name
       -> Target ConnectionManager name
       -> Output File ConnectionManager name
       
  •  Save the package, and run it.

    •  
     

  • Check the output file specified, to read DBDiffer ’s log. They are basically
     two types of log message for now.
     
       -> Info: which logs inline actions DBDiffer is performing
       -> Error: For differences notification.
       

    • A special thank to Emmanuel ANDRIEU for his helpful guidance.

    For further details please contact lo okou ster@gm ail.com

    Download

    Download link