IBDAC Firebird Prepare
Hello, i am confusing using Prepare when setting parameters, should i set the values before prepare or after : SQLQuery.Prepare; <-------------------HERE SQLQuery.ParamByName('Param').AsString := 'YourValue'; SQLQuery.Prepare; <------------------- OR
How do I show the Functions/Procedures within a Package
I'll be respectful since I'm a user that has used Oracle Toad for probably 20+ years. The list below are features available within Toad and I don't see how to accomplish these tasks within dbForge Studio for Oracle. How do you display the Functions/Procedures
ERROR: FUNCTION 'SESSIONPROPERTY' is not supported.
Hi, Anyone had this error when trying to conect do a Microsoft Fabric instance? The endpoints works fina on Azure Data Studio and SSMS but i get this error on DBFORGE Studio for SQL Server
getting error connection error 08006 or Error: No such host is known
Hi, We got an error on and off as "connection error 08006" or "Error: No such host is known" when we try to run some report . But if we re-run the same report again, then no error will be shown. Do you have an idea what causing the issue? below is a sample
Feature Request - Object Bookmarks
It would be very useful to be able to bookmark objects in the Database Explorer. It can get tedious moving between different objects in different tables in different servers... It would be useful to be able to right-click and bookmark an object (table,
Test
test test
innodb retry on ERROR 1213 (40001): Deadlock found
Hi, I recently had to switch some tables from MyIsam to InnoDB, and now I am getting errors when doing inserts from different threads: ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction I am currently changing my code
Data sync is too slow
I'm syncing data between a dev and production mysql db using dbForge's data compare tool, which is great, except the table has 1.7m records and it's sync'ing one record at a time. This thing will take weeks to finish. Is there a faster way to do this?
Will dbForge for Postgresql filter out comments when submitting queries?
Will dbForge for Postgresql filter out comments when submitting queries? If filtering is applied, it is recommended not to do so, as certain features of Alibaba Cloud Polardb may become completely ineffective. pg_hint_plan - PolarDB - Alibaba Cloud Documentation
Virus scanner alarm - Trojan found
Hello, this morning I received an update message for the installed test version of SQLTools. After downloading the sqltoolsent.exe file from the download area at devart, I started the installation. Unfortunately, I received the following messages from
Add related table lookup functionality to read-only mode
When the results of a query are in edit mode, clicking on a field which is a foreign key reveals a dropdown list of possible values from the primary key table. It's be nice if this feature could be extended to read-only mode so the related data can be
Oracle - EFCore - Hints
Hi, I am trying to use OracleFunctions.Hints("ALL_ROWS") in a project that is using Devart.Data.Oracle.Entity.EFCore. What is the recommended way to add Oracle optimizer hints in EFcore ?
How to search within stored procs with dbForge for MySql
I would like to be able to search for text and have it look at stored procs and column names, stuff like that. Basically I want something like Redgate's SQLSearch tool for SSMS. Is that in dbForge Studio already or can I request something like that be
How can I get SQLComplete to format Table Check constraints?
I'm using SQLComplete version 2025.1.134 and have the following table definition: CREATE TABLE MyTable ( [Column1] INT NULL ,[Column2] INT NULL ,CONSTRAINT [CK_MyTable] CHECK ( ( (__Universe2HybridBenchmarkId IS NOT NULL AND __Universe2AccountBenchmarkId
UUID V4 and V7 are now available, Is it in DBForge ? If not, can it please be added
HI ! I see that UUID_V4 and UUID_V7 are now implemented in MariaDB v 11.7 (11.8.2 is the current release) https://mariadb.org/always-use-the-right-uuid/ Does DBForge have the ability to set the UUID as V4 or V7 in the table builder ? If not, can we get
Feature Suggestions : DBForge MySQL - Table Template
HI ! I have an idea for a feature enhancement. (currently using 2025.1.124) We design many of our database tables with several of the identical fields. id int(11) NOT NULL AUTO_INCREMENT, DateUpdated datetime NOT NULL, IDUpdated int(11) NOT NULL, VisitorID
Feature Suggestions : DBForge MySQL - Table Designer SQL Direct Edit/Paste
As In my other post about how we design many tables with the same basic fields of data, It would be very nice to be able to open up a new table, create the fields we want, and then paste in directly in the SQL section a template of multiple fields. For
SQL Complete Support for Synapse/Serverless
We are moving our SQL Servers to Synapse/Fabric, and are using the Serverless options. However SQL Complete does not work with these. Are there any plans on making it compatible?
How to compile a db object loaded from a file?
I can't find any documentation on how to use DB Forge Studio for Oracle to load a package spec and body from a file on my PC and then compile it. It only seems possible to create them from scratch or to edit existing objects. My team keeps all of our
[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:
create new database,user
Hello, i download dBforge studio for postgres and try to create database, table or user but there is no option for that as Mysql tool. so i missed something or it is limitation in this product? if it is limitation, are you going to develop it so that
Stop tab rows from shifting in dbForge Studio
I have "Show tabs in multiple rows" on. Is there a way to stop the tab row of a clicked tab from always being moved to the bottom row? It's not helpful having tab positions always being moved around and no other IDE I use does this.
Feature Suggestions : Schema Filter
Feature Suggestions : add a "Schema Filter" function like "Table Filter"
Default Font of Excel Exports from dbForge Studio
Is it possible to change the default font of dbForge Studio's Excel exports? Using a template seems to capture and load extra info.
Why Does dbForge Studio Say a Query has 302 Records Retrieved?
Paginal mode is off. A query can return thousands or hundreds of thousands of rows but the grid always reports 302 until you start scrolling through the data.
Transaction Log multi-select for Undo script
Is it possible in Transaction Log 7.1.45 to multi select rows to generate a custom Undo script? When I Ctrl-click to highlight multiple rows in blue, the Undo script tab window updates to only Undo the last selected row. The Export Undo Script option
What happend to dbForge Studio for SQL Server?
Hi there I have now updated to the latest version of dbForge Studio for SQL Server. And in hindsight, that was a big mistake. - The time it takes for the program to start has increased by a factor of ten - Intellisense no longer works automatically -
Issue with formating SQL and WITH statement
I'm having issue with formating WITH subquery. Here a simple exemple I have create: WITH client AS (SELECT r.id_region, r.num_region, r.pays FROM region r INNER JOIN pays p ON r.id_region = p.id_region) SELECT cl.id_client ,cl.client_nom ,cl.client_adresse
Feature Suggestions for dbForge Studio for PostgreSQL
1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply
Feature Suggestions for dbForge Studio for PostgreSQL
Here are a few suggestions: 1. Add multi-language support. 2. Add a "Generate CREATE Script" option when right-clicking on a schema (similar to public) or a database, which can generate the CREATE script for the entire schema (similar to public) or the
dbForge Studio for SQL Server Features Question and Feature Request
I was looking at dbForge Data Compare tool and came across the Compare Bundle and dbForge Studio. My question is, am I losing any features from the standalone SQL Complete (currently use Standard), Schema Compare (currently use a competing product but
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
SSMS Results Grid > copy as Excel format
The "Copy Data As" results grid options have been very useful for years, but one extra thing would still be super nice to have: "Copy As Excel". I'm sure everyone has seen issues with data types when copying directly from SSMS into Excel, often changing
how to specify the version of sql server used when generating synchronization script
My Sql Server install is 2019. When I generate a synchronization script, I need to specify that the script generated works with Sql Server 2014 (other sql installs on different computers). I am currently using dbForge Schema Compare for Sql Server Professional
How to place an image in the background of a report and have the data visible on the image?
Hello, I'm trying out dbForge Studio for SQL Server and want to place a background image on the entire report page. I'm using the image object to insert the image I need, but when I place it in the background and add fields over the image, they don't
SQL Complete Execution History Import
Is there a way to move over query execution history from one computer to another?
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
Schema Compare for Postgresql: Triggers comparison
Hello Where can I find an exhaustive list of what schema objects are currently supported and not supported when doing a schema comparison using dbForge for PostgreSQL? I was under the impression triggers are supported by this does not seem to be the
Next Page