How to Convert List of values datatype in oracle to equivalent or valid datatype in sql server?

1 vote

1 answer

275 views

sql-server sql-server-2008 oracle-11g-r2 migration

                          I want to recreate the table below in  SQL server I have tried using SSIS but it does not know how to handle the lOV Data type how can I recreate this table in SQL server and migrate the data to it.

    create Table Listing
    (
     NAME                    VARCHAR2(30), 
     VALUES                  NUMBER,       
     LIST_OF_VALUES          LOV,          
     id                      VARCHAR2(30) 
    );
  I am new at trying to converting this type of data or data type, in general, your help would be appreciated.
                        

Asked by Nigel Givans (141 rep)

Jan 30, 2019, 03:46 PM
Last activity: May 16, 2025, 05:09 PM

How to Convert List of values datatype in oracle to equivalent or valid datatype in sql server?

Related Questions