thank to everybody

Thank to everybody

I mean, to import the whole database to SQL server 2005 (structure and data).

Thank

Yes,

detaching and attaching is another solution

Thank

Hello,

thank, from SQL Server I know that I can use SSIS, but I loose FK.

So I try to start database upgrade wizard (I never used), where i find it?

Thank 

I need to transfer all the application:

structure and data.

How to do it?

Thank

Thank for your useful information

I mean that ORACLE database table structure and SQL Server 2005 Database table structure is different, eg (just as example).:

ORACLE has 3 tables with 4 cols each one and SQL server...

Hello,

I would like to say that there is not corrispondence between Oracle and SQL server table and fields.

This could be limit the use of SSIS 2005?

Thank

Hello,

thank for replying.

It is possible to extract data from ORACLe into bcp files and then uploaded.

Any further contribution will be very appreciated.

Thank

Hello,

about your reply I read that SSRS 2005 use MDX to make report?

Or is it possible to access OLAP or DW using drag and drop objects to make reporting easier?

Thank

Other question:

I have to build lots of reports on OLAP SQL Server 2005 Analysis services or, I am not sure yet, directly to DW on SQL Server 2005.

Based on your...

Yes,

I though the same, using SQL Profile? but I think is not possible and to heavy.

Thank

specify the name of server

servername.dbo.T1

otherwise bcp (executed on cmd line) does not where is T1

Set /PAE in boot.ini to take advantage of RAM and check KB Microsoft for potential problem as described by Chris.