Migrate from Oracle to MS SQL

Posts   
 
    
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 08-Apr-2010 17:39:36   

Hi I recently purchased LLBLGEN and wrote a small project by using self servicing on Oracle DB.

Now, I have decided not to use Oracle and instead use MS SQL.

How can i migrate the code generated from LLBLGEN for SQL from ORACLE by preserving the custom code what I have already written ?

  • Shekar
MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 08-Apr-2010 20:52:05   

Use the project converter in the downloads section of the website to convert your LLBLGen project to another database. If you then regenerate the code you should find that your custom sections have been preserved - but take a backup copy just in case...

Matt

shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 11-Apr-2010 08:29:27   

Ok one last question .

I have now added / altered some tables and relationships. How can I regenrate without losing the custom code

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 12-Apr-2010 07:16:22   

If you wrote the custom code onto the LLBLGen generated files and you did that int he CODE_USER_REGIONS, no problem, you will preserve the custom code. If you used partial classes, that is preserved as well wink

David Elizondo | LLBLGen Support Team
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 12-Apr-2010 10:29:20   

So in order to regenrate [to iclude the alteration in tables which i made], if I just refresh the catalog and generate is enough right?

Walaa avatar
Walaa
Support Team
Posts: 14994
Joined: 21-Aug-2005
# Posted on: 12-Apr-2010 15:18:18   

Yes that's it.

But please make sure your custom code is inside User_Code_regions sections or better in another files (partial classes).