Hi,
please tell me the cloning process, my client is using sql sever'05 wit oracle 9i database.
how i clone the entire database in another location. plz help me and give the total script for the job.
thanking u.
sunil
Printable View
Hi,
please tell me the cloning process, my client is using sql sever'05 wit oracle 9i database.
how i clone the entire database in another location. plz help me and give the total script for the job.
thanking u.
sunil
Are you aware you are talking about two different RDBMS technologies?
Be good to your client and hire a DBA -or two.
Are you cloning from SQL Serer to Oracle or from Oracle to SQL Server? No one will know how to clone your data without knowing anything about what you are doing. How many tables, how much data, how often do you need to clone, etc...? Both databases have tools that will help you to create flat files with your data, and then import into the other database. You can also use Oracle Heterogeneous services to create a direct connection between the databases and then set up replication between the two.
But you won't get someone to figure this out for you.
dude, seriously... i agree with PAVB, but to be more diplomatic...
google it... there's tons of documentation onm the net, try Metalink as well...
good luck!