where DTS in SQL 2005; Oracle to SQL2k5??

[Nasir]

I need tyo move tables from Oracle 9.2 or 10.2 version to SQL server 2005.
Can any one give me some good hints, scripts etc.

I try to look into the Business Intellegent Studio, but I only see Report,
Analaysis or Integration services - NO DTS.

Can someone tell me where to find it. It used to be so easy in 2000.

Thanks,
Nasir

[Alan Brewer [MSFT]]

Integration Services replaced DTS in SQL Server 2005.

--
Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/pro...ads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.

[Nasir]

Can any body direct me to steps to follow to migrate a database from Oracle
to SQL Server 2005.
TIA.

"Alan Brewer [MSFT]" <al****@microsoft.comwrote in message
news:45********@news.microsoft.com...

Integration Services replaced DTS in SQL Server 2005.

--
Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/pro...ads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no
rights.

[David Portas]

Nasir wrote:

Can any body direct me to steps to follow to migrate a database from Oracle
to SQL Server 2005.
TIA.

There is no complete push-button solution but take a look at:
http://www.microsoft.com/sql/solutio...e/default.mspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

[Nasir]

I thought that was only for SQL Server2000 and not for 2005. Does any one
know for sure if it works with 9i or 10g to SQL2005?

"David Portas" <RE****************************@acm.orgwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

Nasir wrote:

>Can any body direct me to steps to follow to migrate a database from
Oracle
to SQL Server 2005.
TIA.

There is no complete push-button solution but take a look at:
http://www.microsoft.com/sql/solutio...e/default.mspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--