脚本多表SSDT [英] Script multiple tables SSDT

问题描述

在SSDT中打开数据库时，我点击一个表>右键单击>创建为...我希望一次为多个表执行此操作。由于懒惰的DBA不想授予简单的权限，我的团队正在失去对SSMS的访问权限... SSMS
有对象资源管理器，它允许一次使用"创建到"来编写数百个对象的脚本。 SSDT似乎一次只做一个对象。有没有人知道一次做多个表的方法？或者知道任何其他软件来实现这一点所以
我不需要将几百个文件一起复制并粘贴到我的对象的一个​​文件中？这个过程看起来好像会从几分钟到几个小时，我很感激我能得到的任何帮助。

In SSDT when I have a database open, I click on a single table > right click > Create To ... I am looking to do this for multiple tables at a time. My team is losing access to SSMS because of lazy DBAs not wanting to grant simple permissions... SSMS has object explorer which allows hundreds of objects to be scripted with "Create To" at a time. SSDT seems to only do one object at a time. Does anyone know a way to do multiple tables at once? Or know any other software to accomplish this so that I do not have to copy and paste several hundred files together into one file for my objects? This process is seeming as if it will go from several minutes to several hours, and I would appreciate any assistance I can get.

推荐答案

试用工具> SQL Server>架构比较。 您应该能够将数据库用作源和项目作为目标，并生成相应的脚本或部署。

Try Tools > SQL Server > Schema Compare.  You should be able to use the database as the source and your project as the target and generate the appropriate scripts or deploy.

这篇关于脚本多表SSDT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！