SQL Developer Bundle

• Save time syncing databases: set up comparisons in seconds, check the differences from an editable list, then specify the changes you want to sync.
• Eliminate mistakes in deployment: automatically create accurate scripts for deploying database updates.

SQL Compare and SQL Data Compare are the industry-standard tools for schema and data comparison and deployment. They're fast, easy to use, and relentlessly tested to provide accurate results and flawless deployment scripts.

Powered by: SQL Compare and SQL Data Compare

• Sync from backups and script files: use backup files or SQL scripts as the source for your database updates.
• Deploy straight from source control: update test databases with the development version stored in your source control system, using the SSMS plug-in SQL Source Control, also included in the SQL Developer Bundle.

SQL Compare and SQL Data Compare allow you to sync your databases from multiple sources, making roll-outs from backups or source control a breeze.

Powered by: SQL Compare and SQL Data Compare

• Source control within SSMS: connect databases to your source control system within SSMS, so you can share your changes and get the latest updates without interrupting your work.
• Supports multiple version control systems: plug your database code into TFS, SVN, Vault, Mercurial, Perforce, Git, or any other version control system with a capable command line.

SQL Source Control links your databases to your existing source control system straight from SSMS. You can work on a central database or local copies, track who made changes, and share, receive, and revert updates without breaking your workflow.

Powered by: SQL Source Control

• Deploy as an .exe: script and compress schema and data into an easily deliverable .exe file.
• Package scripts: package any SQL script as an .exe file, or launch it as a C# project.

SQL Packager radically simplifies your deployments by bundling schema and data updates into a single .exe file, ready for roll-out across your customer base.

Powered by: SQL Packager

• Deploy scripts in parallel: run scripts against multiple servers with one click.
• Edit queries before execution: make changes to your SQL straight from the UI, if you need to roll-out slightly different changes across different servers.

SQL Multi Script makes life simpler for developers and DBAs with fast, easy execution of multiple scripts against multiple servers. It's ideal for change management, and you can also use it to fetch data from several servers at once.

Powered by: SQL Multi Script

• Code-completion: SQL Prompt suggests keywords or objects as you type, along with appropriate conditions for completing JOIN, INSERT, and ALTER statements.
• SQL snippets: SQL Prompt comes with a set of SQL snippets to help you code as quickly as possible, and you can add your own favorite fragments to the list.

SQL Prompt suggests appropriate keywords and objects for queries, and can complete INSERT, ALTER and JOIN statements for you. To cut down on repetitive typing, it also has an extensive, customizable set of snippets.

Powered by: SQL Prompt

• Filter within SSMS: get a complete list of invalid objects in your database without leaving SSMS.
• Script as ALTER: generate an ALTER script straight from the find invalid objects window, so you can fix the problem with minimal fuss.

Clean up your database from a central location with SQL Prompt's find invalid objects function. There's no need to break your workflow and you get started on fixing the problem right away.

Powered by: SQL Prompt

• Code reformatting: reformat any query to your preferred layout at the click of a button.
• Script summaries: get a summary of the actions any script performs, together with their order.
• Customizable conventions: set the reformatting style that SQL Prompt uses to match the conventions you prefer.

With code reformatting and script summaries, SQL Prompt makes even the most garbled queries readable. You can set SQL Prompt to use the coding conventions you prefer, so it's simple to keep developers working to the same standards.

Powered by: SQL Prompt

• Future-proof your databases: test your databases with large quantities of realistic data, to make certain that they'll stand the test of time.
• Comply with privacy legislation: generate plausible data for database demos, so you can show customers how your applications perform without sharing sensitive information.

SQL Data Generator looks at table and column names, fields, data types, and other constraints, to provide sensible data generators for your databases. You can also customize the data generators to meet specific requirements.

Powered by: SQL Data Generator

• Dynamic exploration: drill down into areas of complexity, choose from multiple layouts for easier tracking, and filter objects to make the diagram simpler to use.
• Work from SSMS: right-click on a database in the Object Explorer to analyze its structure as you're working.

