Generate SQL scripts with data

Hi,
I am trying to move tables from my local SQL server to the sever on my
hosting company. I tried All Taks->Generate SQL Script. That only gave me
the script to create tables, is there a way I can script the data also? Of
course I can type in Insert statements myself, but that's tedious.
TIAsee
http://www.nigelrivett.net/SQLTsql/...LoadScript.html
http://www.nigelrivett.net/SQLTsql/...Script_Rem.html
also consider using bcp
http://www.nigelrivett.net/SQLTsql/BCPAllTables.html
"Danny Ni" wrote:

> Hi,
> I am trying to move tables from my local SQL server to the sever on my
> hosting company. I tried All Taks->Generate SQL Script. That only gave me
> the script to create tables, is there a way I can script the data also? O
f
> course I can type in Insert statements myself, but that's tedious.
>
> TIA
>
>|||in QA you can create insert scripts for all your table objects, use the
right mouse button.|||Try www.sqlscripter.com to generate data scripts. All types are supported
(Insert, Update, Delete).
It's free.
Thomas
"Danny Ni" wrote:

> Hi,
> I am trying to move tables from my local SQL server to the sever on my
> hosting company. I tried All Taks->Generate SQL Script. That only gave me
> the script to create tables, is there a way I can script the data also? O
f
> course I can type in Insert statements myself, but that's tedious.
>
> TIA
>
>