How to copy/attach mdf to new installation
Posted on 2010-11-17
I just published my first application in VB.NET and installed it on a new machine. The database was created in SQLExpress 2008. How do I copy the database to the new machine and attach it to SQL Server there? Does it matter which version of SQL Server I use on the new machine? When I try to copy the physical file, I get an error that it is being used by another person or program, although I have everything shut down. Help!
Thank you in advance!