creating sql script with records

hello!
which program is the besto for creating sql scripts with records from tables
I choose? I mean, if I want to create whole database, but only save records
from 5 tables.
thanks!
> which program is the besto for creating sql scripts with records from
tables
> I choose? I mean, if I want to create whole database, but only save
records
> from 5 tables.
You can script objects and then use DTS or bcp.exe to transfer the data.
Additioanally, you can use a procedure that generates insert statements from
a table. Check for sch a procedure, for example, at
http://www.thecodeproject.com/databa...ratorPack.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
|||It is possible that some of the stuff I've listed here has this feature:
http://www.karaszi.com/SQLServer/inf...ate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bernard" <bernard@.form.hr> wrote in message news:cklc5l$an$1@.ls219.htnet.hr...
> hello!
> which program is the besto for creating sql scripts with records from tables I choose? I mean, if
> I want to create whole database, but only save records from 5 tables.
> thanks!
>

creating sql script with records

hello!
which program is the besto for creating sql scripts with records from tables
I choose? I mean, if I want to create whole database, but only save records
from 5 tables.
thanks!> which program is the besto for creating sql scripts with records from
tables
> I choose? I mean, if I want to create whole database, but only save
records
> from 5 tables.
You can script objects and then use DTS or bcp.exe to transfer the data.
Additioanally, you can use a procedure that generates insert statements from
a table. Check for sch a procedure, for example, at
http://www.thecodeproject.com/datab...eratorPack.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||It is possible that some of the stuff I've listed here has this feature:
http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bernard" <bernard@.form.hr> wrote in message news:cklc5l$an$1@.ls219.htnet.hr...en">
> hello!
> which program is the besto for creating sql scripts with records from tabl
es I choose? I mean, if
> I want to create whole database, but only save records from 5 tables.
> thanks!
>