Export a table (datas and structure)

Hi,
I need to generate a script from MS Sql Server 2005 that should contain the
structure and the datas of a table.
This script will be used by another SQL Server (but a 2000 version).
These 2 Sql Servers are not connected, so I can't use the import/export
task.
what would be the best way for this need ?
I thank you in advance
StanOn Aug 9, 4:34 pm, "Stan SR" <s...@.pasdepam.netsunset.com> wrote:
> Hi,
> I need to generate a script from MS Sql Server 2005 that should contain th
e
> structure and the datas of a table.
> This script will be used by another SQL Server (but a 2000 version).
> These 2 Sql Servers are not connected, so I can't use the import/export
> task.
> what would be the best way for this need ?
> I thank you in advance
> Stan
I'm not sure if you are interested in any third party tools, but you
could easily script the data features utilizing Red Gate's Data
Compare. It will generate the necessary scripts to populate a table
with all relevant data. If this is a one time shot, you could simply
download the trial and go from there. While you are at it, you could
utilize their Schema Compare and script out your schema as well.
http://www.red-gate.comsql