Re: Gnerating SQL scripts for database creation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I believe that it was added in 2000, but make sure you study the option ins the "Generate script"
dialog to make sure (I don't have a 7.0 to test on). Also, you might find something useful here:
http://www.karaszi.com/SQLServer/info_generate_script.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"Edward Diener" <eddielee_no_spam_here@xxxxxxxxxxxxxx> wrote in message
news:edm%23EKWWFHA.3840@xxxxxxxxxxxxxxxxxxxxxxx
> In Enterprise Manager there exists the ability to have SQL scripts generated for the objects of
> each database. I do not see the ability to have an an SQL script generated for the database
> itself. Does such an ability exist ? I am using SQL Server 7, so maybe this ability does not exist
> in that version but does in a later version.


.

Relevant Pages

  • Req: Senior .Net Software Engineer required
    ... Conduct technical studies and evaluations of business area ... Ability to handle multiple projects, ... Technical Skills: ... and cardinality with a focus on MS SQL Server. ...
    (comp.os.linux.setup)
  • Re: designer wanted
    ... While the SQL Server, ... Access and Visio, may work they all have drawbacks. ... One key feature is the ability to create a database or at least tables ...
    (microsoft.public.sqlserver.server)
  • JOB : MATLAB APPLICATION DEVELOPER NEEDED
    ... Help support the main SQL Server data repository, which may include designing, building and documenting database architecture, and analyzing datasets to identify missing, incomplete, or invalid information. ... ability to communicate clearly and confidently with members of the Research team. ...
    (comp.soft-sys.matlab)
  • Re: Connecting from PC to PDA database with framework2.0
    ... the desktop application is already existent but do not use a SQL Server database and I do not have ability to change it ... but you can manage SQLMobile databases on device from SQL Server 2005 SQL Workbench. ...
    (microsoft.public.sqlserver.ce)
  • Generating PL/SQL Script from table
    ... Sorry to keep asking SQL Server to Oracle questions... ... Within SQL Server, once I create a database, related tables, triggers, ... I can automatically generate SQL scripts (through the Enterprise ...
    (comp.databases.oracle.server)