Re: .sql File

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/05/04 

Date: Mon, 05 Apr 2004 08:15:20 -0600

Noor,
In Enterprise Manager, right click on the database, select
All Tasks and then select Generate SQL Script. From here you
can select the object to script out. In the options tab, you
can select the option to Create One File per object.

-Sue

On Mon, 5 Apr 2004 18:54:01 +0500, "Noorali Issani"
<naissani@softhome.net> wrote:

>Dear Professional
>
>I want to export the stored procedures, functions and tables into
>textfiles.sql Like if there are 100 tables then it will create 100 sql files
>and if there are 200 stored procedures then it will create 200 sql files,
>how can I do this task.
>
>Thanks
>NOOR
>

Relevant Pages

  • Re: newable copy question
    ... The easiest way is to right click on the database in Enterprise Manager and ... choose "All Tasks" - "Generate SQL Script". ... and I have to copy the test database from the ...
    (microsoft.public.sqlserver.server)
  • Re: How to extract texts of all stored procedure
    ... Right click on the database in Enterprise Manager and select "All Tasks" and ... then "Generate SQL Script". ... > I need to extract the texts of all procedures of a database. ... Regards. ...
    (microsoft.public.sqlserver.server)
  • How can I check..
    ... The easiest way is to do into Enterprise Manager, ... by selecting the database, all tasks, generate sql script, ... >I have one database file in separate filegroup. ...
    (microsoft.public.sqlserver.server)
  • Re: PK Index name
    ... Generate SQL Script. ... Select whatever tables you want to copy, then go to the Options tab and make ... sure "Select PRIMARY keys, FOREIGN keys, defaults, and check constriants" is ... Use the script this generates to create a new, empty database. ...
    (microsoft.public.sqlserver.programming)
  • Export more than one table at the same time
    ... when using Enterprise manager, I would like to export the data from my ... generate sql script: ... This creates the database for me, but the data is not restored. ... Thx, ...
    (microsoft.public.sqlserver.tools)