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

Compare databases with same name

hadardshadards Posts: 2
edited June 16, 2015 8:45AM in SQL Compare 11

I understand the only way to compare database files is by attaching them to sql server.
Since I cannot attach databases with same name, how can I compare 2 different databases from different versions but with same name?
Is there a way comparing database's files without attaching them?

Thanks in advance



  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    Hi Hadar,

    Yes, there are other ways of comparing Databases in SQL Compare other than having them running on a SQL Server instance:

    - Directly from a Backup File*
    - SQL Compare Snapshot
    - Source Control*
    *Option available in SQL Compare Professional only

    For more complete information please read:
    http://documentation.red-gate.com/displ ... ta+sources

    Besides these options you can also compare online Databases running on different SQL Server instances.
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.