Questions tagged [visual-studio]

Use the tag Visual Studio when you are having issues using Visual Studio in combination with a database system.

Filter by
Sorted by
Tagged with
42 votes
7 answers
14k views

Why should I use Visual Studio 2010 over SSMS for my database development?

Visual Studio 2010 introduces database projects and a whole array of related features that supposedly facilitate database development. I've used SQL Server Management Studio (SSMS) for many years to ...
  • 14.5k
6 votes
1 answer
6k views

Error starting localDb on Windows 11

I installed Windows 11 on a brand new NUC, then installed all updates. Installed Visual Studio 2022 CE and SSMS (v 18.10) I attempted to start the localDB which is assume was installed as part of ...
  • 163
6 votes
0 answers
241 views

Using the Schema Generation Wizard to regenerate a previously-generated schema

Lately, I've been trying to clean up a group of projects that my company received from an outside contractor. Among them is an SSAS cube, with an associated data warehouse. The contractors generated ...
4 votes
2 answers
303 views

Regenerating a cube relational schema in Visual Studio

I have an Analysis Services cube project that my company received from an outside contractor, and I'm trying to get it so that developers can work on it on their local machines. I'm pretty sure that ...
3 votes
1 answer
314 views

SQL Visual Studio Find and Replace in Publish Profile

We have source control in Visual Studio Database Projects (SSDT). To make cross database references, we utilize something like this below in Project References. We need Project references, since ...
user avatar
2 votes
1 answer
4k views

Class not registered error in SSAS Data Source View

Has anyone come across Class Not Registered issue while opening Data Source Views in SSAS using Visual Studio 2015? There are similar posts not haven't found anything exactly the same. Error text: ...
  • 41
1 vote
1 answer
6k views

How to change "deployment target version" on SSIS 2019?

I am experiencing the following errors when using the "Transfer SQL Server Objects" task in SSIS on Visual Studio 2019: An exception occurred in SMO Value cannot be null. Parameter name: server ...
  • 177