SQL Server Performance Forum – Threads Archive

Oracle to SQL 2000 Migration

I have a problem when migrating from Oracle to SQL Server. This is how I am migrating
SELECT * INTO ALLERGY FROM GTSCOLM..CS71MDAOWN.ALLERGY
GO
The problem is that in that table there are the following entries skin
skin_ where _ is a space. The problem is that in Oracle the space is counted as a char so these are different, in SQL Server it is not so they show up as being the same so i cannot create a unique index on this table. how do I get around this? Thanks

---

See, if this helps:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx ———————–
–Frank
http://www.insidesql.de
———————–

---

]]>