dbForge Team Blog

When working with databases it is always necessary to import data or schemas. In this article we describe the process of importing data from a text file into a MySQL database, and also we discuss questions concerning problems with MySQL import and the ways of solving these problems. We will give a detailed description of the Data Import tool of dbForge Studio for MySQL, describe the capabilities of this tool and illustrate its usage.

(more…)

Not a long time ago we started to write auto-tests for testing our new product –
dbForge Data Compare for Oracle. To recreate a schema in Oracle all user sessions should be killed.

To achieve this we’ve written the following PL/SQL script:

(more…)

MySQL is frequently referred to as a database for Web applications. Partially it is really so, because MySQL became popular owing to its simplicity, high speed, and bounding with PHP. Developers of small Web projects often choose MySQL as a back end of their sites. Does this mean that MySQL can be used only for small databases? Not at all. There are lots of databases size of data in which is measured in gigabytes. Besides MySQL servers are frequently clustered to increase their performance. When a DBAs work with large amounts of data, they frequently have to make backup copies correctly and effectively, i. e. to export MySQL databases to SQL (or MySQL backup). It is extremely important to import MySQL database from SQL correctly is when restoring a corrupted database and when migrating a database from one server to another.

(more…)

This article gives a step-by-step instruction for visual database creation.
There is a lot of instruments that allow database developers avoid monotonous and error prone manual writing of scripts for tables creation. But to have a complete picture while creating a database it’s necessary not only to speed up the process of database objects creation, but also to visualize relations between them. dbForge Studio for MySQL offers a perfect tool for such purpose – Database Designer.

(more…)

Recently our development efforts were focused on dbForge for SQL Server product line. We’ve made five major releases of SQL Server database tools in last 18 months. Besides, we’ve made two major releases of MySQL database tools in this period. Our Oracle database tools product line, once actively developed, was frozen for almost three years. Sure we made maintenance releases, but no new features and tools. Our Oracle tools even were not re-branded to dbForge for Oracle. But now we decided to breeze the new life into Oracle tools development.

The first tool in the dbForge for Oracle product line will be Data Compare. For the first release we decided to make a free tool with basic functionality:

(more…)

Database development is not limited to an initial copy of a database. On your road you meet multiple enhancements, refactoring, upgrade and many other cases that require changes in a database structure. One of most common cases is to upload database objects from one schema to several schemas. Here the simplicity ends and you are stuck with the questing ‘How to do this?’

Upload manually or automatically?

(more…)