Re: Generate SQL script

From: SriSamp (ssampath_at_sct.co.in)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 17:18:25 +0530

You can generate scripts for tables etc using Enterprise Manager. For data
scripts, you will need to write your own code and use some third party tool. 

-- 
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Totto" <taa.nospam1@norcon.no> wrote in message
news:e7S1haKGEHA.2208@TK2MSFTNGP09.phx.gbl...
> Hi,
> Using SQL server 2000 it's possible to generate SQL Script to generate the
> tables, triggers etc.
> Is it possible to generate script for data as well ?
>
>
>

Relevant Pages

  • Re: How do I import/export databases in MSDE?
    ... Scripts are like the old PRGs (files with FoxPro statement or DML) ... ... > OSQL is only a client tool able to communicate with SQL Server via ODBC API, ... > T-SQL statements are sent to the server via the network protocols via the ...
    (microsoft.public.sqlserver.msde)
  • Re: How to generate SQL server script programmatically?
    ... Do you know any Java solution for this? ... > Looking for a SQL Server replication book? ... The install package basically will consist of scripts ... >> every objects in the databases, like all the tables, stored procedures, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Opening Script File Problem
    ... I have some scripts written by one of my coworkers to ... file type set to open with SQLWB - SQL Server Management Studio), ... file opens in Notepad instead of appearing in the query window. ... run it but of course this gets cumbersome for long scripts. ...
    (comp.databases.ms-sqlserver)
  • RE: SQL-DMO CreateFile error when scripting database
    ... Scripts from SQL Server Enterprise Manager and encounter the error message ... This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.sqlserver.tools)
  • Re: How do you keep track of your various scripts and codes?
    ... scripts in the subs.... ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... "Steen Persson" wrote in message ...
    (microsoft.public.sqlserver.server)