What’s New in dbForge Studio for SQL Server, v5.0

Source Control

  • Support for 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 and Python generators
  • 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