Different database platform

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
6/12/2012 11:49:12 PM
Afrooz
Gravatar
Total Posts 5
View Posts

Different database platform

Hi,

I want to store some of mojoportal data into another database which is OODB, how can I do that. As I read you are insisting of not doing code forking, so please guide me how to do this.

For eg. whenever one user create a profile, Some of user info will be save also in another DB platform.

Thanks and Regards 

Afrooz Rahmati

6/13/2012 5:56:58 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Different database platform

I don't have a solution for you other than to suggest that you may be able to synchronize data to another platform using external 3rd party database tools.

For custom features you can write your own code and use any database platform you want but for built in things we support using either MS SQL, SQL CE, MySql, PostgreSql, Firebird, or SQLite. But you can only choose one, you can't put some data in one platform and other data in another platform.

6/13/2012 6:54:36 AM
Afrooz
Gravatar
Total Posts 5
View Posts

Re: Different database platform

Thanks Joe,

but the synchronization is important for me, imagine user will register into website so the information for him will be save for eg in sql server, at the same time after registration user will login and wants to change his profile information ( I want the profile information to be saved on the OODB databases) so it would be a problem bec the user data still not transferred to the  OODB.

therefore I need to use some how code forking!, where do you think it would be better to put my code for interaction with OODB database also? in Bussiness layer or Data layer?

Thanks

Afrooz

6/13/2012 7:06:52 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Different database platform

I have no suggestion for you. Once you fork the code I cannot provide support, you must be able to support yourself and live with your own decisions if you do that. It will be problematic for you to upgrade once you fork the code.

Possibly there are ways to add a trigger on insert of the mssql tables to make it sync immediately to your other platform, but I don't know how to do it, you will have to find your own solution.

Or you could implement a custom user registered event handler and from there make your own web service or code to push data to your other platform.

You must sign in to post in the forums. This thread is closed to new posts.