Community Forums
Results 1 to 3 of 3

Thread: SQL Database Best Practices

  1. #1
    Join Date
    Jan 2002
    Location
    Sydney
    Posts
    582

    SQL Database Best Practices

    Can someone please tell me what the best practice is for SQL database distribution and uninstallation?

    Currently our installer deploys a database, runs some sql scripts and the application deployed uses this database. Common scenario I'm sure.

    When the user chooses to uninstall our product, I backup and then drop the database. There is still a copy of the database (via backup file) should the user decide they need to see the data again. Is this correct procedure, or should the uninstall leave the database on their system?

    Can someone tell me if I am following best practice, or where I can read best practice for this scenario?
    Thanks,
    Alison

  2. #2
    Join Date
    Jan 2002
    Location
    Sydney
    Posts
    582
    Surely someone knows the MSI standards ?
    Thanks,
    Alison

  3. #3
    Join Date
    Jul 2017
    Posts
    2

    Angry Practice Assistant Task Manager

    Am having this error on my server

    Practice Assistant Task Manager
    Unknown database
    Alias:dbPAMgr.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •