472 results found
-
Code for CREATE TABLE with MariaDb "system versioning" is not generated correctly.
On a table with system versioning, from context menu I select:
Generate script as > CREATE > To new SQL window.
And the output does not include SYSTEM VERSIONING data at all.
When I run SHOW CREATE TABLE tablename - I get correct information.The same with "Edit table"
(In general it would be nice to set, if "Generate script" uses dbForge engine, or from database "SHOW CREATE TABLE", because output sometimes is drastically different)2 votes -
Allow additional SSH config
If I can add a config file somewhere already, great. But where would it go?
Otherwise it would be great to have access to add other OpenSSH client configuration options. In my case I'm after ProxyCommand so I can add a script to proxy over the SSM agent in AWS.
3 votes -
Add support for "Stored Aggregate Functions"
The ability to create stored aggregate functions was added in MariaDB 10.3.3. but dbForge do not read they.
https://mariadb.com/kb/en/stored-aggregate-functions/
I see the functions in the tree, but when I try to open they I get an error like "Unable to parse source text", and when I try to backup a database that contains Stored Aggregate Function it fails.
3 votes -
Set cell value at UTC Now
With a right click, I can set the date and time to now, it would be nice to also have the possibility to set the value to "UTC now". This is important when the database is used across multiple time zones.
9 votes -
right-click on cell -> Set value to -> custom value requested by input
right-click on cell -> Set value to -> custom value requested by input,
actually I can set to 0 or null, but in my case y need value "1" or another value.
I Actually re-paste values from same column to the rows needed, it's more easy for me set value to all column if I do a good search query before.
1 vote -
onlyoffice sheet import same as Google Sheets method
Import from Onlyoffice with Nextcloud same as Google Sheets method
1 vote -
can we have option to change font size
can we have option to change font size, in table edit and toolbar many more required have change font size. because it is very difficult in big size monitor and specially have developer which high eye number issue. it is very difficult to read.
when we are doing long time work, eye have pain, headache issue also.
Thank you
4 votes -
Projects
I'm not the DBA but a DB developer. I use PROJECTS to manage scripts and SQL tools by project and support ticket.
I want to be able to define the various FIlter Setting within a project as well.
Meaning, when I load a PROJECT, not only do I get access to my various SQL scripts for that project, but it also loads FILTER settings as well. We have a few thousand tables, and it's various tedious to keep redefined the filters when I switch projects.
1 vote -
Export to MS Excel 2007
Currently, exporting to MS Excel 2007 more than 1048576 rows, dbForge doesn't slipt to a new Sheet the remaining rows.
1 vote -
Allow disabling quotes for SHOW CREATE TABLE during schema compare.
Give an option to run SET sqlquoteshow_create=OFF; before a schema compare. So that the schema generated via MySql does not add the quotes to everything.
6 votes -
You have a bug, this stored procedure has legal text, you can compile it, but it cannot be edited by the tool.
You can compile this stored procedure but you cannot edit with your tool, it says that the code is wrong, but it is not.
CREATE DEFINER = 'root'@'%'
PROCEDURE simulation.comparebill()
BEGIN
with mybill AS(
with billing AS(select c.day AS day,c.code AS code,cast(c.seconds as double) / 60.00 AS Mins,
case when r.code is null then 0.005 when c.jurisdiction = 'Inter' THEN
r.inter when c.jurisdiction = 'Intra' then r.intra else greatest(r.intra,r.inter) end AS rate,
ifnull(r.description,'Missing Destinations at $0.005') AS description
from (cdr c INNER join ratedeck r on(c.code = r.code))) select billing.day AS day,billing.description AS description,
round(sum(billing.Mins),2) AS Minutes,
round(sum(billing.Mins * billing.rate),2)…1 vote -
add UI for sorting and searching for connections in the database explorer
I have about 100 database connections - these appear to be presented in creation order, so I have to remember when I created something in order to find it
This view should at least have a sort option... Others have suggested search, which would also be a great help
4 votes -
Implement the Database Diagram functionality that will be able reconnect to another DB after work database is moved
Implement the Database Diagram functionality that will be able reconnect to the cloned DB after work database is moved.
Sometimes DB server for developers can be changed3 votes -
Show/Hide additional document views
With new DBForge update (2020), keyboard shortcut to show/hide additional document views is gone. Please add this feature back as it was extremely convenient to show/hide data results when writing long procedures.
5 votes -
1 vote
-
Showing total rows next to record count
Showing total rows next to record count example. "Record 1 of 302+ of 25000" or something similar, always knowing the total rows in a query or filter is very important
1 vote -
Allow Skip Idénticas, remove or unmap
Allow Skip Idénticas, remove or unmap. If one knows the databases are offline, idéntica tables will Stay the same and dont need to be recompared. Do better at managing Idénticas.
1 vote -
Automatic naming of the connections should be reversed
When a new connection is created, it gets the name of the database.ip.add.re.ss, but when you have 100+ connections, it takes a long time to find the one that you need to work with, since typically the database names are the same, at least in my business. I need that the name be ip.ad.re.ss.database, and the IPs be sorted by IP, not alphabetically, si it would be faster to locate a connection.
2 votes -
Be able to disable GroupDatabasePrivileges query from executing in Schema Compare and actually NOT RUN the query
Be able to disable GroupDatabasePrivileges query from executing in Schema Compare and actually NOT RUN the query as its slow one som systems. In schema compare I have ignore privileges ticked, but the query still runs
6 votes -
International date formatting not working
See: https://i.imgur.com/FvTda6n.png
Sometime in version 9, 'datetime' fields in tables and queries format to the American standard, even though the formatting options show an example of International formatting, this is not applied
4 votes
- Don't see your idea?