DB issues exporting to BACPAC for Azure deployment
Just ready to take my locally developed Umb 7.2.2 site with SQL DB and deploy to Azure. So exporting the DB to BACPAC format gives me two errors.
SEOChecker_Robots table has no clustered index & UFUserSecurity table has no clustered index
Both these tables are empty and both belong to paid for packages (licences bought and installed).
Previous advice to simply remove the SEOChecker_Robots table doesn't work as it causes issues with error checking in 7.2.2 and it would therefore need to be rebuild once in place in the cloud. Not sure what the effect would be on Umbraco Forms if the UFSecurity table was removed.
My question is, if I create Clustered Indexes for them both in MSSQLMS, does it matter what I call them?
If anyone has any experience they'd like to share about putting Umbraco on Azure, I'd love to hear it.
I don't think it matters what you call your clustered indexes. I remember the umbraco_UserLogins table requiring one when exporting to Azure. I wrote a blog post a couple of years ago but it should still be relevant if you require additional help.
Thanks Dan. That was very helpful. I created the indexes and accepted the suggested default names and the BACPAC has been created. So far without detriment to package operation:)
DB issues exporting to BACPAC for Azure deployment
Just ready to take my locally developed Umb 7.2.2 site with SQL DB and deploy to Azure. So exporting the DB to BACPAC format gives me two errors.
SEOChecker_Robots table has no clustered index
&
UFUserSecurity table has no clustered index
Both these tables are empty and both belong to paid for packages (licences bought and installed).
Previous advice to simply remove the SEOChecker_Robots table doesn't work as it causes issues with error checking in 7.2.2 and it would therefore need to be rebuild once in place in the cloud. Not sure what the effect would be on Umbraco Forms if the UFSecurity table was removed.
My question is, if I create Clustered Indexes for them both in MSSQLMS, does it matter what I call them?
If anyone has any experience they'd like to share about putting Umbraco on Azure, I'd love to hear it.
Thanks,
Craig
Hi Craig,
I don't think it matters what you call your clustered indexes. I remember the
umbraco_UserLoginstable requiring one when exporting to Azure. I wrote a blog post a couple of years ago but it should still be relevant if you require additional help.Hope that helps.
Thanks, Dan.
Thanks Dan. That was very helpful. I created the indexes and accepted the suggested default names and the BACPAC has been created. So far without detriment to package operation:)
Craig
is working on a reply...