Home > IT Answers > Database > Oracle to SQL Server Migration – User Defined data types
Kumar9378
25 pts.
 Oracle to SQL Server Migration – User Defined data types
Database migration, Oracle import/export, Oracle migration, SQL Server 2005, SQL Server import/export, SSMA for Oracle
Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

Software/Hardware used:
ASKED: August 22, 2008  1:38 AM
UPDATED: August 28, 2008  3:58 AM
RELATED QUESTIONS
Answer Wiki:
SQL Server doesn't have array data types. The closest thing we have is a user defined data type where the type is a table. Here is the sample code from Books OnLine. <pre>CREATE TYPE LocationTableType AS TABLE ( LocationName VARCHAR(50) , CostRate INT ) GO</pre> --------- Thanks Mrdenny. I have created a temp table as create table #tempSetIds (Id int) wherever the user defined type <b>arrayType1</b> was used
Last Wiki Answer Submitted:  August 28, 2008  3:58 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.