Thanks.
This is a ready-only archive of the InstallSite Forum. You cannot post any new content here. / Dies ist ein Archiv des InstallSite Forums. Hier können keine neuen Beiträge veröffentlicht werden.
MSDE and Database Distribution
Started by
PMillere
, Oct 10 2001 15:46
3 replies to this topic
Posted 10 October 2001 - 15:46
Does anyone know how to distribute a MSDE (SQL SERVER) Database with the engine and how to attach database with InstallScript ?
Posted 10 October 2001 - 16:43
You could use SQL-DMO to attach the binary database file.
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
MSDE 2000 install: WARNING about SQL-DMO!!!!
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...
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.
Stefan Krüger
InstallSite.org twitter facebook