ASP.NET membership provider export and import

Question

My application uses ASP.NET membership provider. It connects to an Oracle database where it hosts the membership schema.

I have a need to move existing production users on orable db1 to oracle db 2 which will host the same aspnet membership schema. How would I achieve this?

What would be a better solution? Database or C# code? Or, are there any tools that already do this job of exporting asp.net membership schema and data to the new database?

Answer 1

first of all make a store procedure well format. if you want debug the store procedure then just select the store procedure like this way.


create proc procedureName
()
as 
begin


end


if you want debug any store procedure select the procedureName and press the CTRL+F5. your studio convert to in debug. 

Answer 2

Go through following links it will help you

https://msdn.microsoft.com/en-US/library/yet1b7by%28v=vs.80%29.aspx

http://stackoverflow.com/questions/1793612/debugging-stored-procedure-in-sql-server-2008