{"id":1962,"date":"2014-12-10T13:48:18","date_gmt":"2014-12-10T11:48:18","guid":{"rendered":"http:\/\/mariusbancila.ro\/blog\/?p=1962"},"modified":"2015-01-08T22:49:40","modified_gmt":"2015-01-08T20:49:40","slug":"a-tale-of-visual-studio-and-sql-server-compact","status":"publish","type":"post","link":"https:\/\/mariusbancila.ro\/blog\/2014\/12\/10\/a-tale-of-visual-studio-and-sql-server-compact\/","title":{"rendered":"A tale of Visual Studio and SQL Server Compact"},"content":{"rendered":"

I have recently upgraded my SSD disk to a newer and larger one. To avoid the hassle of re-installing everything (I have a lot of things to install) I cloned the disk. Everything worked fine. No problems with the operating system and the applications, except for Visual Studio. Though I could start, edit, build, run, etc. some things just did not work.<\/p>\n

When I opened a solution with both C++ and .NET projects I noticed that the C++ projects took a lot to initialize. When I say a lot I mean minutes, many minutes. That didn’t seem right, but I had patience. However, after they finally passed the Initializing<\/em> phase I noticed that it was no possible to select the configuration and target for the solution to build. The combos were disabled and nothing was displayed there. I could actually build, but it was the last selected configuration and target that were built. I tried deleting generated files (such as the .suo file) and after that, the last selections appeared in those combos, but they where still disabled.<\/p>\n

\"vstrb3\"<\/a><\/p>\n

Then I noticed that the properties window was not able to show anything, whether it was the properties of the project, a file or a reference. Everything was very slow. I could edit, but sometimes it took seconds for the text to show up. When I checked the resource monitor, it turned out that Visual Studio was using 17-18% of my CPU.<\/p>\n

\"vstrb1\"<\/a><\/p>\n

Finally, I noticed a warning when I closed the solution:<\/p>\n

\"vstrb2\"<\/a><\/p>\n

The .sdf file was not present in the specified location. So then I figured it must be a problem with Microsoft SQL Server Compact. Therefore I downloaded the kit from the download center<\/a> and installed it again. That worked like a charm. Visual Studio was able to create the missing .sdf file, the Visual C++ projects loaded very fast and all other symptoms disappeared. <\/p>\n

My conclusion was that cloning the hard-disk didn’t work well for SQL Server Compact. But the problem is that Visual Studio doesn’t react well when this component is missing. It should display the warning about it when it fails to create the file, not when you close the solution.<\/p>\n","protected":false},"excerpt":{"rendered":"

I have recently upgraded my SSD disk to a newer and larger one. To avoid the hassle of re-installing everything (I have a lot of things to install) I cloned the disk. Everything worked fine. No problems with the operating system and the applications, except for Visual Studio. Though I could start, edit, build, run, … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[10],"tags":[434,433,458,421,55,362],"class_list":["post-1962","post","type-post","status-publish","format-standard","hentry","category-visual-studio","tag-sql-server-compact","tag-sqlserver","tag-tools","tag-troubleshooting","tag-visualstudio","tag-vs2013"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t