I was thinking about including the SQLMSDE folder on the VFP 7 CD on my installation CD. Then, in my installation instructions tell the user how to install the "Data Engine".

As far as setting up the database, I was thinking of doing it your way or:

1) make a duplicate database with no data
2) "detach" the database
3) include the MDF and LDF files in the install
4) after installing the "Data Engine" and the application, run a routine that will "attach" the MDF and LDF to their server

>Hi!
>
>1) The installer for MSDE has a command-line switches to allow install it in the "silent" mode without any messages or whatever. So you just have to run the installer in such mode. Read docs on MS site (as far as I remember, I found information about this there).
>
>2) Just run SQL script using, for example, VFP app and SQLExec() command with string containing the script. There are also a command-line utility for SQL Server (I do not know really if they provided with MSDE) that allow to do the same. However, all "GO" commands in the SQL script should be removed and each block of commands between "GO" should run in separate call to server.
>
>HTH.
>
>>OK, I've created a client server application and want to install it on a client's machine. They do not have SQL Server, so I want to give them MSDE.
>>
>>1) How do I set it up on their machine? Is there a merge module that I can include in InstallShield express to have it installed automatically with the application?
>>
>>2) What is the best way to get the database set up once I get MSDE installed?
>>
>>I would like for this to all be automated. I cannot go to every clients office and set this up manually for them!