Streamlining SQL Server Tasks With dbForge Studio
This course will take you on a journey across a variety of topics related to the basics of SQL Server development, management, and administration. You will see how to handle them most effortlessly using dbForge Studio for SQL Server, a high-end database IDE, perfectly suitable for power users and beginners alike.
-
4 modules
-
22 lessons
-
1 hour, 26 mins
Overview of dbForge Studio for SQL Server
Here's your in-depth glimpse into the core features of dbForge Studio for SQL Server—from advanced SQL coding assistance, debugging, and query optimization to data analysis, source control, and comprehensive database management.
Installing the Studio on Linux Via CrossOver
You can install and run dbForge Studio on Ubuntu, Debian, Fedora, and Red Hat Enterprise Linux. To get it ready on these systems, you will need CrossOver, a versatile compatibility solution by CodeWeavers. See how it works in our guide.
Installing the Studio on macOS Via CrossOver
If you are a Mac user, you can start working with dbForge Studio for SQL Server just as effortlessly. The same CrossOver by CodeWeavers will help you easily install and run the Studio in a familiar macOS environment without any trouble.
The Start Page of dbForge Studio
Get acquainted with the Start Page, the first thing you see upon opening the Studio. It consists of tabs that provide quick access to the Studio's key features: SQL Editor, Source Control, Schema & Data Compare, Data Pump, and much more.
Connecting to a SQL Server Database
To start working with SQL Server databases, the first thing you need to do is establish a connection to the required server. Learn how you can do it in dbForge Studio using a convenient dialog with a rich selection of settings.
Setting Connection Categories
It's not an uncommon case when you need to work with multiple connections and tabs simultaneously—and you need to instantly identify the connection that each tab belongs to. Learn how to make it easier for you with connection categories.
Connecting to SQL Server on Amazon RDS
You can create a SQL Server database instance on Amazon Relational Database Service (RDS) and easily connect to it with dbForge Studio for SQL Server. It will take you less than two minutes to learn how it's done.
How to Convert Columns to Rows
UNPIVOT is a relational operator that can become your optimal solution for transposing columns into rows in SQL Server. Watch the video to see it in action alongside other features of the Studio's integrated Query Profiler.
How to Create a Many-to-Many Relationship
A many-to-many relationship exists when multiple records in one table are linked to different records in another table. Here is a concise and informative guide that will help you handle these relationships with dbForge Studio for SQL Server.
How to Migrate a SQL Server Database
Watch this video to discover the simplest way of migrating SQL Server databases between different environments. Learn how to use scripts folders along with database comparison and synchronization for an effective migration process.
How to Migrate a Database Using a Snapshot
Get acquainted with an easy and straightforward method of migrating a SQL Server database to another environment by generating a database snapshot and restoring the database using the Studio's Schema Compare functionality.
How to Copy SQL Server Schemas and Data
Learn how to copy a database schema along with the stored data by generating a dump file with the Studio's Generate Scripts Wizard. To restore both the schema and data, you only need to run the said file against the target empty database.
How to Migrate a Database Between Servers
Another convenient way of migrating a SQL Server database to a different server is to use the Copy Database functionality of dbForge Studio. It's very easy to use and offers a handful of flexible settings—watch the video to see it in action.
How to Migrate Data Between Databases
Need to migrate data from one SQL Server database to another? Here are three easy steps to do it in dbForge Studio. One, create an empty target database. Two, deploy the source schema to the said target database. Three, sync your data.
How to Detach and Attach a Database
dbForge Studio provides you with handy tools that will help you detach and attach your SQL Server databases when migrating them from one server instance to another. Check this video guide to learn how to do it.
How to Backup and Restore a Database
The importance of keeping your data safe with regular backups is indisputable. dbForge Studio will help you back up and restore SQL Server databases without coding—and conveniently automate this process from the command line.
How to Restore a Session in dbForge Studio
You can configure dbForge Studio to auto-restore unsaved tabs and database files. This is how you will make sure that your work will not be lost in case the application crashes or you accidentally close the tab without saving.
How to Generate Database Documentation
Learn how to generate comprehensive documentation for SQL Server databases, comprising a structure overview with inter-object and inter-database dependencies. The Studio's integrated Documenter will help you with that.
How to Export & Import SQL Server Data
Get acquainted with the most flexible way of exporting and importing SQL Server data with 14 most popular formats at hand, including HTML, TXT, XLS, XLSX, MDB, RTF, PDF, JSON, XML, CSV, ODBC, DBF, SQL, and Google Sheets.
How to Create a SQL Server Data Report
Learn how to design customizable query-based data reports within minutes using the smart Data Report Wizard of dbForge Studio. As a bonus, see how you can schedule regular delivery of your reports from the command line.
SSMS vs dbForge Studio for SQL Server
SSMS is the stock IDE for SQL Server, familiar pretty much to everyone. Over time, though, your demands can outgrow its capabilities, and you'll need more firepower at hand. Here's how you can level up your performance by switching to dbForge Studio.
DBeaver vs dbForge Studio for SQL Server
DBeaver Ultimate is one of the most popular database clients. But what if you happen to need more features in your toolset? Check this detailed comparison to see how much more firepower you can get with dbForge Studio at hand.
