How To Migrate D@t@ Frm Sql To 0Racle

[Bondu_Babu]

Trader joe nvu Emi reply ichavo kanipinchatam ledhu.

[Bondu_Babu]

[quote name='jaffanajeffada' timestamp='1327948618' post='1301360579']


aithe Informatica suggest chey baaa... just $1.3 million (latest dhi)
[/quote]
Nannu job lo nvu peekinchese laa vunnavu ga.

[Trader joe]

Okay..Hopefully table structures and table constraints same vunayi anukoni from both SQL server and Oracle....you can export data into a Excel sheet( There is limitation of data export into Excel sheet) and load into Oracle using SQL loader or AQT( both free atleast in trail versions) its easy.
If there is enormous amount of data you have to use ETL tools for sure atleast according to my idea.

[Bhayya]

One method is coverting source data to xml and loading target from xml.

Etla chestaro telvadu...

[Bondu_Babu]

[quote name='Alexander' timestamp='1327948608' post='1301360578']

ya large data aithey kastam... sql server version enti? oracle version edhi using? first ichina link chusaavaa
[/quote]
Aa information Emi ledhu bava andhuke meeting arrange chesthamu antunnaru. Appudu aasalu ne idea emiti ani aadigite cheppali ga.....!

First link motham chuda ledhu bava

[Bondu_Babu]

[quote name='Trader joe' timestamp='1327948880' post='1301360587']
Okay..Hopefully table structures and table constraints same vunayi anukoni from both SQL server and Oracle....you can export data into a Excel sheet( There is limitation of data export into Excel sheet) and load into Oracle using SQL loader or AQT( both free atleast in trail versions) its easy.
If there is enormous amount of data you have to use ETL tools for sure atleast according to my idea.
[/quote]
Nenu DBA Naku ee ETL gurinchi no idea. Aasale first job Emi cheppali Ela cheppalo Emi ardhamai chavatam ledhu.

[jaffanajeffada]

[quote name='Bondu_Babu' timestamp='1327948789' post='1301360583']
Nannu job lo nvu peekinchese laa vunnavu ga.
[/quote]


oka sari idhi choodu emanna help avudhi emo

[url="http://st-curriculum.oracle.com/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm"]http://st-curriculum.oracle.com/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm[/url]

[Trader joe]

Dont worry its a Database or ETL developer job to load the data..But meeting purpose..You can talk these points.

1). Data migration depends on the volume of data and how many no.of tables we are talking about?

2). Available resources(tools to do this) and time to do.

3). Main important thing is if this is one time thing or not( most cases this would be just one time thing).

4). Since there is already data in oracle and they are loading data into it..we can use the same procedure to load data from sql server by using it as source or a lookup procedure.( Needs ETL or ERP tools).

If its to be done by a DBA:

You have to take a back up of ORACLE database( remember not at single point Production DB should be down).

Then take a copy of data the from sql server and just import using load tools( Structure's of the tables should be same along with constraints).

[Bondu_Babu]

[quote name='jaffanajeffada' timestamp='1327949193' post='1301360600']



oka sari idhi choodu emanna help avudhi emo

[url="http://st-curriculum.oracle.com/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm"]http://st-curriculum.oracle.com/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm[/url]
[/quote]
Chusanu bava it is not much useful .

[Bondu_Babu]

[quote name='Trader joe' timestamp='1327949676' post='1301360615']
Dont worry its a Database or ETL developer job to load the data..But meeting purpose..You can talk these points.

1). Data migration depends on the volume of data and how many no.of tables we are talking about?

2). Available resources(tools to do this) and time to do.

3). Main important thing is if this is one time thing or not( most cases this would be just one time thing).

4). Since there is already data in oracle and they are loading data into it..we can use the same procedure to load data from sql server by using it as source or a lookup procedure.( Needs ETL or ERP tools).

If its to be done by a DBA:

You have to take a back up of ORACLE database( remember not at single point Production DB should be down).

Then take a copy of data the from sql server and just import using load tools( Structure's of the tables should be same along with constraints).
[/quote]

Thank so much bava.
Ya almost atu vanti qus ready chesanu bava kakapote vallu be opinion emiti Ela chesthavu emaina tool use chesthav Emi days paadutundhi ante Emi cheppalo teliyatum le aasale Nenu idi varake migrate Chesa ani build up ichanu.

[Trader joe]

Without using ETL tool a limited amount of data can be imported say like 1 million records and its not a good practice as we will not be able to do regression testing ani chepu. I did migrate data but it was small amount and did unit testing but writing queries against Database ani chepu.
Naku telisi DBA's take a back up of data from database.. and use same files also to export it back if needed..so we can use same files even to import back into diff db's. I do it all the time using toad.

[jaffanajeffada]

[quote name='Trader joe' timestamp='1327949676' post='1301360615']
Dont worry its a Database or ETL developer job to load the data..But meeting purpose..You can talk these points.

1). Data migration depends on the volume of data and how many no.of tables we are talking about?

2). Available resources(tools to do this) and time to do.

3). Main important thing is if this is one time thing or not( most cases this would be just one time thing).

4). Since there is already data in oracle and they are loading data into it..we can use the same procedure to load data from sql server by using it as source or a lookup procedure.( Needs ETL or ERP tools).

If its to be done by a DBA:

You have to take a back up of ORACLE database( remember not at single point Production DB should be down).

Then take a copy of data the from sql server and just import using load tools( Structure's of the tables should be same along with constraints).
[/quote]

[Bondu_Babu]

[quote name='Trader joe' timestamp='1327950471' post='1301360671']
Without using ETL tool a limited amount of data can be imported say like 1 million records and its not a good practice as we will not be able to do regression testing ani chepu. I did migrate data but it was small amount and did unit testing but writing queries against Database ani chepu.
Naku telisi DBA's take a back up of data from database.. and use same files also to export it back if needed..so we can use same files even to import back into diff db's. I do it all the time using toad.
[/quote]
Thanks alot bava

[CORLEONE]

[quote name='Trader joe' timestamp='1327950471' post='1301360671']
Without using ETL tool a limited amount of data can be imported say like 1 million records and its not a good practice as we will not be able to do regression testing ani chepu. I did migrate data but it was small amount and did unit testing but writing queries against Database ani chepu.
Naku telisi DBA's take a back up of data from database.. and use same files also to export it back if needed..so we can use same files even to import back into diff db's. I do it all the time using toad.
[/quote]
Assale idea lenodiki kuda artham ayyettu cheptunnav gaa,,,,,,,,,, Gud post !

[Indoamerican]

Nenu ETL meeda ne pani chesedi
I suggest Informatica or Data services.