convert between mysql&mssql

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
3/18/2009 3:11:56 PM
Gravatar
Total Posts 251

convert between mysql&mssql

for now i have a working setup of mojoportal with mysql (wow, this cms really rocks!)

if a day i change my hosting and only a ms-sql server will be available, how easy is the database conversion?

in your opinion, which one is better between mysql and ms-sql? I chose mysql because my host will give me more queries

3/19/2009 8:22:11 AM
Gravatar
Total Posts 18439

Re: convert between mysql&mssql

Hi,

There is currently no easy way of moving from one db platform to another. It is possible using some 3rd party tools like SqlYog to migrate using queries but its not trivial. Once upon a time some years ago I was running joeaudette.com using Rainbow portal and MS SQL and after I started the mojoPortal project I migrated from the Rainbow MS SQL schema into mojoPortal/MySql using SqlYog.

Eventually I or someone else will probably implement a migration/backup tool for export and import of data. 

I think both platforms are quite capable, typically the choice is based on personal preference or views on licensing. SQL Express is free and can scale up to 4 GB databases but beyond that you need an MS SQL license, but even with MySql if your scaling needs go up you may need the enterpsies version or some third party tools for replication etc, so the actual costs are hard to speculate on. If you have skills/expertise in one over the other that is also a reasonable way to make a choice in my opinion.

Best,

Joe

3/19/2009 8:34:05 AM
Gravatar
Total Posts 251

Re: convert between mysql&mssql

Thank you for the quick reply

By the way, the tables inside any mojoportal database are organized in the same way for any db server, right?

3/19/2009 8:40:54 AM
Gravatar
Total Posts 18439

Re: convert between mysql&mssql

Yes, but there are some differences in data types, for example MS SQL has a uniqueidentifier data type for guids and in some dbs we are using char(36) or varchar(36), Some dbs may be using an int or tinyint where MS SQL has a bit data type. 

 

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