Home » SQL & PL/SQL » SQL & PL/SQL » how to migrate the encrypted data from one data base to another data base
how to migrate the encrypted data from one data base to another data base [message #407308] Tue, 09 June 2009 09:48 Go to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
Hi,
I am facing one problem while migrating the encrypted data(like credit card number) from one data base to another data base.
One table in my 8i database has column with encrypted format. Now i wants to migrate this data to another data base 11g. i have migrated this data as it is(i didn't decrypt while fetching from 8i and not encrypted while inserting into 11g). But when i am trying to decrypt this data in 11g, it is giving some junk characters. I used same key in both the data bases. Please let me know the feasible and secure solution for this problem.
Re: how to migrate the encrypted data from one data base to another data base [message #407315 is a reply to message #407308] Tue, 09 June 2009 10:04 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What datatype are the columns on the two databases, and how did you migrate the data?
Re: how to migrate the encrypted data from one data base to another data base [message #407319 is a reply to message #407315] Tue, 09 June 2009 10:10 Go to previous messageGo to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
It is VARCHAR2(24)in 8i, and VARCHAR2(50)in 11g.
we are using some .NET DTOs , which will take the data from 8i and pass to 11g.
Re: how to migrate the encrypted data from one data base to another data base [message #407325 is a reply to message #407319] Tue, 09 June 2009 10:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>which will take the data from 8i and pass to 11g.
Will not work.
You will have to go through a proper migration path using Oracle supported native migration utilities.
Using any other method to extract the data and loading will not work.
How many of such tables you have?
Not just with this encryption. As 8i and 11g differ by generations, you may run into other issues like de-supported / changed functionality.
Re: how to migrate the encrypted data from one data base to another data base [message #407726 is a reply to message #407308] Thu, 11 June 2009 05:38 Go to previous messageGo to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
Thanks for your reply Mahesh.
I have only one such type of table.
More over it should be done via .NET project only. Because layers can be plugged -in and out easily via .NET, they have choosen it. I dont have any other oracle migrating utilities Sad
Can i decrypt while fetching the data from 8i and send to .NET components? while fetchig data from .NET components to 11g, i will encrypt and insert into 11g table. will it work?
Please give me some idea.
Re: how to migrate the encrypted data from one data base to another data base [message #407734 is a reply to message #407726] Thu, 11 June 2009 06:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can i decrypt while fetching the data from 8i and send to .NET components? while fetchig data from .NET components to 11g, i will encrypt and insert into 11g table. will it work?


If you can get the clear and correct values after decrypting in your .NET component then you can do it this way.

It is highly recommended to use a RAW datatype for encrypted value and not VARCHAR2 or be sure that your algorithm only generates characters in 1-127 code points (which is not your case).

Regards
Michel
Re: how to migrate the encrypted data from one data base to another data base [message #408459 is a reply to message #407734] Tue, 16 June 2009 05:28 Go to previous message
rajesh4851
Messages: 89
Registered: January 2007
Member
Thanks Michel
Previous Topic: copying data to a table (merged 6)
Next Topic: Days between
Goto Forum:
  


Current Time: Sat Dec 10 13:11:31 CST 2016

Total time taken to generate the page: 0.05106 seconds