I have a working SSIS project locally done by me with SQL Server Data Tools. I found out that the easiest way to have the project deployed in SQL Server is using the option "deploy", available on that IDE. I have done it successfully locally.
我有一个在我本地使用SQL Server数据工具完成的SSIS项目。我发现在SQL Server中部署项目的最简单方法是使用该IDE上提供的“deploy”选项。我在当地成功完成了它。
My problem is that I am not able to deploy the project directly to the client Server beacuse I have been ordered to give him no more than files, scripts , etc. in order to get the project deployed only by him. He cannot instal SQL Server Data Tools and deploy. I wonder if I can export my already deployed project in my local SQL Server instance and make him to import it?
我的问题是我无法将项目直接部署到客户端服务器,因为我被命令只给他文件,脚本等,以便只让他部署项目。他无法安装SQL Server数据工具并进行部署。我想知道我是否可以在本地SQL Server实例中导出已部署的项目并让他导入它?
1 个解决方案
#1
1
You can give him the .ispac file from your SSDT project's /bin folder, and he will be able to import it to the SQL Server using SSMS.
您可以从SSDT项目的/ bin文件夹中为他提供.ispac文件,然后他就可以使用SSMS将其导入SQL Server。
#1
1
You can give him the .ispac file from your SSDT project's /bin folder, and he will be able to import it to the SQL Server using SSMS.
您可以从SSDT项目的/ bin文件夹中为他提供.ispac文件,然后他就可以使用SSMS将其导入SQL Server。