VS 2013 - SQL Server Projects - Can I Change defaults for SQL Servers to use and the paths to DB-files?

Question

Hi all,

when a create a SQL Server Project using "File > New ...", I find the following settings defaulted:

1. SQL Server is (local)\Version12.0 and
2. DefaultDataPath, DefaultFileprefix and the DefaultFilename(s) for MDFs and LDFs point to the Project directory.
3. Initial settings of file size and increments are also not settable but defaulted.

Because my projects have to verify performance by testing with large volume of data, we have to use a different SQL Server with files stored on that Server. The Project settings have a button to changes DB properties, but these are not part of that dialog.

So I spent some fruitless hours in vain to find a way to change the project's connection to my development SQL Servers.

How to cope with that?

Thanks in advance.

---

Regards Uwe

Answer 1

Hi Uwe,

I don't quite understand you. Maybe you could post a screenshot about those default settings. I don't find those settings in a SQL Server Project, as I don't have much experience on SQL Server Projects. If you want to change the connection, you could go to the Project properties page:

And you can change all the related settings here. Not sure where "DefaultDataPath, DefaultFileprefix and the DefaultFilename(s)" settings are located.

By the way, this question is actually not about VS extensions. But i'm not sure where it belongs(maybe TechNet SQL Server forums). So I move it to [where is this forum for...] where the moderator may direct you to the right forum.

Thanks for your understanding.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.