Migrating from a local server to Azure

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
4/17/2014 12:43:08 PM
Gravatar
Total Posts 27

Migrating from a local server to Azure

Hi I am migrating my installation of mojoportal (2.4.0.0) based on MSSQL Server 2012 Database to Azure. In fact I created a new installation of Mojoportal on Azure and I would like to transfer the data.

I tried the MSSQL Server tool that distributes the database to Azure. But there is a blocking error in the export database with this table " dbo.ws_Discount" Error SQL71564 the table does not contain a cluster index.       

Do you have any suggestion on how I can solve the issue?

Thanks

4/17/2014 12:56:34 PM
Gravatar
Total Posts 18444

Re: Migrating from a local server to Azure

That table has existed for a long time and as far as I know has never had a problem in SqlAzure.

However, when I look at it in sql management tools using design view and then click the manage indexes and keys button in the upper left toolbar, I see that when I click on the primary key for "Create as Clustered" it says no, so I guess the thing to try is changing that to yes. I see it is yes on other tables. So on your local machine in sql management tools right click the table and choose design, then click the toolbar icon in the upper left for manage indexes and keys, then click on the index named PK_ws_Discount then change create as clustered to yes if it possible, save it and try again with the migration.

I've never had any trouble with running our sql setup scripts on a new sql azure database so not sure why it is having a problem on migration.

Hope that helps,

Joe

4/18/2014 8:54:44 AM
Gravatar
Total Posts 27

Re: Migrating from a local server to Azure

Thanks Joe! It worked fine!

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