dump and load database with different size

[unknown]

Hi,

I have a production database that been allocated with 1GB
but only 100MB of it is used. I would like to dump that
database from the production server to a test server. The
test database is allocated with 500MB. Is there a way for
me to dump the production database to test database? I know
that I can use BCP but would like to avoid it. Thanks.

[A Cornell]

NO, you can only load in to greater to equal to the original size

Post by unknown
Hi,
I have a production database that been allocated with 1GB
but only 100MB of it is used. I would like to dump that
database from the production server to a test server. The
test database is allocated with 500MB. Is there a way for
me to dump the production database to test database? I know
that I can use BCP but would like to avoid it. Thanks.

[Mark A. Parsons]

Post by A Cornell
NO, you can only load in to greater to equal to the original size

Post by unknown
Hi,
I have a production database that been allocated with 1GB
but only 100MB of it is used. I would like to dump that
database from the production server to a test server. The
test database is allocated with 500MB. Is there a way for
me to dump the production database to test database? I know
that I can use BCP but would like to avoid it. Thanks.

Alternatively, if the OP is running with ASE 12.5.4 they can look at loading the database into the test environment as a
read-only archive database.

Granted, this won't help if OP needs to make changes/modifications in the database, but it would allow for read-only
access, to include pulling out only the data s/he needs to a separate database where it can be modified.