All Questions
Tagged with visual-studio deployment
6
questions
5
votes
1
answer
2k
views
SQLPackage resets database recovery model
I am using SQLPackage.exe with database publish profiles to deploy database changes to DEV and QC instances. I have databases in simple recovery mode. But when I deploy changes using SQLPackage, it ...
1
vote
3
answers
12k
views
Can't deploy SSAS Tabular Model in Visual Studio
I am following the SSAS Tabular Model Tutorial by Microsoft using the Adventure Works DW. I've imported the DW in SQL Server Management Studio to my local server. I've connected to the DW from Visual ...
10
votes
3
answers
7k
views
SSDT Drop and Recreate Tables when nothing has changed
We have a Visual Studio Database Project consisting of about 129 Tables. It is the primary database for our Internal Web Based CRM/Call Centre product, which is still under active development.
We ...
1
vote
0
answers
201
views
Unable to deploy single SSIS package into SSISDB when referencing parameters
I'm attempting to deploy a single package into an Integration Services Catalog using the project deployment model in SQL 2016.
This however is giving me some grief, as I've configured environmental ...
7
votes
1
answer
1k
views
Visual Studio 2010 deployment script creates objects in wrong order - trigger after stored procedure
I created a view that selects from multiple tables in a complex query.
Due to the complexity, I created insert/update/delete INSTEAD OF triggers to handle these operations on the view.
I also created ...
5
votes
0
answers
10k
views
"Procedure: XXXX has an unresolved reference to object XXXX" errors [closed]
After using for some time MS SQL Server Management Studio for creating and editing databases I tried to use Visual Studio 2010 "SQL Server 2008 Database Project" for this.
I used the SQL 2008 Wizard ...