September 24, 2008 at 10:32 pm
Hi All ,
I need to performa data migration /seperation from a data bse to anotehr . for this reason i need to collect all the statistical information regarding a datbase.
i have identified certain paramters like No. of Tables, No. of Stored Procedures, No. of Functions, No. of DB Triggers, No. of Views, No. of Materialized Views, No. of DB Links, No. of Sequence Generators, high volume Tables, low volume Tables, DB Size, Constraints
Can any one let me know ,what else are to be considered .
cheers
M.L.
October 7, 2008 at 12:26 pm
You need to move or copy the database to another server ?? How will knowing the number of tables & SPs help you ?
What method are you using to migrate the database ?
October 8, 2008 at 7:07 am
Hi homebrew ..
i need to apply a new business logic , that would filter the data of a database and the result set need to be pumped into the target datable,this i would be performing using a ETL TOOL ( either dele the rows in target or , pump the fresh required data into the target DB)
As the inial requiremnet , i wanted to collect the statistical data of a datbase on the baove mentioned paramters, to find out a judicious way for apllying the logic....
October 8, 2008 at 7:54 am
You want the target database to be a subset of the original database ? Or are you saying you might want to remove data from the original database and move it to your new database ??
I think you need to better define your business needs. Who's asking for this ? What they want ? Have they put anything on paper explaining their needs ?
The "Backup" forum is probably not the best section for this, unless you're asking for technical help about using your backups to move data around.
Once you have a clear idea, and can explain it here, post a clear question (w/ spell check on) in the correct forum and then the smart people can reply to you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply