First time here? Check out the FAQ!

Is it possible to convert nvarchar32 in Oracle to uniqueidentifier in SQL?

0 votes
asked by about DB Best OraMigrator
edited by

I have a source Oracle database and destination a SQL template database (all the tables and structures available in SQL template database), and in source we have columns with datatype nvarchar(32) and the corresponding destination datatype is uniqueidentifier and I have tried the trial version of Oramigrator and tried to migrate a single table and shows the error "Data migration reported error: The given value of type String from the data source cannot be converted to type uniqueidentifier of the specified target column." Is there a way to address this issue with this tool?

1 Answer

0 votes
answered by (329k points)

Apparently, you'll have to crawl the websites listed on Google Search since there isn't an exact and direct way to convert between the strings and data type you have mentioned in your inquiry.

Kindly access the following link that displays all the websites that are in connection to your inquiry above. You'll have to read a little to get the job done.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register