Using database on another development machine
I am developing an ASP.NET website. I wanted to shift whole of my work to another PC of mine. I copied the website to the other PC>Open>Create ASP.NET folder>App_Data
and pasted the database.mdf and database.ldf files there. I was getting some exception when I was trying开发者_运维技巧 to run the website as it showed the "could not open the connection from con.open()
". Is there some other step too that I am missing?
Sql Server database files are not like any simple html files that can be copied between machines. You need to make sure that the database that is getting served up: e.g. there is a Sql Server instance running that can present the database to your web application.
Here's an article on how to attach an mdf file to a Sql Server.
You need to attach the mdf and ldf files to the sql server instance on the target machine. You may need to adjust your connection string as well, unless you used a local name reference like "." for the data source.
What is your connection string? Chances are the path in the connection string has the local path to the database file on your original development machine.
精彩评论