I was talking about using DDT. Therefore, I just need to know where to tell the client to look for the Database when they run the program the first time.

If the database already exists will DDT honor where it is found or will it also put it in the SQL Server Instance pre-defined default database location?

TIA.

Hi Terry,


Yes.

Basically the rules is this, MS-SQL Server is responsible to handle the location of the databases (see attached image), the DBA or person in that role can configure the path where the database would be located, but a client application will not or should not even know anything about where the database file is located for security purpose, so the DDT has not way to create a database in a predefined path that may not even exist in the SQL Server.

What I normally do, is that since I am mostly the one to even install MS-SQL Express at the customer site, I create a data folder in the best drive possible and name it something like E:\MS-SQL Data Files, then at that point I let the customer know where the file is so they can do daily backups using the free program SQL Backup and FTP, this program is just a jewel because I can automate backups for up to 2 databases with free version and even upload the backup to an FTP site and get an email confirmation with status daily.

Edhy Rijo

Alright, thank you for the great explanation. That all makes sense but do you change the default location so when you use DDT it put the database where you want it or how do you make sure your data get's to the where you want it?

Also, the backup piece of software is great. Thanks........

Yes, I change the location so me and most important the customer knows where the database is located.  DDT will either create or update the database based on the setup location in SQL Server configuration.

Edhy Rijo

Cool. Great. Thank You.