Fortunately, VS 2010 provides some database tools that you can use to make your database application development easier and more seamless.
Select Database, SQL Server from the list of installed templates.
Database Solutions, database Solutions provide a way to group all of your SQL Server development into one or more VS 2010 solutions.
To start VS 2010 Table Designer, use Server Explorer to open a SQL Server database connection.This feature was carried over from the earlier Visual Studio for Database Professionals edition, which has since been discontinued.Execute the script by right-clicking the T-SQL editor and selecting the Execute SQL option from the context menu.Some of the cool database development features in VS 2010 include these:.Compare Data and Compare Schema.Sqlclr Projects, although you can use either ssms or VS 2010 to create T-SQLbased scripts and database objects, you must use VS to create sqlclr objects.Query Designer will be displayed in the VS editing istat menus 3.24 crack pane.Another powerful database feature thats new to VS 2010 is the ability to compare database schema and database tables.Server Explorer, without a doubt the most essential database tool in VS 2010 is Server Explorer.You can run the query by right-clicking the designer and selecting Execute SQL.To add a new Database Solution, select File, New, Project from the VS 2010 menu.You can develop T-SQL scripts and other database objects in VS 2010 via the T-SQL editor, which provides full T-SQL IntelliSense as well as T-SQL debugging.Query Designer, vS 2010 also includes a visual Query Designer that you can use to design queries.Then expand the connection node, right-click Tables, then select Add New Table from the context menu.Then select either Visual Basic SQL CLR Data Project or Visual C# SQL CLR Database Project.This feature also enables you to create definitions for all types of database objects and deploy these objects to a target SQL Server database.Sqlclr objects can be created using either Visual Basic or C#.You can run the Compare schema and compare data options by using Server Explorer: Right-click the database connection node, then choose either the Compare Schema or Compare Data options from the context menu.On the Add Connection dialog box, you fill in your SQL Server system name, add the required authentication information and database name, and click.This adds a database node to Server Explorer which allows you to work with diagrams, tables, views, stored procedures, functions, synonyms, types, and assemblies.To create a new sqlclr object, right-click your Database Solution in the Solution Explorer and select Add, New Project to display the Add New Project dialog box.
This opens Table Designer in the VS editing pane.