dbForge Studio for SQL Server

Source-Controlling Databases in dbForge Studio for SQL Server 5.0 Beta

September 2, 2015

We are delighted to announce the release of dbForge Studio for SQL Server, v5.0 Beta. The new version allows to source-control SQL databases in the most popular source control systems. In addition, you can take advantage of 180+ meaningful data generators and new code completion features.

Source Control

  • Support of Subversion (SVN), Team Foundation Server (including TFS Cloud), Git (including GitHub), Perforce (P4), Mercurial, SourceGear Vault systems
  • Source-controlling a working folder
  • Source Control Manager
  • View Changes History Window
  • Resolve Conflicts

Data Generator

  • 180+ meaningful generators
  • Enhanced RegExp generator
  • Constant generator, Files Folder generator, Foreign Key generator, Lorem Ipsum generator, Shuffled Text generator, Twaddle generator, SQL Query generator, Table or View generator, Text File generator, Uniqueidentifier generator, Weighted List generators
  • Creating user-defined generators
  • Support of composite foreign keys
  • Matching for more intelligent table mapping
  • Command-line interface

Code Completion

  • New snippets
  • UPDATE statement expansion
  • Custom alias mapping
  • Pair highlighting
  • SQL refactoring
  • Semicolon insertion
  • Phrase completion
  • Support of the following statements: MERGE, CREATE DATABASE, ALTER DATABASE, DROP DATABASE, BACKUP DATABASE, EXEC sp_attach_db, EXEC sp_detach_db, CREATE STATISTICS, UPDATE STATISTICS, DROP STATISTICS, CREATE INDEX, ALTER INDEX, DROP INDEX, ENABLE TRIGGER, DISABLE TRIGGER

Database Synchronization

  • Database script folder - create, compare & sync
  • Comparison with database script folder in version control

Availability

Download trial version of dbForge Studio for SQL Server now and evaluate the benefits of the Professional edition features for free during a 30-day trial period.

Join our forum to participate in discussions around Devart software, including dbForge Studio for SQL Server. Find answers to your technical questions and other valuable information on dbForge Studio for SQL Server and other products for SQL Server.