Friday, March 9, 2012

Question about database

I have a database that I created in visual web developer 2005 express edition. I have sql server 2005 express edition on my computer, but the databases don't seem to be stored there. The only place that I can find the databases are in the App_Data folder. When I try to copy the database into sql server from the App_Data folder it tells me there is no editor available and make sure the application for file .mdf is installed. I am not sure what to do here.

Can I take the database that I created in visual web developer and move it into sql server, or do I have to recreate the database in sql server?

If I can just copy or move the database how do I accomplish this?

Thanks for the help

I'm not sure what you are trying to achieve. Are you trying to move the database to another SQL Server instance (that is, not the SQL Server Express instance you have?). With SQL Server you 'attach' databases. In SQL Server Express an attach can be done with a connection string setting (AttachDBFileName). The UI tools of the non-express version have an interface to do attach:http://msdn2.microsoft.com/ms190209.aspx

No comments:

Post a Comment