Devart Forums

.jp

Hello,

Thanks for the post!

So far, dbForge Studio for MySQL v7.2 supports the MariaDB server up to the 10.0 version.
Please have a look at the following link https://www.devart.com/dbforge/mysql/st ... ments.html.
We're going to support MariaDB v10.1 and v10.2 in the next version of the product.

Best Regards.

.jp

Hello,

Sorry for the delay.
Thanks for the information, but you provide a log from the Output window. Could you please provide a result from the data editor window. Please have a look at the following screenshot:

Also try to execute the following query:

Code: Select all

USE wordscrubbertest;
FLUSH TABLES aoswords;

then try to execute:

Code: Select all

USE wordscrubbertest;
UPDATE aoswords ...

Best Regards.

.jp

Hello,

The development of the new version is in the final stage. So, the release of the product is going to be available in a month or two, we hope.

Best Regards.

.jp

Hello,

Thanks for the post!

So far, dbForge Studio for MySQL v7.2 supports the MariaDB server up to the 10.0 version.
Please have a look at the following link https://www.devart.com/dbforge/mysql/st ... ments.html.
We're going to support MariaDB v10.1 and v10.2 in the next version of the product.

Best Regards.

.jp

Hello,

Thanks for the post.

1) Please write USE you_database before UPDATE like the following:

Code: Select all

USE wordscrubbertest;

UPDATE aoswords ...

2) Try to run the following script to invoke information about the table:

Code: Select all

USE wordscrubbertest;
SHOW CREATE TABLE aoswords;

3) Could you provide server version by executing the following statement:

Code: Select all

select @@version;

Best Regards.

.jp

Hello,

Thanks for the post!

You're quite right that the feature "Generate Scripts Folder" is available in Enterprise edition only.
By the way, we plan to improve the Generate Scripts wizard to generate a single file per object. It'll be implemented in one of the next versions of dbForge Studio for SQL Server Professional Edition.

Best Regards.

.jp

Hello,

Thanks for the posts.

We need a bit more information:
1) could you send some examples of the queries you are working with
2) did you run-up any queries for a execution before computer lock or before switching to another application

Best Regards.

.jp

Hello,

Thanks for the post!

Unfortunately, such feature isn't implemented yet.
It's on the voting https://devart.uservoice.com/forums/177 ... r-diagrams .

You should re-create database diagram by drag-n-dropping objects from the Database Explorer.

Best Regards.

.jp

Hello,

Thanks for the reply!

Just let you know that the trial version of dbForge Studio for Oracle Standard in not available for download. But if you are a Devart customer you can download a registered version of dbForge Studio for Oracle Standard from your cabinet.
To do it you should login at https://secure.devart.com with your login&password, then click on the version number link next to the dbForge Studio for Oracle Standard label, after that you are able to download the dbForge Studio for Oracle Standard, 32-bit installation file. If you lost your login&password, please contact Devart Sales Department.

Kind Regards.

.jp

Hello,

You should download and install dbForge Studio for Oracle, 32-bit. This application is designed to work with 32-bit versions of Oracle client under the 64-bit and 32-bit versions of Windows.

Best Regards.

.jp

Hello,

Could you please send text of error for us.
Please perform the following:
1. Open project.
2. Choose project in Project Explorer.
3. Select popup menu Build <Project Name>.
4. Select in main menu View\Output.
5. Send an error. For example:

------ Build started: Project: NewProjectName, Configuration: Default ------
...
------- Build failed: Project: NewProjectName, - 12 errors -------

Also would you please tell us what version of MariaDB you are using.

Best Regards.

.jp

Hello,

Thank you for the questions!

You may use the following script to implement the required logic (You need to replace bit_column_name to a required one.):

Code: Select all

import random

def getStreets(): 

  fileName = config["config_path"] +'\\'+  r"UKStreets.txt"  
  with open(fileName) as f:
    content = f.readlines()
    for row in content:
      yield row

