很好的datadude演练
谁能向我指出 Datadude（Visual Studio 数据库项目）的一个很好的演练以及注意事项，重点是远程部署？我们一直使用它来版本控制和更新我们自己的测试环境。我现在的问题是，当必须升级客户的测试和生产环境时该怎么办？我一直在编写一些脚本并使用 vsdbcmd 和 dbschema 并直接在生产环境上创建更新脚本，但我对这种方法不太满意。理想情况下，从我的角度来看，我需要将数据库升级打包为“安装程序”（或安装的一部分，但我们现在不讨论这个 - WiX叹息*），“现场”执行数据库比较，生成更新脚本，错误时调用和回滚。
那么我可能错过了任何想法、好的博客文章、我需要阅读的演练吗？
提前致谢！
/碧玉
Could anyone point me to a good walkthrough of Datadude (Visual Studio Database project) and the do's and dont's, with focus on remote deployment? We've been using it for versioning and updating our own test environment. My question is now, what to do when having to upgrade the customers test and production environment? I've been doing a litte scripting and using vsdbcmd and the dbschema and creating the update script directly on the production environment, but I'm not quite satisfied with this approach. Ideally, from my point of view, I need to package the database upgrade as an 'installer' (or part of an installation, but let's not get into that right now - WiX sigh*), perform the database compare 'on-site', generate update script, invoke and rollback on errors.
So any ideas, good blog posts I've might have missed, walkthroughs I need to read?
Thanks in advance!
/Jasper
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我可能是错的，但我认为除了 vsdbcmd 之外没有什么可以实现这一点。是否可以在 WiX 安装程序中包含 vsdbcmd？
您可能会考虑 Red Gate SQL Packager，尽管它只能从实际数据库源读取，而不能从 VS 数据库项目读取。它生成一个 .exe 或 C# 项目，您可以将其集成到现有安装程序中。但是，这不会进行“现场”比较，因此可能不满足您的要求。
您最好的选择可能是使用 Red Gate 的 SQL Comparison SDK 在安装程序中插入代码以进行“现场”比较和部署。您可以在事务中运行升级脚本，因此如果脚本失败，就会发生回滚（但是当然，您必须在进行任何数据库更新之前运行备份！）。同样，“源”不能是 VS 数据库项目，但您可以使用使用 SQL Compare 或免费的 SQL Snapper 工具。
I might be wrong, but I don't think there's anything beyond vsdbcmd to achieve this. Is it possible to include vsdbcmd in your WiX installer?
You might consider Red Gate SQL Packager, although this can only read from an actual database source, not a VS database project. It generates a .exe or a C# project that you can integrate into an existing installer. However this doesn't do the comparison 'on site', so probably doesn't meet your requirements.
Your best bet may be to use Red Gate's SQL Comparison SDK to insert code in your installer to do the comparison and deployment 'on site'. You can run the upgrade script in a transaction, so rollback would occur if the script fails (but of course you must run a backup before enagaging in any database update!). Again, the 'source' can't be a VS database project, but you could instead use a schema a schema snapshot, generated using SQL Compare or the free SQL Snapper tool.