Re: Scripting schema & data absent in 2005?

Juan,

Enterprise Manager, nor any tool provided by Microsoft, allows you to create
SQL Insert scripts against the data in your tables. The same is true with
2005 Management Studio. Regarding the tools from Red-Gate, they are probably
the finest and most useful tools I have ever purchased. They do something
that is quite rare today, they just work well.

Amos.

"Juan Dent" <Juan_Dent@xxxxxxxxxxxxx> wrote in message
news:02EDB038-6ADD-48AA-B8BC-72B3DFBD1F07@xxxxxxxxxxxxxxxx
Hi,

I started using SQL Server 2005 developers edition a couple of months ago
and I notice that it is no longer possible (or I have been too dumb to
find
how) to script both a selection of tables AND their data. As far as I can
remember, SQL SERVER 2000 Enterprise Manager would let you do this, even
by
selecting dependent objects and everything would get exported.

I don't know, I am probably missing something.
Then there are these tools from Red-gate.com: SQL Compare, SQL Data
Compare
and SQL Package, that make me question why they exist (and seem to do
well)
if at least the exporting part of them (SQL Package) was quite good
already
in 2000. Yet in 2005, I don't see it clearly.

I apologize if this sounds like an awfully simple question but I do not
spend my premium time in SQL SERVER.

--
Thanks in advance,

Juan Dent, M.Sc.


.

Relevant Pages

  • Re: Unable to start SQL Server
    ... Although Enterprise Manager is normally the correct place to change SQL ... Server service account info, this method cannot be used when the service ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Getting an absolutely up to date version of MSDE
    ... The real reason for updating is that I have online SQL Server ... >> Enterprise Manager connection does not now work (has worked splendidly ... >dynamically assigned port (actually letting the remote MDAC client stack be ...
    (microsoft.public.sqlserver.msde)
  • Installing SQL on a machine with a run-time instance
    ... Enterprise Manager does not reside on that server. ... Can I install full blown SQL on here, place it in a directory other than the ... server's currnet default SQL directory, ... instance within the SQL Server Enterprise Manager that I would install? ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2000 enterprise manager
    ... You may not have Enterprise manager in SQL Server program groups if you have MSDE. ... This will allow you to go to SQL prompt:- There execute the below backup command. ...
    (microsoft.public.sqlserver.tools)
  • Re: Scripting a SQL database
    ... With Enterprise Manager what is required to have the script create ... :> different SQL server and can it be done from ASP? ... programmatically without requiring the Admin to create it manually. ... scripts for me, which will help me learn but I don't know how to utilize ...
    (microsoft.public.inetserver.asp.db)