I am an IT developer, tasked with a rather complicated data migration. I have never
worked on a large data migration before so forgive me if my questions are novice. I am
evaluating tools. I really like what I see in your product. I have downloaded the
community version and have some question after scouring the fag's and the user's guide.
I have gone thru all the tutorial videos also... very nice!
If I create all my transformation graphs locally from one DB to another, assuming I have
done my job and they work as they should... what procedure would I use to run them against
the production legacy and new DB's on a remote server? How does this fundamentally work?
Would I need to install the clover software on the remote server?... and can what I'm
attempting to do be done utilizing the community version. I'm not sure at this time If I
will be allowed to purchase the more robust software, but either way I need to know as
part of my evaluation how this would work... developing the graphs on a local "test"
machine and then running it against the production server once the graphs have been
created and tested.
worked on a large data migration before so forgive me if my questions are novice. I am
evaluating tools. I really like what I see in your product. I have downloaded the
community version and have some question after scouring the fag's and the user's guide.
I have gone thru all the tutorial videos also... very nice!
If I create all my transformation graphs locally from one DB to another, assuming I have
done my job and they work as they should... what procedure would I use to run them against
the production legacy and new DB's on a remote server? How does this fundamentally work?
Would I need to install the clover software on the remote server?... and can what I'm
attempting to do be done utilizing the community version. I'm not sure at this time If I
will be allowed to purchase the more robust software, but either way I need to know as
part of my evaluation how this would work... developing the graphs on a local "test"
machine and then running it against the production server once the graphs have been
created and tested.
-
Thank you for the email. If you would like to migrate your data from legacy DB to a new one, you do not need to install anything on neither server. You could use a JDBC connection to your remote DB. If that data are too huge to move over the network you might take into consideration our server version CloverETL Enterprise Editions (http://www.cloveretl.com/products/enterprise-editions). With server you can control the ETL operations remotly.
Please sign in to leave a comment.
Comments 1