How can we help you today? How can we help you today?

SQL Server File Databases

Simple question but I can't find a simple answer - can RedGate SQL Compare use a local file sql server database as a source? Forex, (local)ProjectsV12?

Thanks...
jhaasbeek
0

Comments

3 comments

Sort by
  • sam.blackburn
    SQL Compare connects using the same serverinstance name as SQL Server Management Studio - on my machine, LocalDB is (LocalDb)MSSQLLocalDB, for example.
    sam.blackburn
    0
  • jhaasbeek
    Thanks for the reply Sam, that works for databases hosted in a running SQL Server instance but does not appear for a sql server local file database - I.e. A direct connection to an mdf file. Do you know if that is possible?
    jhaasbeek
    0
  • sam.blackburn
    I think there would be some transactional consistency issues with directly loading an mdf, since SQL Server doesn't immediately flush all its state to disk.

    Do you have a backup of the database? SQL Compare may be able to read that (see https://documentation.red-gate.com/disp ... th+backups).
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.