I'm guessing something like this has been posted before, but I'm having trouble finding excatly what I'm looking for. Here's the situation.
I am building a site based on the club starter kit. The database appears to be part of the web project. I've modified some of the tables so it's not the original club database anymore.
I would like to move this database to SQL Express (i.e. the database will appear in my SQL Server Mgmt. Studio) and I would also like to try to move it to SQL 2005. I don't have a host yet, so I think being able to move it to either product would be beneficial.
I would like to have the knowledge to do both, and am assuming the process is probably similar for both sql products. Basically, I would like the database to NOT be part of the web project.
If someone could point me to instructions to do this, it would be greatly appreciated. I've searched around a bit, but haven't hit on something that would help me out.
glura
Member
122 Points
44 Posts
move database from web dev express to SQL 2005 or SQL Express
Jun 24, 2006 04:40 PM|LINK
I'm guessing something like this has been posted before, but I'm having trouble finding excatly what I'm looking for. Here's the situation.
I am building a site based on the club starter kit. The database appears to be part of the web project. I've modified some of the tables so it's not the original club database anymore.
I would like to move this database to SQL Express (i.e. the database will appear in my SQL Server Mgmt. Studio) and I would also like to try to move it to SQL 2005. I don't have a host yet, so I think being able to move it to either product would be beneficial. I would like to have the knowledge to do both, and am assuming the process is probably similar for both sql products. Basically, I would like the database to NOT be part of the web project.
If someone could point me to instructions to do this, it would be greatly appreciated. I've searched around a bit, but haven't hit on something that would help me out.
Thanks in advance,
Gary
jeff@zina.co...
All-Star
87677 Points
11637 Posts
Moderator
Re: move database from web dev express to SQL 2005 or SQL Express
Jun 26, 2006 06:15 PM|LINK
The secret is the SQL script in the App_Data folder, club-add.sql. Also useful is aspnet_regsql.exe. See:
http://msdn2.microsoft.com/en-us/library/x28wfk74.aspx
Jeff