Hi
Where can I get data for testing databases: Oracle, MSSQL.
The large databases or prepared scripts.
Can I get it somewhere?
Thank You very mach for your help!

blarut wrote:
> Hi
> Where can I get data for testing databases: Oracle, MSSQL.
> The large databases or prepared scripts.
> Can I get it somewhere?
> Thank You very mach for your help!

US government makes available census data.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Hello
But this date is not free. Maybe do You know some other free date for
testing databases.
Thank's for help

blarut wrote:
> Hello
> But this date is not free. Maybe do You know some other free date for
> testing databases.
> Thank's for help
>
Checkout the TPC. It should have scripts on how TPC benchmark data is
generated. You can then customize it to your liking.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Hi
I found only scripts for MySQL. I can't really find any source
connected with Oracle

blarut wrote:
> Hi
> I found only scripts for MySQL. I can't really find any source
> connected with Oracle
>

The Gene Ontology (http://www.geneontology.org) (GO) is also distributed
in MySQL dump. However they also distributed some scripts that help one
to convert the dump to Oracle. There are couple of problems with it:

- The newer version of GO is distributed with newer version of the
dump, which the converters do not understand
- The database uses empty character strings on quite a lot of
values which are for columns which are defined as NOT NULL

I fixed the script that converts MySQL dump to Oracle, so if you are
interested in, drop email. (it is a Perl script)

--

Arto Viitanen
CSC
Espoo, Finland

blarut wrote:
> Hi
> Where can I get data for testing databases: Oracle, MSSQL.
> The large databases or prepared scripts.
> Can I get it somewhere?
> Thank You very mach for your help!

Try 'Benchmark Factory' from Quest?

blarut wrote on 12.12.2005 20:58:
> Hi
> Where can I get data for testing databases: Oracle, MSSQL.
> The large databases or prepared scripts.
> Can I get it somewhere?
> Thank You very mach for your help!
>

You can also try DbMonster (http://dbmonster.sourceforge.net) which is
an open source testdata generator. Don't know if that is what you are
looking for.

Thomas