How can i generate a Custom Module Upgrade Script for MySQL

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.
7/28/2010 9:05:25 AM
Gravatar
Total Posts 2

How can i generate a Custom Module Upgrade Script for MySQL?

Hi Joe,

      two days ago I discovered mojoPortal. It's Great!!! I have seen all your videos to learn how to build a custom module. It's all ok except the upgrade script generation for mysql.. so.. can you tell me where can I find some tricks about this?

 

Thank you. Have a good work.

Roberto

7/28/2010 9:27:39 AM
Gravatar
Total Posts 18439

Re: How can i generate a Custom Module Upgrade Script for MySQL

Hi Roberto,

It works the same as with mssql (in the videos I showed how to do it for mssql) but the scripts are in a mysql folder instead of mssql folder, if you look at the mojoPortal source code beneath the /Setup folder you will see the scripts and upgrade scripts for all features for all supported database platforms.

Best,

Joe

7/28/2010 11:00:58 AM
Gravatar
Total Posts 2

Re: How can i generate a Custom Module Upgrade Script for MySQL

HI Joe, and thanks for your response.

             I see that you have used a CodeSmith Template to generate the MSSQL upgrade script. The problem is that I can't find a template to generate the same script for MySQL. Have i to install MSSQL and then converting the script manually?

 

Sorry for taking your time.

Roberto

7/28/2010 11:28:17 AM
Gravatar
Total Posts 18439

Re: How can i generate a Custom Module Upgrade Script for MySQL

Hi Roberto,

I use codesmith to generate scripts for new tables but other than that I write upgrade scripts by hand if I need to alter a table. There is a codesmith template that you can point at an MS SQL table and generate the table script for MySql. I "think" with newer versions of Codesmith there might be a driver where you could point at MySql tables for script generation, but you would probably need to make custom versions of codesmith templates since mine were built and tested only against MS SQL and based on MS SQL data types.

If you have some other tools for working with MySql and generating table scripts, you can use whatever works.

Hope it helps,

Joe

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