Deployment...SQL Database placement.

Question

Hello,

I have a quick question regarding deployment in VS 2010. My program uses SQL databases and right now those file reside in C:\Databases\. Is there a way when making a setup package to make sure those database files are always placed in that directory? Also, is there an alias i can use in my connection strings and deployment so the program looks for the database files on the system root? Basically look for files DB files on systemroot\Databases, that way it does not matter what drive letter windows happens to be on.

Thanks to all who reply.

Mike

Answer 1

For deployment questions I would post to the ClickOnce and Setup & Deployment Projects forum.

Deployment will differ depending upon the type of SQL database (SQL CE? SQL Express? SQL Server?) you are working with. There is no special folder that would point to a custom folder on the C: drive.

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 2

Hi Mike,

  You can refer to the following thread for solving your problem:

  http://social.msdn.microsoft.com/Forums/en-US/winformssetup/thread/c4a257dc-4221-44ff-8e11-423b887c5797

  Hope it helps you.

Sincerely,

Jason Wang

---

Jason Wang [MSFT]
MSDN Community Support | Feedback to us