My inputs based on working on both the dbs:

1. SQL Server 2005 is eqally good as Oracle 10g in performance etc.

2. The other parameters you can consider are...

In fact I handled a complete re-engineering project. The data migration was a part of it.

Data Base:

From Oracle7 Server Release 7.3.4.0.0 to MS SQL Server 2005

Application:

Oracle Developer 6.0.5 ...

Hi neelamani,

The issue is discussed in details in the same forum.

http://www.sqlservercentral.com/Forums/Topic533065-1042-1.aspx

I took help from SSMA in converting the code.

To migrate the data, I used SSIS (SQL Server Integration Services). SSIS...

Try select INSTANCE_NAME from v$instance

You need to increase the CommandTimeout of the connection object in your .NET code. The default values is 30 seconds.

You can increase it up to 3600 seconds (1 hour)

You can...

There is no harm or risk to the production Oracle database in the process of migrating the data to the SQL Server.

You should plan as follows if your intention...

Thanks for your explanation GSquared and clarifying that Dense_rank() will work in this scenario not the row_number()

Yes the original poster is asking

how to select 2nd top row form...

Here is the solution using the Dense_rank(). The row_number() suggested by GSquared

will be ineffective in case of ties.

DROP TABLE #Employees

CREATE TABLE #Employees (Emp_No INT, EName VARCHAR(5), Sal INT)

INSERT INTO #Employees...

Please note that the alternative solution for this in SQL Server 2K5 should use the Dense_Rank() rather than Rank()

Regards,

Maz

Let me enhance the Chris Morris solution a little. It does not give the right result in case there are ties (more than 1 persons with same salary).

Using the WITH...

You can use datatype 'numeric'

create table #Tmp (

Id [numeric](1, 0))

drop table #Tmp

By the way, this precision will not allow you to store any decimal part in the field.

[numeric](2, 1) will...

You can use the case function for this as below:

alter view text_vw (itm, sile, eqty) ...

Well it depends on the nature of the database. Knowledge of PL/SQL will help you to understand the business logic of the backend procedures which you have to convert to...

I worked on a project to migrate frm a Oracle 7.3 database to SQL Server 2005. I took help from

1. Microsoft SQL Server Migration Assistant for Oracle (SSMA) -...

You can achieve the same result as follows in SQL Server:

CREATE TABLE [dbo].[Customer_cart](

[Customer_ID] [varchar](50) NOT NULL,

[Item_in_cart] [numeric](18, 0) NOT NULL

)

INSERT INTO [Customer_cart] VALUES ('12ab',123)

INSERT INTO [Customer_cart] VALUES ('12ab',122)

INSERT INTO...