generate db scrip including data in tables

i'm not able to generate a sql script with the data in the tables! using sql express.

i need this script to ganerate the same database with its datas in a new sql server.

thanks in advance

SQL Server only generates scripts for schema and not for data. There are 3rd party tools that can do that. You can either build a DTS package or use DTS Import Export wizard to transfer data across servers. If the tables are huge (tens of millions of rows or higher) the DTS/Import could be slower.

|||

Can u just take a backup of the database on the source server and restore it on the destination server. This is of course possible if you need the entire database. Unfortunately, you can't create a script or something for data in the database like the script for the definitions of the objects (tables, stored procedures, views etc.). DTS packages are another solution as suggested by ndinakar.

Generate a scrip with data from a DB

Is possible generate a script to populate a DB from
another DB.
We have a database with some data. And we want create a
script with data from that database, and use that script
to fill the other database.
Thanks,
Rui Oliveirahttp://vyaskn.tripod.com/code.htm#inserts
--
Jacco Schalkwijk
SQL Server MVP
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:1ea301c53e7e$be21e160$a601280a@.phx.gbl...
> Is possible generate a script to populate a DB from
> another DB.
> We have a database with some data. And we want create a
> script with data from that database, and use that script
> to fill the other database.
> Thanks,
> Rui Oliveira
>|||I've listed some options here:
http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:1ea301c53e7e$be21e160$a601280a@.phx.gbl...
> Is possible generate a script to populate a DB from
> another DB.
> We have a database with some data. And we want create a
> script with data from that database, and use that script
> to fill the other database.
> Thanks,
> Rui Oliveira
>

Generate a scrip with data from a DB

Is possible generate a script to populate a DB from
another DB.
We have a database with some data. And we want create a
script with data from that database, and use that script
to fill the other database.
Thanks,
Rui Oliveirahttp://vyaskn.tripod.com/code.htm#inserts
Jacco Schalkwijk
SQL Server MVP
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:1ea301c53e7e$be21e160$a601280a@.phx.gbl...
> Is possible generate a script to populate a DB from
> another DB.
> We have a database with some data. And we want create a
> script with data from that database, and use that script
> to fill the other database.
> Thanks,
> Rui Oliveira
>|||I've listed some options here:
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/
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:1ea301c53e7e$be21e160$a601280a@.phx.gbl...
> Is possible generate a script to populate a DB from
> another DB.
> We have a database with some data. And we want create a
> script with data from that database, and use that script
> to fill the other database.
> Thanks,
> Rui Oliveira
>

Generate a scrip with data from a DB

Is possible generate a script to populate a DB from
another DB.
We have a database with some data. And we want create a
script with data from that database, and use that script
to fill the other database.
Thanks,
Rui Oliveira
http://vyaskn.tripod.com/code.htm#inserts
Jacco Schalkwijk
SQL Server MVP
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:1ea301c53e7e$be21e160$a601280a@.phx.gbl...
> Is possible generate a script to populate a DB from
> another DB.
> We have a database with some data. And we want create a
> script with data from that database, and use that script
> to fill the other database.
> Thanks,
> Rui Oliveira
>
|||I've listed some options here:
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/
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:1ea301c53e7e$be21e160$a601280a@.phx.gbl...
> Is possible generate a script to populate a DB from
> another DB.
> We have a database with some data. And we want create a
> script with data from that database, and use that script
> to fill the other database.
> Thanks,
> Rui Oliveira
>