Geek Answers Handbook

How to run aspnet_regsql on sql azure?

Possible duplicate:
Migrate an ASP.NET Membership Database to Azure SQL

How to run aspnet_regsql in azure sql database? I did this with difficulty exporting all db objects. However, I seriously believe that there is an easier way. Please, help.

+4
source share
2 answers

When you run aspnet_regsql in the azure sql database, the error only occurs because SQL Azure does not support the USE statement to switch database contexts when executing commands with Azure SQL databases.

To get around this, Microsoft has created a hotfix. The following steps show how to use the tool provided by the fix.

  • Download the aspnet_regsqlazure.zip file from the patch page .
  • Extract the contents of the file to the local local hard drive.
  • Open a command prompt and change to the directory in which you extracted the files.

Use the following command line to run this tool (if necessary, replace the server name, database name, login and password).

aspnet_regsqlazure -s [your server name].database.windows.net -d [your database name] -u [your user name]@[your server name] -p [your password] -a mr
+10
source

The membership provider created by aspnet_regsql.exe is deprecated.

Please use the new Universal Providers , which is compatible with Azure.

Update - 07/23/2015

Microsoft has a new membership called Identity . Current version 2 at the time of this writing.

+6
source

More articles:


All Articles