Export more than one table at the same time

From: Ágoston Bejó (gusz_at_freemail.hu)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 15:25:53 +0100

Hi,
when using Enterprise manager, I would like to export the data from my
database. I have found the following options:
a) generate sql script:
This creates the database for me, but the data is not restored. (No insert
statements or something.)
b) export data (into text file)
This way I can export the data but only for one table at the same time.

Is there a more convenient way for this? Right now I'm only able to save the
data from table to table which takes too much time.

Thx,
Gus

Relevant Pages

  • Re: Missing file from MS.NET Compact Framework Kick Start
    ... let apologize for the missing files in our samples. ... The readme.txt file from Chp 9 in describes how to set up the test database ... is a sql script file that will set up the Quotes database on the server. ...
    (microsoft.public.dotnet.framework.compactframework)
  • 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)
  • sql trouble
    ... database from one table to the other using an sql script, ... having trouble dong that. ... The existing database has the following: ... ELEMENT_SHAPE_ID long, foreign key ...
    (comp.lang.java.databases)
  • 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)
Loading