Fundamental Help required with Deployment, selection of drive ?

[David]

I have an application that uses a SQL database. At present I copy the
database to a specific
folder on the "c" drive as I am unsure how to select the drive when
deploying the project.

Would someone please explain how I set up the deployment project so that the
directory is created on the user's install drive (whether it be C, D or
other).
I also assume in code I can then just load the file using "\...." without
needing to know the drive ? Or do I use some "detdrive" type command to
build the path string ?

Hope this makes sense to someone.

Thanks in advance.

 

[Ken Tucker [MVP]]

Hi,

Not sure I really understand the question. Here a couple of tools
for installing a sql database when deploying a project.

http://www.microsoft.com/technet/security/tools/mbsahome.mspx#EDAA

http://www.red-gate.com/sql/sql_packager.htm

Ken
-----------------------
I have an application that uses a SQL database. At present I copy the
database to a specific
folder on the "c" drive as I am unsure how to select the drive when
deploying the project.

Would someone please explain how I set up the deployment project so that the
directory is created on the user's install drive (whether it be C, D or
other).
I also assume in code I can then just load the file using "\...." without
needing to know the drive ? Or do I use some "detdrive" type command to
build the path string ?

Hope this makes sense to someone.

Thanks in advance.