SQL Dependency Tracker provides an immediate insight into the structure of the databases you work with, without the need for expert knowledge of how it was originally put together. You can generate diagrams as you work, and explore them in as much depth as you need.

Powered by: SQL Dependency Tracker

• Find every example: SQL Search pulls out each instance of a particular reference or line of code from your database, so you can be confident you've made every change you need.
• Jump straight to their location: move directly from SQL Search's results window to the relevant location in the Object Explorer.

SQL Search takes the hassle out of finding code in large databases. You can run it within SSMS, locate every example of a piece of code you need to deal with, or every reference to an object you're working on, move straight to their location in the Object Explorer, and get on with your work.

Powered by: SQL Search

• Pull out database differences: SQL Compare finds every difference in database structure and highlights the precise sections of code that are at odds, helping you to isolate any errors.
• Bring databases in line fast: once you've found the errors you want to correct, it takes only a few clicks to generate a SQL script to fix them, or to run the changes from the UI.

To help you locate errors, SQL Compare rapidly detects differences in database structure. It provides a side-by-side comparison of creation scripts for your database objects, highlights the differences, and can automatically sync problematic differences.

Powered by: SQL Compare

• Work at the row level: sync data at whatever level you need – table, column, or row.
• Quickly generate fix scripts: create scripts to bring your data back in line.

SQL Data Compare offers fine-grained data syncing for SQL Server databases, making it ideal for rapid, precise repairs to your databases. It highlights the differences it finds in your data, so you can also use it for error detection.

Powered by: SQL Data Compare

• Error highlighting: SQL Prompt's find invalid objects function lists the reason an object is invalid alongside the object's name and type.
• Simple fix verification: to double-check that your fix has worked, just refresh the find invalid objects list.

SQL Prompt scours your databases for any invalid objects, so you can have complete confidence that they function as intended. The find invalid objects list specifies the errors that SQL Prompt finds, and provides a convenient means to check your corrections have worked.

Powered by: SQL Prompt

• Simple, safe versioning: check comments for each change and the precise details of the SQL script involved before accepting an update.
• Risk-free experimenting: try out changes on your local version, and if they have unforeseen or unwanted consequences, reversion involves a few clicks, rather than major redeployment.

SQL Source Control makes it easy to share changes with your development team, simple to understand the updates you're accepting, and hassle-free to undo changes you don't want to commit.

Powered by: SQL Source Control

• Thorough coverage: find SQL fragments in stored procedures, functions, views, and more.
• Precision searches: specify the servers, databases, and types of objects you want to search.

SQL Search plugs straight into SSMS, allowing you to track down the objects you need to work on without interrupting your workflow.

Powered by: SQL Search

• Check change history from SSMS: inspect the date and author of each change, alongside their comments on the update.
• View detailed differences in your code: examine the differences through a code view that highlights each change in each revision.

SQL Source Control keeps a complete record of every change to your database, as it's made. Change history is easily accessible from SSMS, so you can keep track of how your databases have evolved for reporting, standards compliance, or auditing checks.

Powered by: SQL Source Control

• Export dependency information: print your diagrams, or export dependency information as an image, PDF, or XML file.
• Track database evolution: keep an easily understandable record of each phase of your database's life-cycle, for archiving, reporting, or auditing.

Because SQL Dependency Tracker provides a detailed but high-level view of database structure, it's perfect for keeping an easily-understood overview of how your databases have changed with time.

Powered by: SQL Dependency Tracker

• Instant documentation: generate database documentation, including object definitions and details about dependencies, with a few clicks.
• Multiple formats: work with HTML, compiled HTML, or Word file formats.

SQL Doc creates complete database documentation straight out of the box, including SQL scripts for every object and details about their properties, users, and more. You can also add custom descriptions of your own. It's ideal for keeping teams informed about the databases they're working on and for meeting audit requirements.

Powered by: SQL Doc