SQL Server File Databases

jhaasbeek

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...

sam.blackburn

SQL Compare connects using the same serverinstance name as SQL Server Management Studio - on my machine, LocalDB is (LocalDb)MSSQLLocalDB, for example.

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?

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).