"Profile server events" tool require VIEW SERVER STATE permission
"Profile server events" tool require VIEW SERVER STATE permission. But at the same time the original ms "SQL server Profiler" perfect work under the same account without VIEW SERVER STATE permission
[9.1.21] Unresolved error when using JSON_TABLE function against simple scalar JSON array.
For some strange reason, the following valid and correct JSON_TABLE command generates an error when executing the following statement in a new query window or stored procedure. SET @json = CONVERT('[1095, 1106, 1193, 1288, 1357, 1385, 1390]', JSON); SELECT
dbforge schema compare for mysql not generating html from command line
dbforge schema compare does only generate an empty report when running it from command line. From gui, everything works fine. The comparison itself looks fine, log files look good, just the report is not created properly. the generation seems to abort
How to browse Linked Servers - SQL Server
I’m using dbForge for SQL Server Enterprise, how can I use this to browse Linked Server objects? I can do this with SSMS’s Object Browser, but I’d like to not have to switch between 2 db tools.
Creating and Updating MySQL Database Schema on Remote Devices Without DBForge Installed
Hi everyone, I am facing an issue with creating and updating a MySQL database schema on customer tablets that do not have DBForge installed. I have already created the schema using DBForge for MySQL and can export it, but I'm not sure how to create the
Cannot connect to Amazon Redshift
We have been evaluating the dbForge studio as a solution for maintaining the databases and schemas in our DWH, which is Amazon Redshift. According to documentation, dbForge studio for Postgres should be able to connect to Redshift (as Redshift is postgres-based),
dbForge Report Writer
I an testing dbForge Studio Report Writer. I have built my first report reasonably well but I am having trouble with the formatting. I have a calculated field for the Total Taxes. I would like it to be in currency format and cannot find out how to do
dbForge Schema Compare for MariaDb 10.11.2
Hi, I've seen similar issue from a few weeks back but for DB Forge. You ended up sending a person link with a custom build. Do you have an option to do so for your Schema Compare customer? I recently updated my box and had to rebuild docker container
Force allias
Hello Sometimes tabla name not displayed and see 'Query' This is an example: SELECT * from ContractBalanceTX cbh where 1 = 1 And ContractBalanceProcessesId IN (select list FROM @contractbalanceprocess) AND ContractId IN (select list from @your_list) --(1053,
Ignore specific Tables, Views, Procedures, Etc.
I am doing a comparison/synchronization between a client's database and my local server. There are specific tables, views, procedures, etc. that are ONLY used on their servers, reference other servers/databases in their environment, etc, that I don't
Expand all SELECT *'s in large query
At my job I have inherited a large (13000+ line) query with numerous unions of the form: SELECT * FROM a UNION SELECT * FROM b. We are running into an issue where a and b can end up with different column orders causing this to fail. This is further complicated
How to ignore INITRANS with Oracle Schema Compare?
I'm comparing an 11.2 database to a 19.0 database. In the comparison view, this is the 11.2 db: and this is the 19.0 db: And this is the relevant part of the sync script: How can I eliminate INITRANS from the comparison?
On Save of a view the editor / formatter adds backticks (grave accents) around names - How do I stop this?
Hi guys, When saving a view, the auto formatted adds backticks (`) around object names eg. `ea`.`ParentEntityId` AS `ParentEntityId` I want to turn this off (unless necessary, like a name with a space) so the line reads like; ea.ParentEntityId AS ParentEntityId
SQL Query Hangs when adding anything beyond Select *
Using the Excel Add-in to pull and refresh BigCommerce sales data for orders with status = 'shipped' when selecting columns for a preview, the query executes fine. However, when adding any filters/order by logic, the query is stuck on 'executing query'.
MySQL 8.0+ : Compare and Generate Schema without Integer Display Width
As noted Old DevArtForum topic "Integer width deprecated" > In mySQL 8, there is a Warning, when creating a field with integer incl. precision. > "Warning: #1681 Integer display width is deprecated and will be removed in a future release." Can DevArt
Output the Search (Find a database object) to a file, table, excel, clipboard
After doing a "Search" (Find Database Object) thru my database, I'm unable to copy the results. Is this just not possible? Or, do I need to request a feature/enhancement?
Question/Problem dbForge keeps asking for an old connection when opening .sql file
In the past I have used another connection to work with dbForge. The connection has changed, I removed the old one from the database explorer and even when I'm using the new one, when opening a .sql file it keeps asking for the old one and I have to manually
SSH Connection with Public key not working
Hello, I am using dbForge Studio 2022 for MySQL Enterprise Edition 9.1.21 and trying to connect to a MariaDB server on a remote Arch Linux server via SSH. On that server, SSH is configured to accept public key authentication. When using the standard Windows
dbForge Enterprise via MySQL
Hi, I am on the process of migration using the copy database. Picture for reference. I am stuck with those red line that have percentage and not showing errors to troubleshoot. Btw, I am using a free trial and plan to buy license but i am testing it
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
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