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

[Bondu_Babu]

Evaarakaina teliste urgent ga Cheppandi Naku okka mukka kuda idea ledhu meeting lo Emi matladalo teliyatum ledhu.

[dkchinnari]

help....acp,

[AllizWell]

Use ODI ...Oracle data Integrator.... or some ETL tool...


or Bridgeware Sync

[Bondu_Babu]

[quote name='AllizWell' timestamp='1327947461' post='1301360541']
Use ODI ...Oracle data Integrator....
[/quote]
Emaina link vunte paaday bava

[Bondu_Babu]

[quote name='vishwamithra' timestamp='1327947455' post='1301360540']
help....acp,
[/quote]
Already aadiganu idea ledhanta.

[tom bhayya]

check this [url="http://www.databasejournal.com/features/oracle/article.php/3442661/Making-a-Connection-from-Oracle-to-SQL-Server.htm"]http://www.databasejournal.com/features/oracle/article.php/3442661/Making-a-Connection-from-Oracle-to-SQL-Server.htm[/url]

[Trader joe]

There are lot of ways to do that.. depends on wht are the resources available to you..you can even export and import data...Ex : you can use free tools like AQT( smaller amount of data and less tables). If you have ETL tools its even more easier.

[tom bhayya]

inkoka option export data from sql server into a csv file.. and then use oracle sql developer to import that csv file [url="http://database.blogs.webucator.com/2011/02/27/importing-data-using-oracle-sql-developer/"]http://database.blogs.webucator.com/2011/02/27/importing-data-using-oracle-sql-developer/[/url]

[Bondu_Babu]

[quote name='AllizWell' timestamp='1327947461' post='1301360541']
Use ODI ...Oracle data Integrator.... or some ETL tool...


or Bridgeware Sync
[/quote]
Aa ODI 23000$ anta ma vaadu nannu egaaresi thanthadu
Aa bridge ware ayite link dorakatam ledhu

[Bondu_Babu]

[quote name='Trader joe' timestamp='1327947901' post='1301360554']
There are lot of ways to do that.. depends on wht are the resources available to you..you can even export and import data...Ex : you can use free tools like AQT( smaller amount of data and less tables). If you have ETL tools its even more easier.
[/quote]
SQL lo vunna data ni already production lo vunna oracle sever lo 2T space istharu anta so ee data ni teesukoni velli Akkada veyyali. Aasalu Naku ETL tool gurinchi idea ledhu .

Nvu eppudaina chesava bava ....?

[Bondu_Babu]

[quote name='Alexander' timestamp='1327947968' post='1301360556']
inkoka option export data from sql server into a csv file.. and then use oracle sql developer to import that csv file [url="http://database.blogs.webucator.com/2011/02/27/importing-data-using-oracle-sql-developer/"]http://database.blogs.webucator.com/2011/02/27/importing-data-using-oracle-sql-developer/[/url]
[/quote]
Thanks bava kani large amount data ayite kastam kadha.

[Trader joe]

[quote name='Bondu_Babu' timestamp='1327948287' post='1301360565']
SQL lo vunna data ni already production lo vunna oracle sever lo 2T space istharu anta so ee data ni teesukoni velli Akkada veyyali. Aasalu Naku ETL tool gurinchi idea ledhu .

Nvu eppudaina chesava bava ....?
[/quote]

[Trader joe]

[quote name='Bondu_Babu' timestamp='1327948287' post='1301360565']
SQL lo vunna data ni already production lo vunna oracle sever lo 2T space istharu anta so ee data ni teesukoni velli Akkada veyyali. Aasalu Naku ETL tool gurinchi idea ledhu .

Nvu eppudaina chesava bava ....?
[/quote]

[tom bhayya]

[quote name='Bondu_Babu' timestamp='1327948378' post='1301360569']
Thanks bava kani large amount data ayite kastam kadha.
[/quote]
ya large data aithey kastam... sql server version enti? oracle version edhi using? first ichina link chusaavaa

[jaffanajeffada]

[quote name='Bondu_Babu' timestamp='1327948120' post='1301360560']
Aa ODI 23000$ anta ma vaadu nannu egaaresi thanthadu
Aa bridge ware ayite link dorakatam ledhu
[/quote]

aithe Informatica suggest chey baaa... just $1.3 million (latest dhi)