[FEATURE REQUEST] Add Chat-GPT to the Editor !
hey devart team, if you make this possible, i guess all people will say only one thing to you:
SSL connection problem in dbForge Studio for MySQL
Hello. I have a problem with SSL connection in dbForge Studio for MySQL on one of my machines. An account in the database has 'REQUIRE X509' option, so it's required to specify a client key, certificate and optionally CA to connect. I have specified all
schema comparison "Ignore white spaces" option issue
After completing schema comparison with the "Ignore white spaces" (in script objects) being checked on then next comparison (either invoked manually or re-run automatically) is conducted with the "Ignore white spaces" being checked off. Why does it work
Card View issue 10.0.46
Maybe I overlooked something but it looks like card view is working improperly in 10.0.46. It was OK in the older versions. 1. The width of the box is too narrow so many of the values are cut off. 2. I can't find any way to easily change its width. The
Connect to MySQL with SSL and validate server certificate
Hello I'm working with an Amazon RDS MySQL instance, and i'm sucessfully connecting to my db even when i'm providing a wrong certificate in MySqlConnection.SslOptions.CACert I only have CA certificate, no client certificate. How should I force the verification
Table names always renamed as lowercase versus PascalCase
Is there a way to turn off this automatic table renaming to lowercase? When creating or modifying tables in dbForget Studio for MySQL v10.1.165, it always renames my tables as lowercase or camelCase. Our coding standards are PascalCase, which is causing
Invalid command line. Unknown switch 'connection:user'.
I've been using dbforgemysql in Windows for manual backups and decided to automate it after a recent server crash at our ISP. I've followed the directions, but no matter what I do I receive an error. Invalid command line. Unknown switch 'connection:user'.
How to quickly find DB Connections
Does anyone have any solutions for how to quickly find DB connections in Database Explorer when you work for a large company and have thousands of connections for all different servers? There isn't even a search bar and it would take forever to manually
Solution made with Mysql for Visual studio 12.0.1
Hello, I am trialing Devart dotConector with Visual Studio 2019. I have a full vb.net solution, which has datasets (XSD) created by MySQL for Visual Studio. I was hoping to just migrate these across to use the Devart.mysql.data namespace (from Mysql.Data.mysqlClient)
How to disable formatting of Stored Procedure/Function code in backup?
In some Functions I format the code myself. However, in the backup copy my formatting is lost, and instead it is replaced by automatic formatting. How do I prevent this? I use dbForge Studio 2020 for MySQL
Set connection parameters via command line
Hello, we would like to use dbForge for MySQL with PAM solution (not Percona) that requires setting connection parameters via command line (username, password, dbname) to launch dbForge for MySQL application on Windows. Is that possible?
Bug: dbForge Studio for MySQL Professional Edition 10.0.225 - Problem with Order By query results in Data window if columns were previously manually sorted
Running a query with Order By in the Text window does not produce correctly sorted results in the Data window if the columns for the table were already manually sorted from inside the Data window. Selecting "clear all sorting" in the Data window of a
Strange error attempting to save a record with a blob jpg...
I have developed a VCL application in Delphi, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. It uses Devart MySQLDAC 12.2.1 For RADStudio 12 for database My customer has just emailed to say they
HasConversion not working with EF Core 8 when converting an Enum
Hi, We're using HasConversion<string> to convert an Enum to string and vice versa but it's throwing an Exception. We've also tried the following syntax : .HasConversion( v => v.ToString(), v => (EUserType)Enum.Parse(typeof(EUserType), v)); But we're getting
reports duplication / encapsulation
If I wanted to create a report for each of 30 different locations based on a query that has a where statement something like WHERE Location = 1 what would be the easiest way to do it? If I save a report file such as location1.rdp and the query as location1.sql
Generate Script no longer exports the whole table: 10.0.46
dear devart, next to the catastrophic changes you made, which are intended, I found another issue which must be a bug in my eyes: when getting "CREATE TABLE" statements you no longer see triggers or anything else. I'm pretty sure - before the update -
Using dbForge to set up CI/CD for MySQL
Hey, everybody! Can you please tell me if there are any possibilities to customize CI/CD with dbForge ? I've a situation where I've a remote database on Amazon RDS and a local database. Before dbForge I had to work with SSDT and there was an option to
dbForge MySql backup error: parsing failed
I have a backup project I've used many times to create a backup of my data. I don't think any versions have changed (of mySql or dbForge). Now, though, I get an error: "Parsing failed on named ." There appear to be blank spaces in the error message, as
MariaDB 10.6.18 with dotConnect MySQL
Hallo, we are using dotConnect and try to connect to a MariaDB 10.6.18 with SSL. We have dotConnect MySQL 8.10, and we get the error-message: SSL connection error (2026): The server hello message uses a protocol that was not recognized. There was no problem
dbForge does not seem to understand HeatWave specific commands
We are migrating from MySql on-premises to Oracle Cloud with Heatwave. When we perform a DB comparison, we get errors on tables that contain fields to be excluded from HeatWave with the NOT SECONDARY keyword assigned to the fields. Also, in stored procedures,
Is is possible add 'OFFSET' or any other word to reserverd keywords in dbForje Studion for MySQL 9.0?
Is is possible add 'OFFSET' or any other word to reserverd keywords in dbForje Studion for MySQL 9.0? OFFSET now keyword in MariaDB and needs to be quoted https://jira.mariadb.org/browse/MDEV-25556
Trouble installing SQL Source control add-ins for SSMS
Hi all, Trying to follow the steps in the installation guide to evaluate this vs redgate, and the first bump is that the download link for source control goes to the DBForge SQL Tools download, and not a standalone installer. Ok, fine. I install the full
How to draw/sync db with ER Diagram?
We are evaluating DBForge Studio for PostgreSQL, and in a prior position while using the DBForge for SQL Server, I saw that it had a ER Diagramming tool. Since PGAdmin is so very basic and lacks much, I was hoping to make up for that deficit with DBForge
Is DbForge for postgres unfinished ?
There is no designer for creating objects like: Tables PK and FK indexes triggers Functions Domains See this post from the year 2021 where it said it was in the plans and it's been 2 years. forums.devart.com/viewtopic.php?f=51&t=47836 I am very interested
Schema compare not syncing
Using the MySQL Schema compare I have a field in a view which does not sync, it sees the difference every time but does not update it. the difference is: CAST(LEFT(`assets`.`AssLocation`, 30) AS char(30) CHARSET utf8) AS `Asst_Locn`, and CAST(LEFT(`assets`.`AssLocation`,
How to configure automatic formatting of function words in a text editor?
Hi, dbForge Studio for MySQL v.10.0.150 There is a problem with the word "SET" . How can i customize text editor to print this word in upper case automatically? The parameter "Automatically format words while typing" is on. I print SET in upper case mannualy,
[10.0.46] run a second query (by hotkey) in the same editor does not work (without hitting the hotkey twice)
hi devart, i do hope this is a bug and not another great example of "industrial standards". if you have a regular edit tab open and have a query there that you can run with the hotkey that runs a query where the cursor is - and you write a 2nd query and
additional quotes when copying from the data editor
v.10.0.60 example SELECT JSON_OBJECT("key1", 'val1', "key2", 'val2') UNION SELECT JSON_OBJECT("key3", 3, "key4", 4); 1. when copying a value from one line everything is ok 2. When you copy several lines, additional quotes are inserted
This server version 8.0.36 is not currently
dbforge version : dbForge Studio for MySQL Enterprise 9.0.338.0 mysql version：8.0.36 connect error：This server version 8.0.36 is not currently
monitoring evolution table
Hello, I have a schema table A which is populated , I want to compare it against another reference schema table B and recover all the data changes, is this possible with Dbforge compare? Thanks. Regards Damien.
dbForge Studio for PostgreSQL
does dbForge Studio for PostgreSQL Data Editor allow you to update bytea columns?
SSIS package task error with HardDelete
I've created a Devart SalesForce Destination task with the HardDelete action. When I attempt to execute, it throws an error of: "...failed with error code 0x80131500 while processing "input"... ." The regular Delete action works just fine. Are there special
**WARNING**: DO NOT INSTALL version 10.0.46 - usability is dead!
hi there, you might have seen the latest update with tons of changes and maybe, like me, you were super happy in the first place to realize, that the team did a great job fixing so many bugs and adding new features. but after using the new version for
EF Core 8 / .Net 8 support
Hello, Do you have any roadmap or release date about supporting EF Core 8 ? Currently it's not possible to run a project with Devart.Data.Mysql (9.1.151.7) and EF Core 8.0. Thank you.
debug is not working
after purchasing license debug is not working in sql 19
Is it possible to add a report to a data syncronization?
I am currently working on a project in which I am using the script of the following article to synchronize two databases: Compare Two Database Schema in SQL Server on a Schedule (devart.com) I was looking for more articles and I found this second article
Is it possible to connect to oceanbase?
I got a error message by test connection "Unknown table 'PLUGINS' in information_schema (code 1109)"
[10.0.60 ENT] unable to export to google sheet if auth failed
hi devart, when i authrorized dbforge for google account A) and later on I need to export data to a sheet that is connected to a different account B), I have no choice. instead of this error, dbforge should ask to "re-authenticate". unable to do that,
Renamed Tables in Schema Comparison
I have several tables in my database with the names changed. Using the Schema comparison, the suggested strategy is to DROP the table and create the new one empty, but this will generate a data loss. How to "explain" to the Schema comparison tool that
You have problems with version v10? Here's your solution!
step 1 step 2: enjoy going away the pain step 3: bring back peace to your daily work FINAL WORDS I'm tired of playing guinea pig and spending my time making stupid bug videos and closing 100,000 tabs every day, I'm just tired of this shit! I'll use version
Next Page