Board index » delphi » Attach/Detach Database Deployment Method
Attach/Detach Database Deployment Method
2003-10-20 11:51:21 PM
I am providing an application to customers with a pre-made *.mdf database.
Since I am new to MS SQL and this procedure is different from the way I have
deployed databases to custiomers in the past (I previously used FlashFiler)
I have some questions.
Question 1: I have premade the database using MS SQL 2000 and need to provide
it along with my application to my customers. I want to do this by having
the customers use the "Attach" database procedure in the Enterprise Manger
utility program. Is this a good/acceptable way to provide a pre-made
database under MS SQL 2000?
Question 2: Are there any pitfalls I need to be aware of here using this
Question 3: I am not sure I understand the *.ldf file and what it does. Does
it need to be included with the *.mdf file I provide to customers? If I
don't include it what are the repercussions?
Question 4: Is there any way to "Attach" a database to MS SQL using
programming code to do it?
Thanks in advance for any assistance on these matters.