data generator

In this article, we will show how you can take more control over the data in your database by using a custom hash function Python generator in the dbForge Data Generator tool. We will provide an example Python script, which you will be able to later use as a starting point for creating your own scripts.

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’.

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. In real environment, the amount of subscriptions will always change – some people will leave the service while new subscribers come in. Of course, we would like the latter number to outweigh the former.
With the help of Data Generator for Oracle and some basic Python scripts, we can generate test data that will show a dynamic growth pattern.

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 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…)

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…)

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…)

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…)

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

The 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.

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!