MSDE and Database Distribution
Posted 10 October 2001 - 15:46
Posted 10 October 2001 - 16:43
Alternatively use DMO to play a SQL script that creates the DB schema. You can use Enterprise Manager to generate the script.
MS have a document that covers this - something like "Deploying SQL Server Applications".
You'll need SQL-DMO to be installed on the machine. There's a 3rd party merge module on this site that can do this. Alternatively, if the user has installed MSDE or SQL Server, they've already got it.
Posted 04 March 2002 - 22:32
As wonderful as SQL-DMO is, I found out the following (the hard way):
If your end users have SQL 7.0 installing the DMO merge modules will KILL their client tools (i.e. Enterprise Manager, Query Analyzer, etc.)
The client tools for SQL 2000 are NOT freely distributable, so the fix is quite inconvenient.
Just a word of caution...
Posted 04 March 2002 - 22:39
|Quote (Gavin @ Mar. 04 2002,22:32)|
|If your end users have SQL 7.0 installing the DMO merge modules will KILL their client tools (i.e. Enterprise Manager, Query Analyzer, etc.)|
That should be fixed in the latest version of the module.