Comparison of the VS2010 database. How do you create a file with the * .DBSchema extension?

Question

I would like to take a snapshot of my database, make some changes, and then use the db compare function to identify the changes, and who knows, maybe even generate scripts to make the changes.

I would like to avoid backing up the current db and restoring it as a separate db in order to have a “before” snapshot. I guess I don't need to.

Obviously, I don't know what to do with db projects, and I want them to be directed in the right direction.

ty!

Answer 1

, , : Microsoft SQL Server Compact 3.5 2 Windows Desktop. 32- , 64- ( 64-)

(Program Files\Microsoft Visual Studio 10.0\VSTSDB\Deploy) , VSDBCMD.EXE, CE 2, Compact SQL .

VSDBCMD.EXE http://msdn.microsoft.com/en-us/library/dd193283.aspx

dbschema, : VSDBCMD/a: import/cs: "DbConnectionString" /dsp: SQL/ModelFile: outputfilname.dbschema

Answer 2

VS2010 Premium, :

• A B
• A " "
• B , / ""

SQL Server Developer Edition... , , .

, , SQL Azure.