Database migration

Hello,
Is it generally easier to migrate data from SQL Server to other
databases? I tried to find migration tools that would help move data
from SQL Server to other databases, and there were many. However,
trying to find tools that would migrate data from DB2, Oracle or any
other database to SQL Server was not really common. Is it harder to
migrate data to a SQL Server database? thank you.Moving data from Oracle, DB2 (and many other products) to SQL Server is
quite easy.
To set up ETL operations use DTS (SQL 2000) or SSIS (SQL 2005).
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"contact1981" <contact1981@.gmail.com> wrote in message
news:1154966351.399554.13710@.b28g2000cwb.googlegroups.com...
> Hello,
> Is it generally easier to migrate data from SQL Server to other
> databases? I tried to find migration tools that would help move data
> from SQL Server to other databases, and there were many. However,
> trying to find tools that would migrate data from DB2, Oracle or any
> other database to SQL Server was not really common. Is it harder to
> migrate data to a SQL Server database? thank you.
>|||Hi,
Migration to SQL is easy, just get the migration toolkit from microsoft site.
'SQL Server Migration Assistant' this tool will automate most of the phases
of the migration process. or u can use DTS .
Amol Lembhe
"Arnie Rowland" wrote:
> Moving data from Oracle, DB2 (and many other products) to SQL Server is
> quite easy.
> To set up ETL operations use DTS (SQL 2000) or SSIS (SQL 2005).
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "contact1981" <contact1981@.gmail.com> wrote in message
> news:1154966351.399554.13710@.b28g2000cwb.googlegroups.com...
> > Hello,
> >
> > Is it generally easier to migrate data from SQL Server to other
> > databases? I tried to find migration tools that would help move data
> > from SQL Server to other databases, and there were many. However,
> > trying to find tools that would migrate data from DB2, Oracle or any
> > other database to SQL Server was not really common. Is it harder to
> > migrate data to a SQL Server database? thank you.
> >
>
>|||I think the shortage of third-party migration tools for converting to
SQL Server is because, as others have noted, Microsoft already had the
tools you need "in the box" or free to download.
Roy
On 7 Aug 2006 08:59:11 -0700, "contact1981" <contact1981@.gmail.com>
wrote:
>Hello,
>Is it generally easier to migrate data from SQL Server to other
>databases? I tried to find migration tools that would help move data
>from SQL Server to other databases, and there were many. However,
>trying to find tools that would migrate data from DB2, Oracle or any
>other database to SQL Server was not really common. Is it harder to
>migrate data to a SQL Server database? thank you.