SQL Server Performance

Script database

Discussion in 'T-SQL Performance Tuning for Developers' started by cb, Jan 23, 2003.

  1. cb New Member

    How to script the database objects, I need to clone few database objects to a remote server for testing purpose.
    Also will it be possible to script out data also or any tools are available.
  2. satya Moderator

    To generate the script :
    Goto to EM Expand server and databases, right-click the database to script, point to All Tasks, and then click Generate SQL Scripts.

    For more information refer to books online for 'Documenting and Scripting Databases'

    For data you can use DTS or BCP for selected tables.

    HTH


    Satya SKJ
  3. bradmcgehee New Member

  4. cb New Member

    Thans for the article reference and learnt a lot. Unfortunately my budget doesn't support using third party tools ;-( So I need to depend on available SQL tools only.

    Where can I find information for bcp or dts?

  5. satya Moderator

    You look like newbie to the SQL server, as I referred do refer to books online for the prescribed topics.

    BCP syntax and other information.
    DTS and its information.

    Its always worth sparing sometime to books online for reading, which gives you basic information what you're looking for.

    HTH

    Satya SKJ
  6. cb New Member

    Yes satya I am a new to SQL server, most of my experience is with DB2 and mainframes.
    I found lots of interest things with SQL and this site too.

    I will definetly follow your advice by referring books online.

    You people are great help.
  7. x002548 New Member

    Whats the size of your db? A simple dump and restore might be a viable quick solution..

    good luck

    Brett

    ps the restore will create the db, even if it doesn't exist. :cool:
  8. cb New Member

    Size does not matter here.
    But restore does not deal with restoring specfic tables.
    As I said its required to take specified objects in the database.

    I followed satyas suggestion and also used dts to get data for those tables, it worked without issues.
  9. satya Moderator

    Using 6.5 EM you can restore a specific table from the database backup, but not from version 7 onwards.

    Satya SKJ

Share This Page