Thanks for the very informative feedback Scott. Yes I agree with you, data or code migration from Oracle to SQL Server has to be taken very carefully and has to...

Jeff Moden (8/20/2008)

Nicely done, Richard and thanks for the "cover".

Just to continue the thought, there are other ways to pull off such concatenations and some have a pitfall or two......

Hi Talib,

yeah I know that your problem was solved. I just added my comments as you asked

But again if you have any idea ...

Hi Talib,

1. Take care to prefix the non-english strings with N as explained in the below link from the Microsoft support

http://support.microsoft.com/kb/239530

You must precede all Unicode strings with a prefix N...

Dear PaulB and Richards,

Both of you deserve kudos for sharing such valuable info.

Just to add my two cents:

The DTS which was part of SQL Server 2000 is now called...

Dear PaulB,

Other that what's the reason you guys do not read what I write... my doubt is: what a big pile of rubbish!!! from which paralell Universe you all come...

You can use DBMS_SQL package in this case.

http://download-uk.oracle.com/docs/cd/B28359_01/appdev.111/b28370/dynamic.htm

What is the datatype in your database. Change to nvarchar if it is numeric. Also you may have to look at the language settings of your PC and the Crystal...

Thanks again for your feedback on the subject. No matter what is the jargon, most important is to understand how things work and get things done.

1.

I wonder why to disagree when Oracle itself is defining logical backup as a valid...

I think the term 'lazy' does not go in sync with the 'developer' as he is the one who has to somehow deliver the product (whatever the quality) using which...

I think logical backup and recovery using the exp and imp utilities are also very useful and important as it allows to take backup of selected objets in the schema...

Hi gints,

Is it not the logical backup ?

Thanks,

Maz

Try to use the DTS (Data Transformation Services) if you are working with SQL Server 2000 or SSIS (SQL Server Integration Services) if you have SQL Sever 2005 or above....

Hi PaulB,

Apart from this 'sybtax', could you share a little about the database backup methodology in Oracle. Being an Oracle developer for long in past and now SQL Server developer...