[10.0.46] run a second query (by hotkey) in the same editor does not work (without hitting the hotkey twice)
hi devart, i do hope this is a bug and not another great example of "industrial standards". if you have a regular edit tab open and have a query there that you can run with the hotkey that runs a query where the cursor is - and you write a 2nd query and
additional quotes when copying from the data editor
v.10.0.60 example SELECT JSON_OBJECT("key1", 'val1', "key2", 'val2') UNION SELECT JSON_OBJECT("key3", 3, "key4", 4); 1. when copying a value from one line everything is ok 2. When you copy several lines, additional quotes are inserted
Debugger failed with timeout
hi. I have problem with "step into" while debug code : "Debugger failed with timeout" What's wrong ? Thank you.
code completion for procedure parameters
Hi. code completion for procedure parameters don't work ( dbForge Studio 2024 for Oracle v. 4.6.15 refresh suggestions, ctrl+space does not help also sometimes in some sessions code completions stops working completely ( Thank you.
what grants required for "Navigate to definition" ?
Hi, i have had error while trying to "Navigate to definition" what grants required for "Navigate to definition" ? and are they necessary ? Another IDE successfully perform operation like this under the same user . You should understand that not all users
Strange behavior when opening and saving documents to OneDrive
I have dbForge Studio 2022 for Oracle PE v4.4.64. At my work, I save all my work in OneDrive. For years I have become used to a behavior where, a few seconds after saving a file, I am prompted like this: I assume some file properties were in motion while
This server version 8.0.36 is not currently
dbforge version : dbForge Studio for MySQL Enterprise 9.0.338.0 mysql version：8.0.36 connect error：This server version 8.0.36 is not currently
Code debuging
Hi, where is debug menu items ? Thank you.
Find and replace dialog - look in All open documents
Hi, Find and replace dialog often suppose look in All open documents As for me it's very special case and most user will prefer Current Document by default.
current_schema ?
Hi, how to set current_schema ? Yes, i can make it using ALTER SESSION SET CURRENT_SCHEMA = but 1. It's not convenient 2. In database explorer tree view staying old schema I think this feature should be integrated in interface.
monitoring evolution table
Hello, I have a schema table A which is populated , I want to compare it against another reference schema table B and recover all the data changes, is this possible with Dbforge compare? Thanks. Regards Damien.
where is trigger tab in table editor window ????
Hi where is trigger tab in table editor window ???? i see columns, constraints, Indexes, Options, Date but, triggers ???? Is it exists only in Database explorer tree ?
SQL Server Source Control - which Git client is needed?
SQL Server Source Control - which Git client is needed? instructions state Git client for windows must be installed. We use DevOps for our Visual Studio / C# code. I was unsure exactly which Git client to install, and was skittish about changing any existing
where is window splitting for procedures and package window ?????
where is window splitting for procedures and package editor window ????? is this possibility a big technical problem ?
DDL Search works on comments on views but not stored procedures
As the title states, I can search comments left in views but not in stored procedures. For example we lable all sprocs and views with "author: [INSERT NAME HERE]", yet a search for author only returns the views and not stored procedures.
Data comparison - Req "treat null" option to be split
In Data Comparison tool, the "treat null and empty string as the same" option needs to be split into 3 options. Option 1, for strings: Treat null and "<string defined by the user - default = EMPTY STRING>" as the same value Option 2, for numbers: Treat
Unable to attach the Transact-SQL debugger.
I just started getting this error about 5 days ago, I have no idea why? I used to be able to debug my T-SQL using the "play" button, now I can't?? I was following this thread here until you moved forums a few days ago. What I don't understand is that
dbForge Studio for PostgreSQL
does dbForge Studio for PostgreSQL Data Editor allow you to update bytea columns?
SSIS package task error with HardDelete
I've created a Devart SalesForce Destination task with the HardDelete action. When I attempt to execute, it throws an error of: "...failed with error code 0x80131500 while processing "input"... ." The regular Delete action works just fine. Are there special
Replacing long server nams with an alias in tabs' captions
Some of my server names are very long. For example managed instances names end with 'database.windows.net' They make the tabs very wide and harder to read. Is there a way to instead of using $Server$ in the SSMS Caption setting to use an alias? So instead
**WARNING**: DO NOT INSTALL version 10.0.46 - usability is dead!
hi there, you might have seen the latest update with tons of changes and maybe, like me, you were super happy in the first place to realize, that the team did a great job fixing so many bugs and adding new features. but after using the new version for
BiDirectionalSync
we are using two databases in which one is source database (central database) and the other is destination database (store database). And we are preforming bidirectional sync between central and store database, the problem occurred where the data existed
EF Core 8 / .Net 8 support
Hello, Do you have any roadmap or release date about supporting EF Core 8 ? Currently it's not possible to run a project with Devart.Data.Mysql (9.1.151.7) and EF Core 8.0. Thank you.
Issue when comparing temporal table dbForge Schema Compare
Hello, I encounter an issue while comparing GIT branch VS SQL Server database especially with temporal table alter on dbForge Schema Compare while "Synchronize" action. I unchecked both "Ignore history table" and "Ignore history table name" options and
SQL Complete Snippets - How to insert the text on your clipboard?
In other tools I've used similar to SQL Complete there's always been a placeholder that would insert what you have copied into the snippet. For instance if I copied the text "Table1" and used this snippet SELECT TOP 100 * FROM #Clipboard# I would get
debug is not working
after purchasing license debug is not working in sql 19
Why no active back button after a failed data import?
After an import fails for whatever reason in the Import Data option, the back button is always disabled. I can only click on the Finish button and it takes me out. This means I have to start all over again and repeat this workflow until there are no more
Importing fixed width flat file should default to the columns and their sizes in the destination table
I am trying to import a flat file with fixed width columns. I created beforehand a table to accept this data and defined the columns with sizes that match the field size to be imported, in the import wizard I had to manually define all the positions and
SQL Complete - Can the code snippet auto-complete function be customized with a key other than 'Tab'?
Dear Devart, Hello. I am a user who is considering using sql complete this time. I asked you a question about using Code snippet in SQL Complete. As a result of checking the manual, it is confirmed that the snippet is automatically completed if you enter
Data Export - All Floats Become "General"
I'm using dbForget Studio for PostgreSQL Professional Edition v. 3.1.618. When I use the data export tool, all floating point numbers in all output formats simply become the word "General" - no numbers; just the word. Anyone see that before? I tried restarting
Minor visual issue in data comparison
Data comparison, Mapping tab. Pressing ... on a table which has a comparison key, opens the mapping window. In there, see the problem portrayed in the image attached to this post.
Is it possible to add a report to a data syncronization?
I am currently working on a project in which I am using the script of the following article to synchronize two databases: Compare Two Database Schema in SQL Server on a Schedule (devart.com) I was looking for more articles and I found this second article
Is it possible to connect to oceanbase?
I got a error message by test connection "Unknown table 'PLUGINS' in information_schema (code 1109)"
Source Control Conflicts - Grants added on end
Hello, When running source control some tables, procedures etc. are flagged as conflicting. Clicking get local/remote does nothing as they seem to come back on refresh. The conflict seems to be grant permissions being added on my local database (automatically)
[10.0.60 ENT] unable to export to google sheet if auth failed
hi devart, when i authrorized dbforge for google account A) and later on I need to export data to a sheet that is connected to a different account B), I have no choice. instead of this error, dbforge should ask to "re-authenticate". unable to do that,
Renamed Tables in Schema Comparison
I have several tables in my database with the names changed. Using the Schema comparison, the suggested strategy is to DROP the table and create the new one empty, but this will generate a data loss. How to "explain" to the Schema comparison tool that
Can't Set the Text Color
Hi. I just reinstalled dbForge Studio on a new machine without backing up my old settings. I had the Visual Studio Dark skin before with readable white colored text in the code editor. Now that I have installed this slightly newer version on my new machine
You have problems with version v10? Here's your solution!
step 1 step 2: enjoy going away the pain step 3: bring back peace to your daily work FINAL WORDS I'm tired of playing guinea pig and spending my time making stupid bug videos and closing 100,000 tabs every day, I'm just tired of this shit! I'll use version
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
Amazon Redshift ENCODE issue
Redshift tables DDL generation Note: ENCODE encoding The compression encoding for a column. ENCODE AUTO is the default for tables. Amazon Redshift automatically manages compression encoding for all columns in the table. If you specify compression encoding
Next Page