Re: SQL SERVER with ORACLE - More correctly detailed

TurkBear wrote:

> The full feature list for OMWB and SqlServer states:
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> The Migration Workbench release 9.2.0 is a wizard-driven tool. It is composed of core features and Microsoft SQL Server and
> Sybase Adaptive Server migration specific features. The Migration Workbench allows you to:
>
> Migrate a complete Microsoft SQL Server and Sybase Adaptive Server database to an Oracle9i or Oracle8i database.
>
> Migrate groups, users, tables, primary keys, foreign keys, unique constraints, indexes, rules, check constraints, views,
> triggers, stored procedures, user-defined types, and privileges to Oracle.
>
> Migrate multiple Microsoft SQL Server and Sybase Adaptive Server source databases to a single Oracle database.
>
> Customize the parser for stored procedures, triggers, or views.
>
> Generate the Oracle SQL*Loader and SQL Server BCP scripts for offline data loading.
>
> Display a representation of the source database and its Oracle equivalent.
>
> Generate and view a summary report of the migration.
>
> Customize users, tables, indexes, and tablespaces.
>
> Customize the default data type mapping rules.
>
> Create ANSI-compliant names.
>
> Automatically resolve conflicts such as Oracle reserved words.
>
> Remove and rename objects in the Oracle Model.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> In my view, migrating tables implies migrating data, else there would not be a separate set of utilities for offline data
> loading.
>
> TurkBear <john.greco_at_dot.state.mn.us> wrote:
>
> >
> >We have used the Migration Workbench to move entire Access databases to Oracle ( including data) and
> >the docs indicate that this is the case with SqlServer as well....
> >
> >
> >Daniel Morgan <dmorgan_at_exesolutions.com> wrote:
> >
> >>TurkBear wrote:
> >>
> >>> Go to http://otn.oracle.com and look into the docs for the Oracle Migration Workbench.
> >>>
> >>> .
> >>>
> >>> "PhR" <raison_at_toutan.com> wrote:
> >>>
> >>> >
> >>> >Hello
> >>> >
> >>> >I am looking for advices and experiences about replication base from SQL
> >>> >Server with Oracle V8
> >>> >
> >>> >Thanks
> >>> >
> >>> >
> >>> >
> >>> >
> >>>
> >>> -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> >>> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> >>> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
> >>
> >>Migration workbench migrates DDL. It does not replicate data.
> >>
> >>Daniel Morgan
> >
> >
> >
> >-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> >-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

I agree with your interpretation. But that is not replication. Replication means that five minutes later, five hours later, five days later, 5 weeks later, they are the same.

Daniel Morgan Received on Thu Oct 03 2002 - 15:59:59 CDT