script structure and data tool

Hi,
i need a tool, to do a script of my database, BUT, not only the database
structure but also the data. The tool, should also create the insert
lines for data.
Anyone knows where to find something with similar features, Free or cheap ;)
thank you
Hi,
Database structure can be extraced using SQl Server Enterprise manager --
Click database-- All tasks -- Generate SQl scripts.
For Insert statement , there a good from Vyas:-
http://vyaskn.tripod.com/code/generate_inserts.txt
Thanks
Hari
MCDBA
"John Zing" <johnzing2003@.yahoo.com> wrote in message
news:OqXQmjHWEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> i need a tool, to do a script of my database, BUT, not only the database
> structure but also the data. The tool, should also create the insert
> lines for data.
> Anyone knows where to find something with similar features, Free or cheap
;)
> thank you
|||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/
"John Zing" <johnzing2003@.yahoo.com> wrote in message news:OqXQmjHWEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> i need a tool, to do a script of my database, BUT, not only the database
> structure but also the data. The tool, should also create the insert
> lines for data.
> Anyone knows where to find something with similar features, Free or cheap ;)
> thank you
|||John Zing wrote:
> i need a tool, to do a script of my database, BUT, not only the database
> structure but also the data. The tool, should also create the insert
> lines for data.
For a good schema comparison tool check out:
http://www.berryware.com/sqlmatcher/
It doesn't do the data comparison just yet... but that'll be coming
soon. :-) We've just added full Unicode support if that's important to
you... you can try out the 2.1 Beta for free in the meantime.
Regards,
Kevin.
|||Have you tried sqlXpress Script from sqlXpress http://www.sqlxpress.com
Bryan
"John Zing" <johnzing2003@.yahoo.com> wrote in message
news:OqXQmjHWEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> i need a tool, to do a script of my database, BUT, not only the database
> structure but also the data. The tool, should also create the insert
> lines for data.
> Anyone knows where to find something with similar features, Free or cheap
;)
> thank you
|||Have you tried sqlXpress Script from sqlXpress http://www.sqlxpress.com
Bryan
"John Zing" <johnzing2003@.yahoo.com> wrote in message
news:OqXQmjHWEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> i need a tool, to do a script of my database, BUT, not only the database
> structure but also the data. The tool, should also create the insert
> lines for data.
> Anyone knows where to find something with similar features, Free or cheap
;)
> thank you
|||Hi,
try http://www.sqlscripter.com to script your data.
You can create INSERT, UPDATE and DELETE code,
it's free.
Thomas
"John Zing" wrote:

> Hi,
> i need a tool, to do a script of my database, BUT, not only the database
> structure but also the data. The tool, should also create the insert
> lines for data.
> Anyone knows where to find something with similar features, Free or cheap ;)
> thank you
>