I designed a database on my local machine (cert.mdf), and attached it to SQL Server Mgmt Studio. I signed up with a db hosting company and copied it to their site (using "script database as / create to") and got it set up out there.
Since then I've made further changes to the design, but only to the web-based version.
Now I'd like to bring the web-based design back to my local cert.mdf so I can do some further development & testing but I can't seem to find a way to do that. (I don't mind being destructive on my local machine). If I try the same thing but
in reverse, I get a 'metadata unreadable' error. If I just try a copy (via mgmt studio) I get a message about 'unable to connect to local server'.
View Complete Post