Database Cycle Management is Hard.

Microsoft create SQL Server Data Tools to Visual Studio 2013, to  turn easier the development.

  • Single Tool to support developer’s needs.
  • Can build, debug, test, maintain, and refactor databases.
  • Developers can use familiar Visual Studio tools for database development.
    • Code navigation, IntelliSense, C# language, platform-specific validation,
      • debugging, and declarative editing in the Transact-SQL editor.
  • Works connected or disconnected (Tools work on top of design time)
  • Have Schema Model differencing capabilities (Compare and Update Model)
  • Schema and app under TFS control
  • Publish to all supported SQL platforms

Read more of this post