Errors testing backup db with 20+ tables total 10GB
Hi, My first question evaluation dbForge Studio for MySQL, after a few days testing other stuff through the evaluation of ENTERPRISE. The "only" special circumstance is that it is on a MariaDB 10.4 db enginge with tables in innodb. I have verified that
SSMS 19.3 no SQL Complete after installation
Hi. Yesterday I installed SqlComplete 7.0. Everything went smoothly until I saw there is no SQLComplete menu in SSMS 19.3. There was no indication of error. I tried it twice, with same result. What should i do? How do I troubleshoot this? Thanks.
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?
Unable to use dotconnect for postgres
I recently had to get a new computer and a previous web services site that worked fine under VS 2017 does not work under VS2022 and the error is when accessing the entity I get the following exception. Keep in mind the exact same site is working in production.
Specify synchronization Order
This other software allows to specify the synchronization order so that integrity errors don't happen like foreign key issues. Is this possible with your current version of Data Compare? This is important to avoid, for example, having to disable a ProductPhotos
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
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 -
I have Error in dbForge Monitor SQL Server "this metrics not supported by the current Microsoft SQL Server edition"
Hi, I have Error in dbForge Monitor SQL Server "this metrics not supported by the current Microsoft SQL Server edition" What have I do?
Version Control on Script Files for Oracle
Other Devart Tools allow for Source Control on Script Files but not for Oracle? Also there is no Schema Compare to Script Files, this is a major missing component. This allows Redgate to monopolize the market and charge $140,000.00 for a 50 user Enterprise
ODAC: "Invalid Field Type" when calling a stored function with VARCHAR2 params
We have developed a VCL application in C++Builder, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. Our database is Oracle 19 running on an ODA with latest patches. The problem always occurs when I
Add Stored Procedure fails in DB First, unless trivial contents
Firstly, there seems to be no Support Category for Entity Developer. I hope that's not a reflection of the support for that product?? Most of the time when I attempt to add existing Stored Procedures to the model, the process fails when retrieving result
Intellisense/Suggestions for Locally Created Temp Tables?
I create local temp tables and query from them often in my script. In my previous installations of SSMS with (and without) SQL Complete, I was able to write "SELECT * FROM #" and would receive suggestions for available temp tables to query, including
An error occurred when receiving wrapped code for the 'LOCUS.INC' object: ORA-06550: line
I get this error when I do a schema compare between 2 databases. An error occurred when receiving wrapped code for the 'LOCUS.INC' object: ORA-06550: line 13, column 37: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 13, column 7: PL/SQL:
dbForge Monitor v7.0 w/ SSMS v20.2 on Windows 11 - Microsoft.IdentityModel.Clients.ActiveDirectory error
I've installed the latest dbForge Monitor v7.0 (7.0.158) on my Workstation SSMS install. It installed with no errors and SSMS starts up and connects to a remote server with no errors. When I try to activate "Monitor / Show Monitor" I get the following
V7.0.158 has broken Intellisense support when working with SQL Queries
Myself and another developer in my company upgraded from v6.x to v7.x and now intellisense for selection of Tables/Fields via the dropdown in the SQL editor no longer work? The dropdown shows completely unrelated options and NONE of them help with table/field
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
Importing data into a temporal table requires default value in PeriodEnd, PeriodStart
The PeriodEnd and PeriodStart columns in an SQL Server table are designated as "Generated Always." No default value can be provided. Because Data Pump identifies the columns on the table, a default value is required. How can I import data into a temporal
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
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
SQL Complete - Add selection token which will be replaced by selected text
Coming from other tool, I am missing a option, to create snippet which would replace token in code with text selected before snippet was invoked. I was used to invoke snippets with key shortcut. Dont really know if that is possible in SQL Complete.
ODBC Driver for Salesforce Query Error
Hey guys, I am able to query any table fine so far except for the ActivityHistory table. SELECT * from OPENQUERY([SF],'Select Name from "ActivityHistory"') This is the error I got. OLE DB provider "MSDASQL" for linked server "SF" returned message "[Devart][ODBC][Salesforce]Table
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
Install the prior version
I have recently updated to version 7. I would like to go back to the prior version that supports SSMS 20.2. This new version is bad. I am getting errors after every query I run. (Function Session Property is not supported). Also there is still minimal
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
DBForge Monitor not showing some data
I use SSMS on a desktop computer to connect to certain machines, and dbForge Monitor 1.6.2 does not show me certain information on some machines: Do I need to have some port open, start some service to see this data? Thanks, Joan
Function 'sessionproperty' not supported after upgrade to 7.0.158
Hi We're working on Azure serverless SQL pools, and have been for a while. Recently SQL Complete updated to 7.0.158, and now after running each query in the editor I get an error "Function 'sessionproperty' is not supported" I am running ssms 20.2.3
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
Anyone else questioning the point of renewal?
I work for a large organization and have gone through the DevArt ticket system with multiple different people that aren't really supporting me, just responding with lip service and no actual solutions or useful information along with the time zone barrier
SQL Complete - Is there a way to trigger a snippet while inside a comment block?
Is there a way to trigger a snippet while inside a comment block? for example in SSMS Select * from ... /* This is my comment block On the next line I want to start typing somthing that would trigger a snippet */ update ...
SQL Complete Execution History Search
Can the search be triggered manually instead of automatically after each keystroke? It's painful to wait for the search to complete after each keystroke before you can type in the next letter in the search term
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 -
dbForge Source Control adding extra Unicode characters
The Source Control inside dbForge has begun adding extra characters on the end of commits. How can we fix this? dbForge Studio for SQL Server Version: 6.5.16 Enterprise Azure DevOps And in Notepad:
SQL Query Causing "Execution Timeout Expired" even when connection execution timeout set to 0
I have a query I'm trying to run in dbForce for SQL Server that is causing an Execution TImeout Expired error after 30s, even though my connection settings are set to 0s. What's strange is I've had other queries that run well over that timeframe without
Azure Entra (AD) users not showing in sql server manager tab
In the Security Manager dashboard I can only see sql server authenticated users. The dashboard will not display the AD users that are in the database. I am logged in with the AD sql admin account, the same one I use to set and alter the AD users on the
dbForge doesn't release a file after importing it
dbForge doesn't release a file after importing it. I can't delete it because it says it's locked by dbForge. I have to use an unlocking tool or close dbForge. dbForge needs to release it after the import is done.
SQL Complete Formatter aligns identifier case regardless what is defined in database
Hi, I have come across situation where SQL Complete code formatter will align column name case to be identical when the column names are identical, even though in actual database the column name might be different. For example, if I have the following:
Find dialog. "Look in" option switched to "All open Documents"
After changing active tab "Look in" option in find dialog often switching to "All open Documents". why ? it is VERY inconvenient !! why would not process searching in current active tab by default ? thank you
F7 does not switch between document views
Using dbForge Pro for SQL version 6.5.16 under Win11 Pro. The current keyboard mapping uses F7 for the Object Viewer. I'd much rather have F7 switch among the available tabs in the current document (typically text and data when working with queries).
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?
Next Page