Re: defination in script

From: mountain man (hobbit_at_southern_seaweed.com.op)
Date: 04/06/04

  • Next message: mountain man: "Re: Data Compression possible in SQL Server?" 
    Date: Tue, 06 Apr 2004 22:23:40 GMT

    "Roy" <rforkner@monitronics.com> wrote in message
    news:f_ycc.5760$yx2.4626@newssvr24.news.prodigy.com...
    > Hi All,
    > I need to create a script, of an existing table, and create the table on
    > another database. Everything works except, it did not include the
    > definations. Is there an option I am overlooking that would include the
    > definations?
    > I am using Enterprise Manager and all tasks, Generate SQL Script.
    > TIA,
    > Roy

    Your other option is to use the transfer entire table
    from one database to another via export/import data,
    located also under EM, all tasks ...

    This will invoke the DTS wizard and the end result
    is automatable. 

    -- 
Pete Brown
Winluck P/L
IT Managers & Engineers
Falls Creek
Australia
www.mountainman.com.au/software
  • Next message: mountain man: "Re: Data Compression possible in SQL Server?"

    Relevant Pages

    • RE: Recreating a database???
      ... Unfortunately the script that Enterprise Manager produces doesn't always ... to build a database using the scripts you've created. ... record the build into a .SQL file and as the builder builds in the correct ...
      (microsoft.public.sqlserver.programming)
    • Re: Recreating database on production machine?
      ... If you want to recreate the database with a script, ... SQL Server MVP ... >I know that you can use the graphical tools in Enterprise Manager to create ...
      (microsoft.public.sqlserver.programming)
    • Re: Recreating database on production machine?
      ... If you want to recreate the database with a script, ... SQL Server MVP ... >I know that you can use the graphical tools in Enterprise Manager to create ...
      (microsoft.public.sqlserver.tools)
    • Re: How do you create a databse?
      ... See Create Database in BOL. ... Dont see how it could be any ... > I think that it may be time to use a script to create databases. ... Which one do you use a script or Enterprise Manager? ...
      (microsoft.public.sqlserver.server)
    • [NEWS] IBM Informix Web DataBlade Local Root by Design
      ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... that ease development of "intelligent", interactive, Web-enabled database ... person who has access to change the Perl script. ...
      (Securiteam)