| Author |
How do I create a script to populate a table?
|
|
| groovyjman21@gmail.com 2006-12-13, 7:12 pm |
| 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...
| |
| Uri Dimant 2006-12-13, 7:12 pm |
| 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...
>
| |
| groovyjman21@gmail.com 2006-12-13, 7:12 pm |
|
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"?
| |
| Uri Dimant 2006-12-13, 7:12 pm |
| 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"?
>
| |
| groovyjman21@gmail.com 2006-12-13, 7:12 pm |
| 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...
|
|
|
|