Tools to script a database?

4 Jul 2006 5:49 PM

David Veeneman

Are there any open source/freeware tools that will script a database and its
data? I have to move a simple database from SQLS 2005 to SQLS 2000.

-- I'm familiar with RedGate, but I don't do this often enough to justify
the cost.

--I know I can script structure from Management Studio and use a script from
an online library to script the data. But I do this just often enough to
look for a single-step tool to do the job.

Anyone know of such a thing? Thanks in advance.

--
David Veeneman
Foresight Systems

5 Jul 2006 9:38 AM

tommaso.gastaldi

DataTime(tm) Community Client has some functionality to create
and load Dump files.

See:

Database Explorer > Run Dump
and
Database Explorer > Export (to dump file)
I don't know if it can suffice for you purposes.

In case, some extra functionality can be added (freely) on the fly. No
problem.
http://cam70.sta.uniroma1.it/Community/

-Tom

David Veeneman (domain is my last name) ha scritto:

Show quote

> Are there any open source/freeware tools that will script a database and its
> data? I have to move a simple database from SQLS 2005 to SQLS 2000.
>
> -- I'm familiar with RedGate, but I don't do this often enough to justify
> the cost.
>
> --I know I can script structure from Management Studio and use a script from
> an online library to script the data. But I do this just often enough to
> look for a single-step tool to do the job.
>
> Anyone know of such a thing? Thanks in advance.
>
> --
> David Veeneman
> Foresight Systems

6 Jul 2006 10:38 PM

Keith Kratochvil

You could use BCP/DTS to move the data yourself.

or you could use something like this
http://vyaskn.tripod.com/code/generate_inserts.txt
http://vyaskn.tripod.com/code/generate_inserts_2005.txt

--
Keith Kratochvil

Show quote

"David Veeneman" <davidv@nospam.com (domain is my last name)> wrote in
message news:%23OvE7I5nGHA.1444@TK2MSFTNGP02.phx.gbl...
> Are there any open source/freeware tools that will script a database and
> its data? I have to move a simple database from SQLS 2005 to SQLS 2000.
>
> -- I'm familiar with RedGate, but I don't do this often enough to justify
> the cost.
>
> --I know I can script structure from Management Studio and use a script
> from an online library to script the data. But I do this just often enough
> to look for a single-step tool to do the job.
>
> Anyone know of such a thing? Thanks in advance.
>
> --
> David Veeneman
> Foresight Systems
>

7 Jul 2006 8:26 AM

Thomas

Use http://www.sqlscripter.com to script you data.

-Thomas

Show quote

"David Veeneman" wrote:

> Are there any open source/freeware tools that will script a database and its
> data? I have to move a simple database from SQLS 2005 to SQLS 2000.
>
> -- I'm familiar with RedGate, but I don't do this often enough to justify
> the cost.
>
> --I know I can script structure from Management Studio and use a script from
> an online library to script the data. But I do this just often enough to
> look for a single-step tool to do the job.
>
> Anyone know of such a thing? Thanks in advance.
>
> --
> David Veeneman
> Foresight Systems
>
>
>

20 Jul 2006 12:07 AM

David Veeneman

I ended up using Microsoft SQL Server Web Administrator Ver. 2.0:

http://www.microsoft.com/downloads/details.aspx?familyid=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en