|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Scripting schema & data absent in 2005?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. By data do you mean the actual data in the tables? If so this was never
available thru the native SQL Server tools. -- Andrew J. Kelly SQL MVP Show quote "Juan Dent" <Juan_Dent@nospam.nospam> wrote in message news:02EDB038-6ADD-48AA-B8BC-72B3DFBD1F07@microsoft.com... > 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. Yes by data I mean the actual rows in the tables. I do remember seing
something like this in Entreprise Manager... If it wasn't there, how then was it done? Do you think the red-gate.com tools for SQL are needed/useful? Your opinion is important to me since you are an SQL MVP... -- Thanks in advance, Juan Dent, M.Sc. Show quote "Andrew J. Kelly" wrote: > By data do you mean the actual data in the tables? If so this was never > available thru the native SQL Server tools. > > -- > Andrew J. Kelly SQL MVP > > > "Juan Dent" <Juan_Dent@nospam.nospam> wrote in message > news:02EDB038-6ADD-48AA-B8BC-72B3DFBD1F07@microsoft.com... > > 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. > > > The only thing even close to that in 2000 was the Import / Export wizard for
DTS and it did not generate scripts to insert the data. But there are ways to do that such as the ones below. http://vyaskn.tripod.com/code/generate_inserts.txt SQL 2000 http://vyaskn.tripod.com/code/generate_inserts_2005.txt SQL 2005 As for the Red-Gate tools I find them well worth every penny. It doesn't take many situations in which the tool saves more than enough time to pay for itself. -- Andrew J. Kelly SQL MVP Show quote "Juan Dent" <Juan_Dent@nospam.nospam> wrote in message news:10DC591D-9FCB-48D3-91AD-465D5A3E5D13@microsoft.com... > Yes by data I mean the actual rows in the tables. I do remember seing > something like this in Entreprise Manager... If it wasn't there, how then > was > it done? > Do you think the red-gate.com tools for SQL are needed/useful? > > Your opinion is important to me since you are an SQL MVP... > -- > Thanks in advance, > > Juan Dent, M.Sc. > > > "Andrew J. Kelly" wrote: > >> By data do you mean the actual data in the tables? If so this was never >> available thru the native SQL Server tools. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Juan Dent" <Juan_Dent@nospam.nospam> wrote in message >> news:02EDB038-6ADD-48AA-B8BC-72B3DFBD1F07@microsoft.com... >> > 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. >> >> >> Hi Juan,
Welcome to use MSDN Managed Newsgroup Support. From your description, my understanding of this issue is: You can not generate the script for a table in SQL Server 2005. If i misunderstood your concern, please feel free to point it out. In SQL Server 2005 Management Studio, you can use the Generate SQL Server Script Wizard to do this job. Right-Click a database, select Task -> Generate Scrpits... Then the Wizard will appear. You can select a specific table in the wizard. Hope this will be helpful! Sincerely yours, Wei Lu Microsoft Online Partner Support Get Secure! - www.microsoft.com/security ===================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. 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. Show quote "Juan Dent" <Juan_Dent@nospam.nospam> wrote in message news:02EDB038-6ADD-48AA-B8BC-72B3DFBD1F07@microsoft.com... > 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. Use www.sqlscripter.com to generate data scripts for tables.
Show quote "Juan Dent" wrote: > 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.  |
|||||||||||||||||||||||
Other interesting topics