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]]

Re: where DTS in SQL 2005; Oracle to SQL2k5??

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/prodtechnol/sql/2005/downloads/books.mspx

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

[Nasir]

Re: where DTS in SQL 2005; Oracle to SQL2k5??

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


TIA.

"Alan Brewer [MSFT]" <alanbr@microso ft.comwrote in message
news:454a34ba$1 @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/prodtechnol/sql/2005/downloads/books.mspx

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

[David Portas]

Re: where DTS in SQL 2005; Oracle to SQL2k5??

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/solutions/migration/oracle/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/ms130214(en-US,SQL.90).aspx

--

[Nasir]

Re: where DTS in SQL 2005; Oracle to SQL2k5??

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" <REMOVE_BEFORE_ REPLYING_dporta s@acm.orgwrote in message
news:1163019730 .458315.123600@ e3g2000cwe.goog legroups.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/solutions/migration/oracle/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/ms130214(en-US,SQL.90).aspx

--
>