Copying data between databases

Posts   
 
    
ww
User
Posts: 83
Joined: 01-Oct-2004
# Posted on: 08-Mar-2022 20:38:16   

My application supports both SQL Server and Oracle databases. I have a customer who is moving from Oracle to SQL Server. Is there an easy(ish) way to do the data migration in LLBLGen? Do I need to load each entity on the Oracle DataAccessAdapter, clone it, and then save it using the SQL Server DataAccessAdapter, or is there a way to cut out the cloning?

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 09-Mar-2022 06:22:41   

There is no out-of-the-box way to do that. You will need to build the data migration procedure your self, pretty much as you have explained it.

ww
User
Posts: 83
Joined: 01-Oct-2004
# Posted on: 09-Mar-2022 18:12:02   

Thank you.