February 16, 2019 at 10:19 pm
1)Tool to migrate data from Oracle to SQL like full data , incremental data and also It need to handle PK,FK and all constraints while loading the data.
And need to remove duplicate values during loading data into target.
2)For management of below tasks
*schema compares
*data compare
*Validation of both schema and data
*generation of incremental scripts for both schema and the data
*physical data modeling
February 17, 2019 at 5:11 am
would help if you posted what you have researched already and what issues you found with each of the possible tools to do each part of the job.
so the following are options, not necessarily the best ones on your case, neither the best in call cases.
1 -
SSIS
C#
SSMA
Replication (Both oracle and SQL server tools)
2 -
SSDT - schema compare
SQL Compare - data compare
Sparx Enterprise Architect - modeling
for validation and incremental you will have to do them - although incremental scripts for schema would normally be considered under schema compare
February 17, 2019 at 5:56 am
pawan.mantha - Saturday, February 16, 2019 10:19 PM1)Tool to migrate data from Oracle to SQL like full data , incremental data and also It need to handle PK,FK and all constraints while loading the data.
And need to remove duplicate values during loading data into target.2)For management of below tasks
*schema compares
*data compare
*Validation of both schema and data
*generation of incremental scripts for both schema and the data
*physical data modeling
There are several systems which can do this from vendors such as Varigence, Attunity and Zerto, they do come at a price though😉
😎
Quick questions,
February 17, 2019 at 6:15 am
Eirikur Eiriksson - Sunday, February 17, 2019 5:56 AMpawan.mantha - Saturday, February 16, 2019 10:19 PM1)Tool to migrate data from Oracle to SQL like full data , incremental data and also It need to handle PK,FK and all constraints while loading the data.
And need to remove duplicate values during loading data into target.2)For management of below tasks
*schema compares
*data compare
*Validation of both schema and data
*generation of incremental scripts for both schema and the data
*physical data modelingThere are several systems which can do this from vendors such as Varigence, Attunity and Zerto, they do come at a price though😉
😎Quick questions,
- what are the number of tables?
- the size of the data set?
- is the infrastructure on-prem or hybrid?
Db's in thousand and row counts in million infra was hybrid
February 17, 2019 at 6:28 am
pawan.mantha - Sunday, February 17, 2019 6:15 AMEirikur Eiriksson - Sunday, February 17, 2019 5:56 AMpawan.mantha - Saturday, February 16, 2019 10:19 PM1)Tool to migrate data from Oracle to SQL like full data , incremental data and also It need to handle PK,FK and all constraints while loading the data.
And need to remove duplicate values during loading data into target.2)For management of below tasks
*schema compares
*data compare
*Validation of both schema and data
*generation of incremental scripts for both schema and the data
*physical data modelingThere are several systems which can do this from vendors such as Varigence, Attunity and Zerto, they do come at a price though😉
😎Quick questions,
- what are the number of tables?
- the size of the data set?
- is the infrastructure on-prem or hybrid?
Db's in thousand and row counts in million infra was hybrid
Can you please provide more details, I'm not too good at guessing🙂
😎
In my experience, any projects which have hundreds or thousands of objects should be automated, otherwise they will become unmanageable and most likely will fail.
February 17, 2019 at 6:49 am
Eirikur Eiriksson - Sunday, February 17, 2019 6:28 AMpawan.mantha - Sunday, February 17, 2019 6:15 AMEirikur Eiriksson - Sunday, February 17, 2019 5:56 AMpawan.mantha - Saturday, February 16, 2019 10:19 PM1)Tool to migrate data from Oracle to SQL like full data , incremental data and also It need to handle PK,FK and all constraints while loading the data.
And need to remove duplicate values during loading data into target.2)For management of below tasks
*schema compares
*data compare
*Validation of both schema and data
*generation of incremental scripts for both schema and the data
*physical data modelingThere are several systems which can do this from vendors such as Varigence, Attunity and Zerto, they do come at a price though😉
😎Quick questions,
- what are the number of tables?
- the size of the data set?
- is the infrastructure on-prem or hybrid?
Db's in thousand and row counts in million infra was hybrid
Can you please provide more details, I'm not too good at guessing🙂
😎
In my experience, any projects which have hundreds or thousands of objects should be automated, otherwise they will become unmanageable and most likely will fail.
one of my client where using Oracle and they have large data and data base i looking for a tool where we can use to migrate the data but exact count i dont have as of now.you can suggest me for any complex environment
February 17, 2019 at 10:59 am
Looks like you are not after possible tools, but for someone to do the work for you (so you can charge your client as if it was done by yourself).
All the tools I mentioned on my first post were used on a recent project to migrate from Oracle to SQL Server - not going to tell you how to use them and how to implement a framework to automate this - that is what your work is and that is what you are being paid for. And all the tools mentioned have enough documentation associated with them to allow you to do your work.
February 17, 2019 at 6:37 pm
frederico_fonseca - Sunday, February 17, 2019 10:59 AMLooks like you are not after possible tools, but for someone to do the work for you (so you can charge your client as if it was done by yourself).All the tools I mentioned on my first post were used on a recent project to migrate from Oracle to SQL Server - not going to tell you how to use them and how to implement a framework to automate this - that is what your work is and that is what you are being paid for. And all the tools mentioned have enough documentation associated with them to allow you to do your work.
Frederico : No i am looking for the reliable tools i have already used SSMA and SSIS(here i am need to create each project for each individually DB ) but i am looking some tools to handle this.
Now i am exploring Attunity
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply