Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Combined two databases into one.

Author  Topic 

davidshq
Posting Yak Master

119 Posts

Posted - 2005-11-14 : 23:03:14
I created an application using Visual Web Developer Express and SQL Server 2005 Express. When I did so, VWD automatically created ASPNETDB.MDF to handle the membership, roles, profiles, etc. I created a separate database to handle all the rest of the programs information. Now I'd like to combine those two databases. I don't have any membership/configuration info. on ASPNETDB that needs to be saved so I tried using aspnet_regsql.exe to just create new membership provider info., etc. in my other database, but that failed (I'm guessing aspnet_regsql only recognizes SQL Server 2005 full). So now I need another way to create that information or something to move the info. from one databae to the other. Any ideas?
David.

- http://www.civilwarsearch.com/
- http://www.thehungersite.com/
- http://www.grid.org/
   

- Advertisement -