nick.clark
2012-03-01T04:31:26Z
I struggled to setup YAF using Azure SQL. The only resource I could find was a blog post titled “Yet Another Forum (YAF) for Windows Azure” (http://www.blasoft.pl/blog/?p=496&lang=en), but the post only hinted at how to take a current release and use Azure SQL.

The solution ended up being straight forward. The general steps are:

1. Create an Azure SQL database to use to store membership
2. Run Azure specific membership scripts to setup database (http://lluisfranco.com/2011/05/18/using-asp-net-membership-in-sql-azure/ )
2. Create an Azure SQL database to store YAF
3. Create a local database in SQL Express 2008 R2 to store YAF
5. Modify db.config and change the “yafnet“ connection string to the local YAF database
6. In db.config add another connection string called “yafnetmembership” for the Azure membership database
7. Modify web.config to use the Azure membership database. This includes setting the membership, role, and profile default providers and setting those providers to use the "yafnetmembership” connection string.
8. Run YAF locally (I used Visual Studio) and go through the installation wizard (do not check the use “full text” index on the database step)
9. Shutdown the local YAF
10. Modify db.config and change the “yafnet“ connection string to the Azure YAF database
11. Use the SQL Azure Migration Wizard (http://sqlazuremw.codeplex.com/) to copy the local YAF database to Azure.

Note: You will need to make sure you open the Azure SQL firewall.

This approach was much more successful than trying to manually modify the sql install scripts.
Sponsor
Stegothedump
2012-06-20T08:33:45Z
I've been following this through and I'm getting to the last stage "create board" but its throwing up

"Could not find stored procedure 'dbo.yaf_prov_getusernamebyemail'."

Pretty sure this is a red herring but not sure what the actual issue is, anyone seen this when attempting the setup using SQL azure?

Many thanks,

Stephen
Sergii
  •  Sergii
  • 50.2% (Neutral)
  • YAF Forumling
2012-10-15T09:46:00Z
I have created much more detailed guide in this blog post: Install YAF.NET on Windows Azure (SQL Azure): the Complete Guide .
Hope it helps.
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2012-10-15T10:59:13Z
Quote:

Fortunately, you don’t have to manually edit SQL scripts to adopt them to SQL Azure.


Very glad to know! It seems that I've added all required constraints:cheesy:
But you didn't write about your YAF version. Some previous versions require sql scripts modifications.

Quote:

And very important: don’t click the “finish” button on the last step! Just close your browser and shutdown local yaf.net website.


What's wrong? It can be fixed.

Thanks for the updated and very high quality manual!

What do you think about Azure performance?
Sergii
  •  Sergii
  • 50.2% (Neutral)
  • YAF Forumling
2012-10-16T07:26:44Z
I'm using v1.9.6.1 RTW.
And out-of-box scripts require changes, but migration wizard modifies sql scripts automatically.

After clicking Finish, forum opens, and looks like some values are inserted into tables. Later after migration to Azure database, forum is not working properly, e.g. cannot remove default forum. I didn't dick much, but I suppose the problem is with indexes, so it's important not to run forum to preserve local database "clean". "Default" values migrate without problems.

I'm fully satisfied with Windows Azure platform, very easy to setup and maintain; no issues with performance, though I didn't have too many visitors yet.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved