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