-
Hi,
I have 1Gb of Database,and now I want to test our application for the 50Gb to 100Gb of Database.So I want to make 50-100Gb of database from my 1Gb of database.
So how can I proceed???
Can I write the procedure??...can you give me some procedure,how to duplicate 1gb database to make 50-100Gb database???..or some any other method is there??/
Regards
Rajesh
Rajesh C.Makwana
When things go wrong and u feel sick , Rest if u must , but Do not quit....
-
do the same as your 1G DB!!
with more hardrive space...you can create more datafiles as your db growth.
nguyenjl
-
database size
But the 1Gb of database, users are adding manually....
so now I have 1Gb of database and from that 1Gb of database I want to create 50-100Gb of database..(I mean its like duplicating the database)
Rajesh C.Makwana
When things go wrong and u feel sick , Rest if u must , but Do not quit....
-
for testing purposes (of the db), you could drop your constraints so as to have duplicate entries and then add 50x the data for each table. This might screw up you application though ...
So, you have the arduous task of creating a generic user-generation script. Ah, the good old days!
However, once you create this script, you will always be able to use it (until the design changes! ack!)!
Have fun!
- Magnus
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|