Metadata Caching and Refresh When Closing dbforge Application
Is there any ability / options to cache and restore database metadata when an instance of the dbforge application is closed and re-opened? Our primary Oracle database has thousands of objects across dozens of schemas, and it takes a long time for the
mysql restore of 20gb script
We're trying to restore a backup of 20GB. The restore dialog in DBForge says nothing about whether the restore is run in a transaction or not. Question is does it run in a single transaction and if so can we control this?
Working with PowerShell/CLI
hi, Trying to automate the schema compare function. I used the wizard to generate the CLI Script. It's comparing script folder to an Azure Sql DB. The script generated is the following: &"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge
Issue with Schema Comparison and Synonyms
I'm schema-comparing two databases (i'm using Schema comparison from within SQL Server Studio). Database A and B exist in two different servers/instances (let's say S1 and S2). Database A has a synonym to Database C (in the same server - S1) but Database
How to hide the column type in the suggestion list in SQL Complete?
How to hide the column type in the suggestion list in SQL Complete?
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
How to TUniconnection convert to adodb._connection (VBA)?
How to TUniconnection convert to adodb._connection (VBA)? Unidac for Delphi12 (ver: 9.4)
Where can I view Java Classes in dbforge Studio for Oracle Database Explorer?
I can easily expand and select Java classes to view the source code in Oracle SQL Developer. But, how to do it in dbforge Studio for Oracle?
SSMS 20.0 Support
I was trying to use SSMS 20.0 (3/19/2024), along with dbForge SQL Complete, but I can't get it to work. Can you please add support to get this to work? My workaround is to use SSMS 19.3. Thanks, Jacob
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
Support for Azure MFA (Azure EntraID) log in in connection manager
Hello, It looks like currently the only way to create a login using MFA in the connection managers is to create an application account in Azure AD (now EntraID) and use the ApplicationID in the connection manager. There does not appear to be an ability
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,
Error connecting from Schema Compare 1.4.839 to PostgreSQL 14 using Pritunl
I'm trying to connect to PostgreSQL 14 from Schema Compare 1.4.839 using Pritunl (VPN client). So I have many network adapters / IP addresses on my laptop. When I'm trying to connect to PostgreSQL server with Pritunl is on, I get an error: no pg_hba.conf
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
dbForge SQL Monitor documentation
Hi, in the support page I can Read <<For a complete description of the tab, refer to the Top Queries, Monitor Window topic>> So where are these complete descriptions of functionality? Thanks a lot
How to properly sync sequence values from production to development?
I synchronize the Oracle Database 12c R2 from production to development weekly. However, I am encountering a problem where the current sequence values from production cannot be synchronized to the development instance. Is there an option in the wizard
Evaluating SQL Source Control - Linked server on Get Latest
Hello! I am trying to run a get latest command in the Source Control module - there's 1 stored procedure it's trying to update my local DB with that has a linked server. The linked server does not allow distributed transactions and I saw that the tool
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
Can't install SQL Search version 2.7.25 for SSMS version 20.0
Hi, This is the error that I get. With SSM 19.X, it's working.
How to delete a Db in dbForge Studio for Postgres
How can I delete a database in dbForge Studio for Postgres (without running a command) I don't see such an option when I right click database
dbForge Studio: Is it possible to work with diagrams (*.DBD) without being connected to a database?
Hi, I am trying out dbForge Studio and would like to use its DB Design features without necessarily being connected to an instance of SQL Server. Is this possible? Thanks and regards, Mario
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
Support .gitignore in dbForge Source Control (Feature Request)
Please follow .gitignore for SQL Objects. For instance, we have a convention to deprecate objects by prefixing them with "zzz_old_YYYYmmdd" and then waiting a few months before finally deleting them. Source Control doesn't follow the .gitignore file so
SQL Complete - Management Studio 20?
I just migrated to a new machine, and by default installed the current release of SQL Server Management Studio, which is version 20.0. When I installed SQL Complete, it doesn't add itself to SSMS; is this because version 20 is not yet supported? If this
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?
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`,
Color schema for matching brackets like in Azure Data Studio
Is there an option (or is it at least planned) in dbForge Studio for SQL Server to use different colors for matching brackets like in Azure Data Studio?
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
Debugger failed with timeout
hi. I have problem with "step into" while debug code : "Debugger failed with timeout" What's wrong ? Thank you.
code completion for procedure parameters
Hi. code completion for procedure parameters don't work ( dbForge Studio 2024 for Oracle v. 4.6.15 refresh suggestions, ctrl+space does not help also sometimes in some sessions code completions stops working completely ( Thank you.
what grants required for "Navigate to definition" ?
Hi, i have had error while trying to "Navigate to definition" what grants required for "Navigate to definition" ? and are they necessary ? Another IDE successfully perform operation like this under the same user . You should understand that not all users
Strange behavior when opening and saving documents to OneDrive
I have dbForge Studio 2022 for Oracle PE v4.4.64. At my work, I save all my work in OneDrive. For years I have become used to a behavior where, a few seconds after saving a file, I am prompted like this: I assume some file properties were in motion while
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
Code debuging
Hi, where is debug menu items ? Thank you.
Find and replace dialog - look in All open documents
Hi, Find and replace dialog often suppose look in All open documents As for me it's very special case and most user will prefer Current Document by default.
current_schema ?
Hi, how to set current_schema ? Yes, i can make it using ALTER SESSION SET CURRENT_SCHEMA = but 1. It's not convenient 2. In database explorer tree view staying old schema I think this feature should be integrated in interface.
Next Page