Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    May 2005
    Location
    Germany
    Posts
    43

    Default Compare MS SQL Server data bases

    Hello,

    actually I have a problem and it would help me, if I could compare the content of two databases (MS SQL Server, tables with same name and structure - I hope )

    For BC2 I detetced "{url=http://www.scootersoftware.com/download.php?zz=kb_morerules]Rules That Use External Conversion[/url]" include MS SQL Server Object/MS SQL Server SELECT.

    Is there something similar for BC3?
    Stummfilm - ich bin dabei!

  2. #2
    Join Date
    Oct 2007
    Location
    Pennsylvania
    Posts
    1,772

    Default

    Beyond Compare has never had the ability to connect to a SQL Server database and compare live SQL Server objects. A SQL plug-in is available to enable BC2 to compare exported SQL server objects (SQL scripts exported to text files). BC3 comes with built-in file formats including the ability to compare SQL Scripts without the need for an additional file format plug-in.
    BC v4.0.7 build 19761
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

  3. #3
    Join Date
    Jan 2012
    Posts
    1

    Default

    Do you know if there is a mySQL plugin for BC?

  4. #4
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    4,584

    Default

    Sorry, BC doesn't have a mySQL plug-in. To compare data from mySQL, you'll have to dump it to a text file (.sql, .csv, etc), then open it in the Text Compare (.sql) or Data Compare (.csv).
    Chris K Scooter Software

  5. #5
    Join Date
    Oct 2011
    Posts
    31

    Default

    Did someone make more headway in this direction for comparing DB's - Scheme or Data?

  6. #6
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    11,371

    Default

    Hello,

    Directly connecting to DB's is still not something we support. You need to Export to a local file first, then we can compare that export. It looks like you also found this thread, which may have some tools for helping compare the local files:
    http://www.scootersoftware.com/vbull...r-SQLite-files
    Aaron P Scooter Software

  7. #7
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    11,371

    Default

    Thanks.

    In addition to Michael's comments that SQL is a built in File Format, BC3's trial is fully featured with only the days-of-use time limit. You do not need to uninstall BC2. That way you can trial BC3 while still keeping BC2 on your system for day to day use.

    http://www.scootersoftware.com/download.php

    Please let us know if you have any questions.
    Aaron P Scooter Software

  8. #8
    Join Date
    May 2005
    Location
    Germany
    Posts
    43

    Default

    Hello,
    Quote Originally Posted by Michael Bulgrien View Post
    Beyond Compare has never had the ability to connect to a SQL Server database and compare live SQL Server objects.
    I found a way to compare live SQL Server objects/datasets.

    The main idea is simple:
    You can define file formats to compare files after a conversion.
    You need only a 'conversion' doing a database selection and store the result in a file.

    I added a ruby solution in my gem bc3 (version 0.2.0).
    To use it, you need ruby with gems bc3, log4r and sequel. The example and unit test requires also sqlite.

    The gem contains file format definitions to use the tool (bc3/examples_db_connect/BCSettings_db4bc3.bcpkg).

    The files to compare contains a definition of the database connection and selection (and of the result you want).

    See the example in the screenshot. The files to compare looks like this:
    Code:
      adapter: sqlite
      db: ./test.db
      tab: languages
      show_sql: true
      data: csv_tab
      headline: true
      filter: 
        - :key: [ 1, 2, 3, 4, 5, 6, 7, 8 ]
    (the 2nd configuration file does not contain the filter).

    More details at http://rubypla.net/bc3/0.2.0/ ( deeplink: here and here)


    One little feature request: Could you add an option in "file format->conversions" to set the execution path? (Default BC3-folder, optional another fixed path or source-file-path)
    Stummfilm - ich bin dabei!

  9. #9
    Join Date
    May 2005
    Location
    Germany
    Posts
    43

    Default

    addendum:

    I created in meantime a windows exe-file. You can use this exe as a converter.
    http://rubypla.net/bc3/index.html
    http://rubypla.net/bc3/bc3_db_compare.exe

    The exe worked for me with sqlite (ado is not tested up to now). I'm not sure if it will work without a ruby/sequel installation, but I hope it will
    Stummfilm - ich bin dabei!

  10. #10
    Join Date
    Jan 2012
    Posts
    22

    Default This looks really handy

    Hi Knut,

    Your plug-in tool for BC3 looks really handy. I want to give it a try, but I'm unfamiliar with ruby/gem. Is it a big learning curve for me to comprehend it and get this working?

    Or perhaps is the .exe file you created independant of ruby, and I just need that?

    Well, I'll keep reading and tinkering, maybe I'll figure it out, but if you happen to read this and have any tips, I'd be happy to hear it.

    Cheers,
    Gurce

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •