SQL Server：将开发推向生产？
我目前正在使用 SQL Server Management Studio。
我有一个开发数据库，可以访问实时数据库。
我只想能够将我的开发表迁移到实时服务器。
我首先咨询堆栈流，因为我不想破坏任何东西。
I'm currently using SQL Server Management Studio.
I have a development database, and access to a live database.
I just want to able to migrate my development tables to the live server.
I'm consulting stack flow first, since I don't want to blow anything up.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
如果您知道要迁移哪些表，并且它们在产品服务器上尚不存在，则只需编写表定义脚本，然后在服务器上运行该脚本即可。如果比这更复杂，我会推荐任意数量的工具来比较数据库模式并自动生成可以在目标服务器上运行的脚本以添加/更改/删除您需要的内容。 DBComparer 是一款适合简单工作的优秀免费软件。这是非常基本的。一个优秀的商业工具是 Red Gate 的 Sql Tools
If you know what tables you want to migrate and they don't yet exist on the prod server, it's as simple as scripting the table definition, then running the script on the server. If it's more complex than that, I would recommend any number of tools which compare database schemas and automatically generate scripts you can run on the destination server to add/alter/remove what you need. A good freeware one for simple jobs is DBComparer. It's pretty basic. An excellent commercial one are the Sql Tools by Red Gate
为此，我们使用 SQL Examiner Suite，但还有很多类似的工具。
We are using SQL Examiner Suite for this, but there are a lot of similar tools.
这值得一看 - 我以前用过它，它运行良好并且非常简单：Microsoft SQL Server 数据库发布向导 http://www.microsoft.com/downloads/en/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410 -371A838E570A&displaylang=en
This is worth a look at - I've used it before and it works well and is very easy: Microsoft SQL Server Database Publishing Wizard http://www.microsoft.com/downloads/en/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en