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?
SQL Compare connects using the same serverinstance name as SQL Server Management Studio - on my machine, LocalDB is (LocalDb)MSSQLLocalDB, for example.
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?
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.
Comments
Redgate Software
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).
Redgate Software