SQL Azure compatibility

Sep 8, 2011 at 11:21 AM

Hi Will,

I downloaded the module and try it on a portal on Azure, but when I installed it the typical SQL Azure incompatibilities raised. I modified the package files as shown below and I successfully installed it:

File

Changes

01.00.00.SqlDataProvider

  • Removed “NOT FOR REPLICATION”
  • Removed “ON [PRIMARY]”

01.00.01.SqlDataProvider

  • Removed “NOT FOR REPLICATION”

01.02.00.SqlDataProvider

  • Removed “NOT FOR REPLICATION”
  • Removed “ON [PRIMARY]”

01.06.00.SqlDataProvider

  • Removed “NOT FOR REPLICATION”
  • Removed “ON [PRIMARY]”

P.S. I think that all the people at DNN are using RedGate to generate the SQL Scripts -at least for the look of them-. If true, there are two settings ("Ignore NOT FOR REPLICATION" and "Ignore Filegroups") in order to don't include this information on the generated scripts. I set that as default and most of this typical problem gone. Tell the tip there!! :)

Regards

Sep 11, 2011 at 3:44 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Sep 11, 2011 at 3:44 AM

Thank you so much for this. I am working on the next release right now.  This has been added to the road map for v01.09.00.