data generator

How We Made More Realistic Tests with dbForge Data Generator for MySQL

We have been developing our own SaaS CMS platform floowedit since 2007. During all the development and improvement phases we have always faced a problem: having realistic and quantitative test data at hand. In fact, like everyone else, we use dummy data generators and often work with so-called ‘lorem ipsum’.

(more…)

Generating subscription statistics data in Oracle Data Generator

When you need to fill your databases with data for testing purposes, it’s usually quite handy to also have this data follow dynamic patterns like in real life. In such situations, records should both look realistic on their own and form a life-like overall picture. For example, if you want to fill your table with test data for an online service with a subscription model, the records would have to be dynamic from day to day. (more…)

How To Generate and Fill a Doubly Linked List Table

Introduction

In this article, we’ll learn how to fill a doubly linked list table with SQL test data. In such tables, there can be various independent chains unified by unique tags into groups. (more…)

Devart keeps upgrading its SQL Server IDE to be innovative

Devart is always trying to keep in touch with the times and provide its users with more and more opportunities for successful and effective databases management. That is why we have released a new version of dbForge Studio for SQL Server v.5.6 with the changes aimed at supporting the latest technologies in the world of database development. (more…)

Create Unique Generators with dbForge Data Generator 2.0!

We are glad to notify our users that a new version of the Devart Oracle data generation tool has been released – dbForge Data Generator for Oracle, v2.0. The new version allows creating and saving your personal data generators, generating data to tables already filled with data, run data generation in a single click and much more! (more…)

Extended Connectivity in dbForge Tools for MySQL

We are excited to inform our users that we have released new versions of dbForge Schema Compare for MySQL, dbForge Data Compare for MySQL, dbForge Query Builder for MySQL, dbForge Data Generator for MySQL, and dbForge Documenter for MySQL. (more…)

Reinvented dbForge Tools for MySQL Have Arrived!

After a grand update of dbForge Studio for MySQL, we haven’t forgotten about the rest of the dbForge for MySQL product range. Our developers took maximum care of each and every MySQL tool and revamped them with specific new features and updates. (more…)

Getting Real Currency Exchange Rates with SQL Server Data Generator

This article will demonstrate how to get live currency exchange rates with the help of Python and dbForge Data Generator for SQL Server.

Currency exchange rate is the reference information used in the translation of monetary values from one currency to another. The exchange rate expresses the value of one currency in terms of another. (more…)

Generating Related Data Elements with SQL Data Generator

Recently we got an interesting question from our user:

The docs don’t address directly, but how can we generate three related data elements, like dateof birth, age, and date of death for instance, in one script efficiently as it generates test rows/records and then populate the fields in a test database table? If docs do address this, please point me to where, if you would… Thanks!

(more…)

How to generate SQL Linked List Data with Python Generator

In this post, we would like to show how to quickly generate table values that are based on the values of another column of same table. For this purpose, we will use the Python Generator being a part of dbForge Data Generator for SQL Server. (more…)