Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Location
    Sweden
    Posts
    3

    Red face Unanswered: Database distribution

    Hi,
    I am going to distribute a webb site and need to distribute the databases used by this webbsite. A newbie as I am to databases I ask if there is any tool to extract the databases from my machine, store it on a CD and then install it on another machine.
    Thing is... I want to distribute the databases, but not the data currently stored in it.

    Gudday!

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249

    Re: Database distribution

    1. No such a tool as I know.
    2. Backup your database and restore it with different name.
    3. DROP TABLEs unusable to user (all user tables), analytic tables ...
    4. In this database, use DELETE/TRUNCATE TABLE statements (See BOL) to clear your tables. If you use some tables for configuration, you cannot delete them !!!
    5. Select distribution type BACKUP/Script. Script (made for example by EM) is most version compatible, but it takes some time to create it, if you distibute also data.
    6. BACKUP installation files for testing UPGRADE.
    7. Installation of database on user side can be done by runing script by isql.exe by installation program ( most use InstallShield )
    8. Installation is a nightmare of each advanced developer

  3. #3
    Join Date
    Jan 2003
    Location
    Sweden
    Posts
    3

    Re: Database distribution

    Is it possible to use method of detaching the database, copy the files, distribute files and finally attach the database on remote site?

    // Dobaz

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Database distribution

    I have a similar situation in my company.I had gone for creating the scripts of the database ,since i also needed the data in the database, the size of the database file was too big .
    if u script the database u have total control over it .

  5. #5
    Join Date
    Jan 2003
    Location
    China
    Posts
    38
    You can use a outer program to restore the database during the installitaion or the program's first running.
    Last edited by 884813; 01-15-03 at 22:20.

  6. #6
    Join Date
    Jan 2003
    Location
    Sweden
    Posts
    3

    Re: Database distribution

    Thanks for all replies and help!

    I have tried to:

    1. Detached the databases that needs to be distributed from the SQL Server on my original machine.

    2. Copied the .mdf and .ldf files from the MSSQL data folder onto a second machine.

    3. Attached the distributed databases to SQL Server on the second machine.

    It all seems to work ok between my own machines... Maybe this is a good way to go?

    As I mentioned eariler I want to distribute the databases to keep table structure intact and only some example data stored in it (i.e. database files will be pretty small).

Posting Permissions

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