In Visual Studio 2012, I have two database connections configured in Server Explorer. One for the SQL Server 2008 R2 database, the other for the SQL Server 2012 database. I could always make quick in-line data changes with SQL 2008 databases by right-clicking on the table and selecting "Show Table Data".
Then I could open the SQL panel and query for the data, place the cursor directly in the field and edit the data in the result set. I relied heavily on this method when editing data quickly without the need for a script.
This option does not seem to be available for SQL Server 2012 connections. When I try to do the same, it seems to open in the context of SQL Server Database Tools (SSDT). I will see the original result set of 1000 records, but unlike SQL 2008, there is no easy way to run a more accurate SELECT query and edit the embedded data by selecting and overwriting the values in the result set. The screenshot below is the closest I can get by opening a new query window, but still could not integrate the editing of the results.
Is it possible to make the 2012 database behave like a 2008 database in Visual Studio? I skipped the SQL 2012 installation component that prevents this behavior? Or has Microsoft pulled out these features? I desperately want to get inline editing back, I don't want to write UPDATE queries to fix single rows of data, it is slower and seems more risky. If an offer is unintentionally omitted, it can lead to the decomposition of a large amount of data.
Any thoughts would be greatly appreciated.
source share