importing data from SQLite to excel, changing data and then exporting back to a different table in SQLite
Hi i am trying to find out how to import data from SQLite into excel using Devart excel add-in, change the data and then export the results back into different table in SQLite. Any help would be greatly appreciated regards John
Cant connect to my MySQL
I am absolutly doing something wrong, but i cant connect to my MySQL with "dbForge Query Builder for MySQL" or its impossible to connect to small server like 'USB Webserver'? Its get me error 1146
execute procedure via dbforge studio give error cursor does not exist.
While executing the procedure via dbforge studio, it gives an error: Cursor <cursor_name> does not exist. But the same code runs in pgAdmin 4. call ea.usp_procedure_name(parm_1,parm_2,'ref_result_data1'); fetch all FROM ref_result_data1;
Tools For Versioning MySQL Stored Procedures
Greetings, currently with our particular business issues we need a way to versioning the stored procedures of our databases (Amazon MySQL RDS), we are making this process through GIT but still we have to update manually the modified procedures but this
SSL Support in Express Editions
Would like to know why in light of emphasis on security in managing and access to databases these days that you took the frankly moronic decision to not include SSL support in the express editions of the tools. Even free open source tools like heidisql
Error Log Recorded
We are getting a lot of security alerts from our SQL Server that triggers from dbForge Studio 2019 Express for SQL Server. It spams our SQL logs for failed log in attempts (currently from one user that uses this application) very frequently through the
connection with ssh problem
I'm trying to access with ssh private key, but I get the following error Connections using insecure transport are prohibited while --require_secure_transport=ON. The connection is fine with mysql workbench.
Subscribtion
Hi, Just got message I paid for subscription for IBDAC and SDAC. Can you explain what's going on, I mean I didn't order that and what kind paymanet way it happened. It doesn't mean I don't want to prolong subscrubtion, but it was beyond my knowledge.
Right Align Keywords?
I've created custom formatting for MySQL that makes reading the code a lot easier, but I'm not seeing any options to right align keywords? I see this is a feature in SQL Server Tools, but I don't believe it is an option in MySQL settings. Is there any
Error when connection lost
We discussed this problem earlier on the old forum: https://forums.devart.com/viewtopic.php?t=40965 The problem is, that I already followed your hints. 1. Added MemData 2. MyConnection1.Options.LocalFailover:=TRUE; 3. RetryMode := rmReconnectExecute;
dbForge Data Compare via CrossOver crashes upon launching
Hi, I cannot get Data Compare for MySQL working under macOS via CrossOver. I followed the instructions (here: https://docs.devart.com/data-compare-for-mysql/getting-started/run-dbforge-datacompare-linux-macos/manual-installation.html and here: https://www.youtube.com/watch?v=Q05wQ2t3vXw&list=PLpO6-HKL9JxVXnlqLkk1jOSe3mf8U4kkF&index=4);
I can't copy anything from the results from dbForge Search
I can't copy anything from the results of dbForge Search. There's no right mouse click menu and when I hit ctrl-c I get this error message.
Query Profile Mode but???
Hello, I am in try version with dbForge for a new project using postgresql database. I see you have query profile mode but I don't see catching statement when I process from my UI. What I mean, is it possibility to catch all incoming statement like SQL
please add support for mariadb 10.11.2
thanks
SQL commands of dbForge Studio for MySQL GUI's backup action
Hi all, Is there a way to read what is the SQL commands of action click in dbForge Studio, like a backup click action on database backup and restore page? Regards, bobojin
"Auto refresh" when adding
Hi guys, This is a feature request (or a bug report?), it's been years I haven't had one due to your tool being too complete ;) When I create a new table, database... I have the refresh the database explorer. It'd be great if once the creation has succeeded,
Paginal mode when running stored procedures
Is it possible to for paginal mode to be on by default when running a stored procedure? I have it enabled via Tools...Options...Data Editor...General...Use paginal mode by default and this works for standard queries but when I execute a stored procedure
Table sorting
One of my favorite live sex cam sites features daily live shows from popular porn stars, adding an extra level of excitement. https://cammilf.net/curvy https://bbwcamchat.org/chat/dirty_sara17 https://bbwcam.site/crossdresser
cant open View Table
My view table has quite a lot of lines and sub queries. Once i created it, i cannot open it via SQL, Editor or Generate script as CREATE. It just keep loading and eventually not responding. Kindly advise. below is sample query of how the view table looks
[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
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
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
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
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
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 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?
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.
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
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,
dbForge for MySQL
Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL