Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
data load
10 views
Skip to first unread message
oradba....@gmail.com
May 22, 2012, 9:35:21 PM5/22/12
to
hi
we have application version x and database is running at 10g
we have plan to upgrade the application version to y and database to 11g.
Oracle upgrade to 11g is arlight.
but the complexity in application upgrade is that - there are many schema changes in version y of schema.
so i.e. data load to new schema wont be straightforward.
we are looking for any tool etc which would be useful here which can save the development work here.
many thanks
we have application version x and database is running at 10g
we have plan to upgrade the application version to y and database to 11g.
Oracle upgrade to 11g is arlight.
but the complexity in application upgrade is that - there are many schema changes in version y of schema.
so i.e. data load to new schema wont be straightforward.
we are looking for any tool etc which would be useful here which can save the development work here.
many thanks
joel garry
May 23, 2012, 1:39:24 PM5/23/12
to
with 11g?
When I've faced such a complex migration, I've usually done it in a
number of steps and backups, so any step can be restarted. Since
major metadata changes usually means major data updates, for me it
often makes sense to go noarchivelog and depend on cold backups, then
switch to archivelog and backup at end (or beginning, depending on
your point of view).
jg
--
@home.com is bogus.
http://www.nctimes.com/news/local/san-marcos/san-marcos-educators-question-nation-s-best-magazine-rankings/article_4a0ffc76-c099-53da-92ea-80cf68dc087a.html
http://www.utsandiego.com/news/2012/may/15/dont-take-incredible-school-ranking-bank/
Bad data is forever:
http://www.usnews.com/education/best-high-schools/california/districts/san-marcos-unified-school-district/san-marcos-high-school-3336
Oracle DBA
May 24, 2012, 4:08:39 AM5/24/12
to
On May 23, 10:39 pm, joel garry <joel-ga...@home.com> wrote:
> On May 22, 6:35 pm, oradba.train...@gmail.com wrote:
>
> > hi
> > we have application version x and database is running at 10g
> > we have plan to upgrade the application version to y and database to 11g.
> > Oracle upgrade to 11g is arlight.
> > but the complexity in application upgrade is that - there are many schema changes in version y of schema.
> > so i.e. data load to new schema wont be straightforward.
> > we are looking for any tool etc which would be useful here which can save the development work here.
> > many thanks
>
> Doesn't the application have such a tool? Does y run with 10g or x
> with 11g?
>
> When I've faced such a complex migration, I've usually done it in a
> number of steps and backups, so any step can be restarted. Since
> major metadata changes usually means major data updates, for me it
> often makes sense to go noarchivelog and depend on cold backups, then
> switch to archivelog and backup at end (or beginning, depending on
> your point of view).
>
> jg
> --
> @home.com is bogus.http://www.nctimes.com/news/local/san-marcos/san-marcos-educators-que...http://www.utsandiego.com/news/2012/may/15/dont-take-incredible-schoo...
> On May 22, 6:35 pm, oradba.train...@gmail.com wrote:
>
> > hi
> > we have application version x and database is running at 10g
> > we have plan to upgrade the application version to y and database to 11g.
> > Oracle upgrade to 11g is arlight.
> > but the complexity in application upgrade is that - there are many schema changes in version y of schema.
> > so i.e. data load to new schema wont be straightforward.
> > we are looking for any tool etc which would be useful here which can save the development work here.
> > many thanks
>
> Doesn't the application have such a tool? Does y run with 10g or x
> with 11g?
>
> When I've faced such a complex migration, I've usually done it in a
> number of steps and backups, so any step can be restarted. Since
> major metadata changes usually means major data updates, for me it
> often makes sense to go noarchivelog and depend on cold backups, then
> switch to archivelog and backup at end (or beginning, depending on
> your point of view).
>
> jg
> --
> Bad data is forever:http://www.usnews.com/education/best-high-schools/california/district...
Thanks Joel.
we are at 10g.
target us 11g.
Somthing Oracle GoldenGate can do both the work here..
i.e. Upgrade and Tranformation.
some doc links on that would be useful.
0 new messages