You are viewing limited content. For full access, please sign in.

Question

Question

Oracle to SQl Migration

Migration
Updated two days ago
asked on June 4

I am getting I am getting the following error when I try to migrate data from Oracle 11g to SQL 2022 using the Laserfiche Oracle to SQL migration tool. "The type of column "PAGEID" in table "loc" is "System.Int64" in database "oracleDB", but expected type is "System.Decimal". Which is the best way to resolve this issue without losing any data?

Mark

0 0

Replies

replied two days ago

Mark, apologies for the runaround. Tech Support reopened your case and has instructions for you to address the potential schema corruption so you can complete the conversion. 

1 0
replied on June 4

Hi Mark, please open a support case.

The Laserfiche Oracle to SQL migration tool is a very specialized utility and because errors in database migrations have the potential to cause data loss, we'll want to make sure we have all potentially relevant information before recommending how to proceed.

replied on June 4

Hi, I'm not expert, but I put your question in ChatGPT, and provide me a few steep to follow. I will share with you the conversation, maybe give to you an idea how to proceed. 

https://chatgpt.com/share/6840fb0d-b6bc-8000-a614-9c98e90cfe02

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...