Migrating from CFMX5.5 to ASP7.0 HOW TO????

[robreil]

I have CF5.5 version and based on the fact that Able will no longer be upgrading CFMX versions of their code and I need to utilize custom code I wish to migrate from 5.5CF to 7.0ASP.

I have custom database fields being used in MySQL 4.1.

I also want to have this hosted outside our site, and have the host provide a separate DB for us as we are going to start working with adding tables etc as we go. I hear 7.0 supports that and that to me is a big selling point to help us grow into a custom cart.

Please advise the following.
How do i migrate?
Any reccomended hosts?
Any reason I should get away from MySQL and go to MSSQL? (Im guessing that hosting companies like the MS Support options)

[AbleMods]

I also want to have this hosted outside our site, and have the host provide a separate DB for us as we are going to start working with adding tables etc as we go. I hear 7.0 supports that and that to me is a big selling point to help us grow into a custom cart.

AC7 supports additional tables only by the fact it doesn't blow up if you add some. It's not like you can add a table to the database and new functions and methods are automatically available in the programming side. If you add a table, you'll still have to program all the functionality needed to maintain that table. Not a major deal, but definitely something to be aware of as you move forward.

Please advise the following.

How do i migrate?

Talk to Able directly by submitting a support ticket. Migrating a customized ColdFusion 5.5 site into AC7 isn't something that can be easily documented in a forum post.

Any reccomended hosts?

There are several other posts in the forums with recommendations on hosting providers. It all depends on whether you want to own the hardware, have your own VPS or exist with 100 other sites on the same box as yours. The forum search feature should turn up what you need to know.

Any reason I should get away from MySQL and go to MSSQL? (Im guessing that hosting companies like the MS Support options)

AC7 doesn't support MySQL.

[mfreeze]

We host both CFMX 5.5 and ASP 5.5 sites and are converting both versions to ASP 7.0.

You can export a CFMX 5.5 site from the administration and import it into 7.0 using the Dataport utility. The only question I have is whether there are any differences in the db schemas between MYSQL and MS/SQL and if that would affect the export/import process. Somebody from AC would need to answer this question. All of our CFMX sites are MS/SQL.

We are working on the conversion of 2 CFMX sites now and there are some gotchas. We had to run SQL queries to update data in some of the tables, like links that pointed to .cfm files, etc. But it can be done with the right knowledge and a little extra work.

Keep in mind that the layout and any customizations to the code would require manual efforts to convert. The dataport will only import your data.

AC7 is definately worth the work to convert.

[robreil]

Mary:

You never did give me a migration quote.
Contact off list plz.

[mfreeze]

Check your messages. I sent you a pm.