MSDE Questions

  • Hi all. Can someone shed some light on MSDE.

    I am developing a backend using SQLServer 2000 and Enterprise Manager. I would then like to distribute it to run on MSDE so that my front end can talk to it.

    How do I get it to customers ?. I would like to wrap it in an installer.

    How do I tell it about my tables, stored procedures, Roles and Users.

    How do I perform maintenance on the back-end (eg backups and shrinking the transaction log etc).

    Finally does anyone know of a good book on this.

    Thanks for your time.

    CCB

  • No books I know of and I'm sure MSDN should have something on redistributing and wrapping in an installer.

    MSDE functions the same as a SQL Server, so once it's installed you either attach a db or create a new one, run scripts for objects, etc. The same as you would do for SQL Server. For maintenance, you need SQLAgnet runnning (I'm assuming this is included with MSDE) or you need to schedule tasks that run scripts to do backups, integrity, etc.

  • msde (now known as the sql server 2000 desktop installer) can be installed either integrated into an existing installer (using merge modules) or running a setup.exe with either command line parameters or a setup.ini containing parameters (the parameters are explained in BOL).

    we generally create our databases with either dmo through VBSCRIPT or osql.

    we populate our MSDE databases using either osql or VBSCRIPT with ADO but there are other methods that would work as well.

  • Hi,

    Recently I created a sample cd for a client, which had a vb.net set up program to install MSDE, attach databases, and an Access 2000 front end which uses the ODBC connection to MSDE.

    I installed MSDE by opening a dos window and running setup.exe. Attaching databases was done inside VB using SQL commands.

     

    Rushdi

  • Hi,

    what commands did you use ?

    What set up program did you use ?

    Thanks

    CCB

  • It can be downloaded from Microsoft in various languages.

    go to http://www.microsoft.com/sql/ and follow the links to the downloads pages.   It contains installation instructions as well for various languages.

  • Use the MSDE 2000 Deployment Resource kit


    * Noel

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply