I have no idea what went wrong with my Visual Studio, but I am unable to publish or schema compare any database on my development server. Here are my two issues:
When publishing a new database I get an error message after timing out that says "Unable to reconnect to database"
When schema comparing to an existing database I get an error message saying "An error was received from SQL Server while attempting to reverse engineer elements of type..."
Additional Troubleshooting
The only recent change to the server was that I restored two production database backups into my development server. I do not know if this is when the issue started.
What else can/should I be trying??
Update This question is still preventing me from schema comparing or publishing any database. Even from a new project. Additional troubleshooting since the first post:
Please try updating to the latest version of SSDT (the tools for working with databases in Visual Studio). Also, since you are using VS 2012, consider trying VS 2013 Express, at least to see if it fixes your issues, as it includes the tools for working with database projects.
Verify that you can build your DB project before starting the Schema Compare.
Although building is part of the Compare process, sometimes build errors aren't clearly shown when using Schema Compare.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With