Visual Studio 2010, is there a visual way?

Question

started the visual studio 2010 project. however, I can write sql only in text mode, there is no function in creating the table, for example, in the visual representation, as it exists when you add a new database to the app_data folder and work on it there.

is this the only way and there is no visual way to do this in a Visual Studio 2010 database project? or am i missing an obvious way to get to it?

http://img693.imageshack.us/img693/9311/42342496.png

Thank you

also, if there is a tutorial anywhere (video, maybe !?), please connect it. I just found importing a database from an existing video script using a wizard. I would like to get a new database from scratch without a wizard.

Answer 1

There is a simple workaround that you can use for visual design. You need a developer database created anywhere. Now create a synchronization scheme using the built-in Schema Comparison Visual Studios. This will allow you to pull changes between your dev database and your database project back and forth.

Since you can synchronize in both directions, you can make changes to your database through database diagrams from inside VS (via Server Explorer), or you can use SQL Server Management Studio (or something else that you like). When you're done, just sync your changes using a schema comparison. It also works in the opposite direction, just change one of your scripts and then sync with your dev database.