How to transfer db from SQL server to SQL Azure which contains asp.net membership provider with data

Question

In one of my projects, I used Asp.net membership provider, and there is some information about the working environment. Now I need to migrate this database using SQL Azure.

I used the SQLAzureMW migration tool, and this tool performed the corresponding migration, with the exception of aspnet_user table data and some of the SPs , and I skipped this table manually during the last step on this tool

When I looked at the data, the data of the aspnet_users table is missing!

I also read about the New script for SQL Azure , but I think that to create from scratch I also heard about the Universal Provider , but it confuses this.

According to my requirement, what steps do I need to perform to transfer an existing sql db to windows azure sql db (WASD) with data and given this, what will affect this application?

Note. Session status is also managed using the SQL provider here.

Update

Again I tried it with the SQLAzureMW tool, and this time I noticed that due to the default sort type, some of the Sps were missing, so I did it manually according to this link

However, I still need to make sure there will be some kind of problem regarding the state of the session. Or something else since I am migrating it from an existing db to WASD?

Answer 1

Does SQLAzureMW show any message you skip? I had a lot of problems with this tool, but finally I was able to do everything with it. I would try to create only the first data schema and after copying the data. Perhaps you should use the DROP and CREATE option when generating the script if the old data cannot be overwritten. Hope this helps!