Likely, however, you will have existing databases that you would like to import into a database project. The obvious and easy way is to simply create a new database project and start developing the database from the grounds. Visual Studio was a premium and quite expensive product, however, a few years ago Microsoft released the Community edition which is free! You can download a copy from here: Create a new schema There are several ways to start database development in Visual Studio. If you know how to get started in Visual Studio and how to import the database you can jump straight to the benefits of using Visual Studio for database development How to start I have made a switch from developing in SSMS to Database Development in Visual Studio several years ago and never looked back. As a production DBA, I can definitely say that there are situations where this is acceptable and even desired, however, usually a Visual Studio Database Project is a better approach. A lot of database administrators and developers like to use the SQL Server Management Studio to make changes to the database schema directly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |