create test data in sybase

[Former Member]

Hi,

How to create a test data in SYBASE DB???

Regards,

Chandrish M

[chrisfranz · Accepted solution]

Chandrish,

  Which Sybase Database are you using?

  Many test tools have data generation capabilities. We have developed a few tools that generate data for our example databases and applications. However, we do not have a generic data generation tool.

  Most of our customers create their own test data generation since data models and structures tend to be unique to each customer.

Chris Franz

[Former Member · Accepted solution]

Hi Franz,

Thanks for the reply.

Our sybase release is 15.7.0.101

Regards,

Chandrish M

[Former Member · Accepted solution]

Hi Chandrish,

This question was asked in the Advantage Database section.  I've moved it to an ASE section.

Edgar

[luc_vanderveurst · Accepted solution]

Just an empty database or do you want to create a test environment for an application ?

To add a database to a server, you need to know the size and the devices (database partitions / files) where you want to put the database on.

Best is to ask your DBA.

Luc.

[ryan_hansen · Accepted solution]

Chandrish M,

Please clarify exactly what you want to do this for.

Everyone will be just guessing.

If you want a sample ASE database with a few tables/data:

cd $SYBASE/ASE-15_0/scripts

isql -Usa -P<sa password> -S<ase> -iinstallpubs2

This will build pubs2 database.

Regards,

Ryan

[Former Member · Accepted solution]

Thanks Ryan.

I was looking for this pubs.

Regards,

Chandrish M