script out table definition and data

21 Dec 2005 5:42 PM

sqlster

Is there any free download tool that I could use to script out table
definition along with the data?

There is a tool by vyas but it was not scripting out correctly. I don't mean
to say wrong things about the tool but may be it was "my bad"!!

When I used that tool, it was chopping out some of the characters at the
very end of script lines.

Please let me know if there is any other free tool out there that I could use.

Thanks

21 Dec 2005 7:15 PM

Andrew J. Kelly

That was most likely due to the setting of the # of characters returned per
column in Query Analyzer. Change that setting "Tools - Options" and you
will most likely get the desired results. But note you will always be
limited to 8000 bytes per column in SQL 2000 QA.

--
Andrew J. Kelly SQL MVP

Show quote

"sqlster" <nospam@nospam.com> wrote in message
news:14C21109-D426-468A-A321-C28150271812@microsoft.com...
> Is there any free download tool that I could use to script out table
> definition along with the data?
>
> There is a tool by vyas but it was not scripting out correctly. I don't
> mean
> to say wrong things about the tool but may be it was "my bad"!!
>
> When I used that tool, it was chopping out some of the characters at the
> very end of script lines.
>
> Please let me know if there is any other free tool out there that I could
> use.
>
> Thanks

21 Dec 2005 7:36 PM

Joe from WI

I'm not familiar with the tool but if you're using Query Analyzer to execute
it, you'll need to change the output results setting.

Tools | Options. Click Results tab. Set the Maximum number of characters
per column to 8192 (the max).

Just a thought,
Joe

Show quote

"sqlster" wrote:

> Is there any free download tool that I could use to script out table
> definition along with the data?
>
> There is a tool by vyas but it was not scripting out correctly. I don't mean
> to say wrong things about the tool but may be it was "my bad"!!
>
> When I used that tool, it was chopping out some of the characters at the
> very end of script lines.
>
> Please let me know if there is any other free tool out there that I could use.
>
> Thanks

21 Dec 2005 9:36 PM

sqlster

Joe and Andrew,

Thank you very much and it works great.

I knew it was "my bad" !!!

Show quote

"Joe from WI" wrote:

> I'm not familiar with the tool but if you're using Query Analyzer to execute
> it, you'll need to change the output results setting.
>
> Tools | Options. Click Results tab. Set the Maximum number of characters
> per column to 8192 (the max).
>
> Just a thought,
> Joe
>
> "sqlster" wrote:
>
> > Is there any free download tool that I could use to script out table
> > definition along with the data?
> >
> > There is a tool by vyas but it was not scripting out correctly. I don't mean
> > to say wrong things about the tool but may be it was "my bad"!!
> >
> > When I used that tool, it was chopping out some of the characters at the
> > very end of script lines.
> >
> > Please let me know if there is any other free tool out there that I could use.
> >
> > Thanks

29 Aug 2006 4:26 PM

Thomas

Try www.sqlscripter.com to script out data.

Show quote

"sqlster" wrote:

> Is there any free download tool that I could use to script out table
> definition along with the data?
>
> There is a tool by vyas but it was not scripting out correctly. I don't mean
> to say wrong things about the tool but may be it was "my bad"!!
>
> When I used that tool, it was chopping out some of the characters at the
> very end of script lines.
>
> Please let me know if there is any other free tool out there that I could use.
>
> Thanks