How to make a Order and Order Items report
I have two tables: Orders: OrderID Name Address etc. Order Items: Item ID Item Name Qty etc. How do I make a report that shows the Order and then all the Items on the Order? In the Detail Band, I can only see one record, not all the records in the Order.
Full-text index support in dbForge Studio 2022 for SQL Server
Are there any plans to add support for full-text indexes in dbForge Studio 2022 for SQL Server as found in SSMS?
How to get MySQL time fraction with Devart dotConnect Express MySQL?
Assume that I have a table like this: CREATE TABLE `table1` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `date` date, `timestamp2` timestamp(2), `datetime3` datetime(3), `time6` time(6), PRIMARY KEY (`id`) ); Here's the sample inserts: insert into table1(`date`,`timestamp2`,datetime3,time6)
dbForge Studio for SQL Server on Manjaro
Hi, Did anyone try running dbForge Studio for SQL Server on Manjaro or any other Linux distro using CrossOver? Thanks, Tom
Dbforge for MySQL Command Line interface
Hi, Is there a way to save the command line output when running a batch file of the number of rows imported?
Color correction in import
I have two issues/question in Studio 2022 for SQL server. 1. Using "Visual Studio Blue" Skin, go to Data pump / Import external data / ODBC. In ODBC options, enter the necessary data, then go to "Destination". In there, when you select a table from Source
Issue with Devart.SSIS.Salesforce.SalesforceLookup
For the last couple of days we're receiving this errors when we tried to get data from salesforce. Could you please help us? Thanks a lot. Error Code: 0xC00490F7 Description: The managed pipeline component "Devart.SSIS.Salesforce.SalesforceLookup" could
Avoid describing all source and target objects on data comparison
Hello, we are planning a full DB migration, with lots of tables involved, that require us to define and execute different dbcomp files in order, as there's dependant data involved. dbForge does the job perfectly, however, we do see a major slowdown in
Unable to connect SQL server database
I write a code on databricks python notebook to connect My SQL server database through ODBC but it's showing error as in attached file. Pls provide me solution ASAP.
STRING_TO_ARRAY
i'm getting an "error" while trying to format a document SQL1.sql: Error (6,5): Unexpected symbol 'STRING_TO_ARRAY'
Sample size while mapping
Hi I am trying to import a large dataset from a csv. When using the wizard, it is eventually setting the type and the max. lenght of each column, using a sample of 100 (?) lines. How can I tell the wizard to use a larger sample, like 10.000 lines?
Schema Compare doesn't support unique indexes which contain CASE statements
We have a unique index that contains a case statement: ADD UNIQUE INDEX uk__phone__org_id__phone_number(org_id, ((case when (`org_id` <> 2) then `phone_number` end))); We added this index to our database project and when we perform a schema compare between
Data Comparison. Describe Objects
I have two databases with each schema containing 171,000 tables(Since it is an ERP application). I want to compare a select few tables only, but first I need to load all the objects. Steps performed: 1. select New data comparison option 2. Select source
SQL Complete - Is there a way using the formatter to ensure spaces exist between brackets in the where clause
Is there a way using the formatter to ensure spaces exist between brackets in the where clause? example: WHERE (Column1 = @Column1 Or Column1 > 0) would become WHERE ( Column1 = @Column1 Or Column1 > 0 )
dbforge for Vitess
Hi Team, We are trying to use dbForge studio with an existing Vitess based MySQL cluster but are not able to view the database schema. Can someone please confirm if dbForge supports Vitess based MySQL cluster ? When adding our vitess db with our credentials,
Connect to Microsoft Analysis Services
Is it possible to connect to Microsoft Analysis Services using dbForge Studio? I'd like to use dbForge to query SQL data in Analysis Services
dbForge for SQL Server
Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
dbForge for MySQL
Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
dbForge for Oracle
Discussion of open issues, suggestions, and bugs regarding database management and development tools for Oracle
dbForge for PostgreSQL
Discussion of open issues, suggestions and bugs regarding database management and administration tools for PostgreSQL
Popular Topics
New AI Feature in dbForge Studio for SQL Server
Good start but a bit rough when actually using it, both in terms of UX and output. My first prompt, "Explain this query", resulted in a 500 internal server error. I figured out I had to include the query with the prompt but in these cases, Studio should
connection "forgot" parameter "enable DBMS output"
Hi, after automatic reconnection connection "forgot" parameter "enable DBMS output". dbforge studio for oracle 2025.1.34
DBForge MySQL - BOOL fields converted to TinyINT(1) on their own
HI ! Not sure If this is a bug or a new feature. But I just noticed that ALL of my fields that I created as Boolean types, converted themselves to TinyInt(1). Every one of them in the entire database. This is 2025.1.124. Is this supposed to happen ?
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
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
Popular Articles
How to Download and Install a Previous Version of the Product
If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...
How to Connect to MySQL Server
In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...
How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools
If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...
Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce
When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...
How to Activate a Trial Version in dbForge Products
Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...