Managing Azure SQL Database using dbForge Studio for SQL Server
This article gives an overview of SQL Azure database managing and developing features provided by dbForge Studio for SQL Server.
Introducing SQL Azure Databases
With constant growth of cloud technologies, more and more enterprises and database developers draw their attention to cloud solutions in general, and to SQL Azure in particular.
SQL Azure Database is a cloud platform of a relational database that is based on the SQL Server technologies. With the platform, you can easily develop a project of relational database with its all benefits, provided by the cloud technology. In addition, SQL Azure offers a high security level with the built-in data protection mechanism, selfrecovery and backup.
Being a component of Windows Azure Platform, SQL Azure database maintain all benefits of cloud technologies, which are:
- Availability. The service is provided via the web and is available 24/7.
- Automation and extensibility. Data processing and storage are performed on servers of the remote data centers and are allocated on physical machines, what results in providing the sufficient capacity for every user.
- Low cost. The services are provided on the "pay as you go" basis.
- Simplicity. Users should not take care about infrastructure and maintenance of data processing and storage.
Getting the Most out of SQL Azure Databases
With dbForge Studio for SQL Server, you will have a solid platform for managing any SQL Azure database-related tasks in a single application with convenient user-friendly interface.
Easy SQL Azure Connection
All you need to connect to your SQL Azure Database is to specify connection a string and your user credentials. After establishing a connection, your Azure database will appear in Database Explorer and you can start working with it as with a regular SQL Server database.
With Security Manager, you can organize routine SQL Azure administration tasks easily and securely. The feature allows managing
user accounts and logins, assigning roles to users, granting and revoking user permissions.
Intelligent Code Completion
Code completion turns code typing into a pleasure by suggesting not only keywords, but entire code fragments.
SQL Azure Data Editing
The application provides you with convenient editing, filtering, sorting, copying of randomly selected cells, quick data export to INSERT query and many other features for a better efficiency.
SQL Azure Data Comparison and Sync
You can tune your SQL Azure database comparison quickly analyze differences
in a well-designed user interface and effortlessly synchronize SQL Azure data.
SQL Azure Schema Comparison and Sync
The tool will save your time and effort when you need to compare SQL Azure
databases. Analyze differences and synchronize your schemas using
generated SQL script quickly and without errors.
SQL Azure Data Export and Import
Supporting more than 10 widely used data formats, Export and Import utility
helps to fill an SQL Azure database with external source data and migrate data
SQL Azure Data Reporting
Data Report Builder allows to visually design any kind of SQL Azure data reports, based on data from SQL Azure database,
including charts and pivot tables in a user-friendly interface.
SQL Azure Database Diagram
You can cluster logically-related objects of SQL Azure database using
containers, and export created diagrams to various formats, including EMF.
dbForge Studio for SQL Server is a powerful IDE that provides a definitive collection of database tools, that can help you to considerably boost SQL Azure database development and management within a well-designed clear user interface.
Download trial version of dbForge Studio for SQL Server and now and evaluate the benefits of the Professional edition features for free during a 30-day trial period.