How do I create a script to populate a table?

Using SQL Server Express 2005, SQL Server Management Studio Express:

How do I create a script to populate a table?  Say I have a populated
table that I need to deploy with my app; isn't there a tool that can
create a script which replicates a table I already have?  I know how to
generate a script to *create* the table but how can I create a script
that populates it?  Any help appreciated...

SELECT * INTO  NewTable FROM OldTable WHERE......
http://www.karaszi.com/SQLServer/ i...ript
.asp

<groovyjman21@gmail.com> wrote in message
news:1166019696.539981.303050@16g2000cwy.googlegroups.com...
> Using SQL Server Express 2005, SQL Server Management Studio Express:
>
> How do I create a script to populate a table?  Say I have a populated
> table that I need to deploy with my app; isn't there a tool that can
> create a script which replicates a table I already have?  I know how to
> generate a script to *create* the table but how can I create a script
> that populates it?  Any help appreciated...
>

I don't think I explained this right.  How do I create a script that
populates a database from a database that is already populated.  For
example, I have an application which needs to install SQL Server
Express and a database on the client's system.  Now, I know how to
generate a script to create an unpopulated database (just rightclick in
Management studio), but say I want to programmatically populate the
database with a script containing a series of INSERT statements.  Can't
I just right click somewhere in studio on a populated database and
select "generate Insert statements"?

No, you cannot
http://vyaskn.tripod.com/code/ gene...200
5.txt





<groovyjman21@gmail.com> wrote in message
news:1166022472.562016.205400@j72g2000cwa.googlegroups.com...
>
> I don't think I explained this right.  How do I create a script that
> populates a database from a database that is already populated.  For
> example, I have an application which needs to install SQL Server
> Express and a database on the client's system.  Now, I know how to
> generate a script to create an unpopulated database (just rightclick in
> Management studio), but say I want to programmatically populate the
> database with a script containing a series of INSERT statements.  Can't
> I just right click somewhere in studio on a populated database and
> select "generate Insert statements"?
>

OK, thanks for your help.  From the page you posted I tried the SQL
Scripter tool at http://www.sqlscripter.com/ and it works great.
Thanks again for your help.



Uri Dimant  wrote:[color=darkred
]
> No, you cannot
> http://vyaskn.tripod.com/code/ gene...200
5.txt
>
>
>
>
>
> <groovyjman21@gmail.com> wrote in message
> news:1166022472.562016.205400@j72g2000cwa.googlegroups.com...