Dump database for test DB

[Former Member]

Hello.

Is it possible to dump database only %30 percent data ?

I have a DB which has 600 gb disk size (100GB I used). However i left 400 GB on disk.

Thanks

[former_member188958]

Hi Melih,

Are you asking if it is possible to create a dump of a database that contains only a sample of the data in each table? There is no direct feature to do that. I think the closest we would have would be to create a view on each table with a where clause based on RAND2(), something like

create view v1 as select * from t1 where rand2() < 0.30

You could then bcp data out from all of the views to get the smaller data sample.

-bret