dbForge Studio for SQL Server released

dbForge Studio for SQL Server is an IDE for SQL Server development, data reporting, analysis and administration. It helps you write SQL code, design tables, compare databases, synchronize schemas, automate deployment, create reports and manage database security.

Features

• Master-detail data browser.
• Data report generation wizard.
• Data report designer.
• Pivot table designer.
• Chart building wizard.
• Compare and synchronize data in databases of virtually any size.
• Compare tables, views, and custom queries.
• Data synchronization script generation.
• View differences on each record of data.
• Save and load comparison settings.
• Command line interface for data comparison and synchronization.
• Customizable data filters.
• Date time editing with visual UI.
• Foreign key lookup editor for easy editing of fields referencing other tables.
• Group by user-defined columns.
• Multi-table query resultset editing.
• Paginal data browsing for large result sets.
• Read-only status indication.
• Quick build reports, charts and pivot tables.
• Multiple database connections.
• Quickly template script generation for SELECT, INSERT and EXECUTE.
• Data search on a live database.
• Schema object search by name.
• Schema object search by substring of DDL text.
• Data export to CSV, XML, Text, XLS, PDF, DBF, HTML, RTF, MDB (Access) and ODBC.
• Data import from CSV, XML, Text, XLS, XLSX, DBF, MDB (Access) and ODBC.
• Preview changes before database modification.
• Supports SELECT, INSERT, UPDATE and DELETE statements.
• Diagramming with zooming and keyboard support.

About Devart

Devart is a leading company working in the database connectivity area. They offer well-known native VCL/CLX components and dbExpress drivers for direct access to Oracle, MS SQL Server and MySQL. They provide advanced data access solutions for ADO.NET data providers for native connectivity to Oracle, MySQL, and PostgreSQL database servers. Devart is also a vendor of powerful database tools designed to automate and simplify database development processes.