streets = list(getStreets())

def main(config):
  if bit_column_name:
    return streets[random.randint(1, len(streets)-1)]
  else:
    return 'some else'

In case the Python script contains other columns, the dependency mechanism will take it into account and generate data in the correct order. So you can use other columns in the Python script, that appears before or after. So you can use other columns in the Python script, that appears before or after.

You can find some examples of Python generators in the following folder:

C:\Users\Public\Documents\Devart\dbForge Data Generator for SQL Server\Data Generators\
AGE.xml
Death Date.xml
Integrated Circuit Card ID (ICCID).xml
Python.DUNS.xml
Python.Gravatar.xml
Python.Language Code (ISO 639-1 alpha-2, UpperCase).xml
Python.Language Code (ISO 639-1 alpha-3, UpperCase).xml
Python.LoremPixel.xml
Python.MD5.xml

Also we described some cases of how to use Python generators in our blog:

http://blog.devart.com/how-to-generate- ... rator.html
http://blog.devart.com/getting-real-cur ... erver.html
http://blog.devart.com/generating-rrela ... erver.html

Feel free to post or email us if you have other questions, we'd like to help.

Best Regards,

.jp

Hi!
Thanks for the reply.

If we understand you correctly, you need the data masking functionality. What a use case is applicable in your situation:

1. There is a copy of the production database. You run a tool that masks data in specified columns, with a specified algorithm in the same database.

--or--

2. There is an empty test database without data. You need to populate the test database with help of the data generator. While populating the test database, you need to grab data from the production database, obfuscate it, and pull to the test database.

dbForge Data Generator will not help you in the first case yet, but it helps you to implement the second scenario. To do it you need to use the python generator (that is built-in into dbForge Data Generator). You can use this python generator to create a custom script that will obfuscate data. Alternatively, you can use the SQL Query generator (that is built-in into dbForge Data Generator). You can use REPLACE SQL Server function (or other) to substitute symbols in required rows.

Could you please tell us what data-masking algorithm is suitable for you?

.jp

Hello,

Thank for the post.

1) Data Generator adds new data to the existing one. It is possible to truncate the table and generate a completely new data set. Please specify what did you mean by data refresh?

2) What condition do you use to generate data for the linked table? You can set the following values manually:
date_1 = from 1971 to 1973
date_2 = from 1982 to 1985
for date_3, you can specify a period (in the date generator) between date_1 and date_2 -- date_3 = from 1973 to 1982

3) You need to use the FK generator for this purpose. You can specify a linked table and a column there. Alternatively, you can use the Table or View generator. In the future, we are going to add the option that allows you to specify a data source - either parent table values or random values.

4) To combine several generators, you need the following:
- Select the RegExp generator
- Click the Generator button and add 2 or more generators to the RegExp editor window.

5) Here is the code for the Python generator (for 3rd column):

Code: Select all

import random
def main(config):
 
 # Check whether any field is null then return false.
 if column1 == DBNull.Value or column2 == DBNull.Value:
   return 0
 
 return not(eval(str(column1)) and eval(str(column2)))

Best Regards.

.jp

Hi!
You could also install and use a trial version of the tool with English UI. The trial version is free for 30 days.
Best Regards.

Devart Forums

Search found 346 matches

Re: Point to different my.cnf

Re: Unknown table error on Update or Delete

Re: Script Issues

Re: Script Issues

Re: Unknown table error on Update or Delete

Re: Generate Scripts...1 file per database object

Re: dbforge Studio for Sql Server becomes unresponsive

Re: Import Database Diagrams from SQL Server Management Studio

Re: Connect with Oracle 32 bits in a 64 bits machine

Re: Connect with Oracle 32 bits in a 64 bits machine

Re: Schema comparison

Re: Some questions on Data Generator

Re: Some questions on Data Generator

Re: Some questions on Data Generator

Re: How to change dbForge Studio UI language?