VS2010 数据库比较.如何创建 *.DBSchema 扩展文件? [英] VS2010 Database Compare. How do you create a *.DBSchema extensioned file?

问题描述

我想对我的数据库进行快照，进行一些更改，然后使用 db compare 功能来识别更改，谁知道呢，甚至可能生成脚本来进行更改.

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

我想避免备份当前数据库并将其作为一个单独的数据库恢复，只是为了有一个之前"的快照.我想我不应该这样做.

I'd like to avoid having to backup the current db and restore it as a separate db just to have a "before" snapshot. I'm guessing I shouldn't have to.

显然，我对 db 项目一无所知，我希望能找到正确的方向.

Obsviously, I'm clueless about db projects and am looking to be pointed in the right direction.

你！

推荐答案

在您将生成架构文件的机器上，执行以下操作:下载 Microsoft SQL Server Compact 3.5适用于 Windows 桌面的 Service Pack 2.先安装 32 位版本，然后安装 64 位(如果您的服务器是 64 位)

On the machine which you will generate the schemafile, do the following: Download Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop. Install 32 bit version first, then 64 bit (if your server is 64 bit)

将文件复制到 (Program Files\Microsoft Visual Studio 10.0\VSTSDB\部署)到您将运行 VSDBCMD.EXE 的机器，忽略步骤 2 中的 CE 文件，您已经在上面的 Compact SQL 安装中安装了这些文件.

Copy the files in (Program Files\Microsoft Visual Studio 10.0\VSTSDB\Deploy) to the machine on which you will run VSDBCMD.EXE, ignore the CE files in step 2, you have already installed these in the Compact SQL install above.

阅读并理解 VSDBCMD.EXE 的命令行参考 http://msdn.microsoft.com/en-us/library/dd193283.aspx

Read and understand Command-Line Reference for VSDBCMD.EXE http://msdn.microsoft.com/en-us/library/dd193283.aspx

通过在命令提示符下运行来生成 dbschema 文件:VSDBCMD/a:import/cs:"DbConnectionString"/dsp:SQL/ModelFile: outputfilname.dbschema

Generate the dbschema file by running this from the command prompt: VSDBCMD /a:import /cs:"DbConnectionString" /dsp:SQL /ModelFile: outputfilname.dbschema

这篇关于VS2010 数据库比较.如何创建 *.DBSchema 扩展文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！