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
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
Running Report Created by dbForge Studio for SQL Server in different environments
I created report using dbForge Studio for SQL Server on development server. How can I run the same report on testing server. Both development and testing servers have the same exact structures, just different data.
Need help using Transaction Log tool with a TDE encrypted MSSQL server.
I've purchased dbForge Transaction Log. Our production database uses TDE for encryption. I cannot open the logs for either the online or offline DBs. I believe this is normal behavior because the DB is TDE encrypted. I tried to get around this by creating
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;
Source Control - missing user permission changes
When using the Source Control Manager in SQL Server Management Studio, it doesn't pick up changes made to database User security. I added an existing database user to the db_datareader roll in management studio and Source Control Manager shows no changes
Exclude objects from schema/data compare from command line
This is a follow on question to https://forums.devart.com/viewtopic.php?f=33&t=39489 In that post it reads You can create a filters list that will be used in the command line using the key: CODE: SELECT ALL /schemacompare ... /Filter:"C:\Filter.scflt"In
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
SQL Search
Hi, I have a question about SQL Search, I have not found this information anywhere. Do you know what permissions (in SQL) are needed to make it work) some one has a list like this? VIEW ANY COLUMN ENCRYPTION KEY DEFINITION VIEW ANY COLUMN MASTER KEY DEFINITION
Schema/Data Comparison: importing table mapping from other comparison file
I have spent about half an hour in schema comparison screen to map the tables of two databases that have significant differences (the one is an upgrade of the other, with several changes). Now that i have finished, i find myself in need to perform a data
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
Source controle for git doesn't detect git folder
The folder has been clonned with visual studio with this result: When we set the folder in source controle he doesn't detect the git.
Data Generation Wizard only lists tables from one schema
Using dbForge for Postgre SQL (version 3.1.701) I connect to a simple test database. The DB happens to be in google cloud as a CloudSQL Postgres. The db has tables in 3 schemas (public, immutable, version3). I fire up the data generation wizard. After
Is dbForge Studio for SQL Server in evaluation version?
Hello, I have just downloaded SQL complete tools and I don't find this product dbForge Studio. Is it a different product? Thank you in advance.
SQL Complete with large databases
Any tips for tuning SQL Complete with large databases? I work with ~100 similar databases across multiple servers. Each database has ~65k tables, ~100k stored procedures, 15k functions etc. I've read that SQL Complete shouldn't cause SSMS to freeze -
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
Urgent: Does DBForge Source Control Support Azure SQL MFA Authentication & Object Locking in Shared Mode ?
Does DBForge Source Control Support Azure SQL MFA Authentication & Object Locking in Shared Mode ?
Unable to uninstall. Error that SSMS is open, but it is not.
Hi, I'm unable to uninstall. I have restarted the PC, so nothing was running.
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.
SQL Complete - Copy and Paste from Execution History preview window in SSMS
Is it possible to copy and paste highlighted text from the Execution History preview window? I see that it's possible to copy the entire script to the clipboard from the top pane in the Execution History tab, but I find myself frequently wanting to copy
DB schema comparison script fails but Studio reports it has finished normally
I had made some alterations in the structure of a database, so i executed a schema comparison with another similar DB. I generated the differences script and executed it from within Studio. It said it had "finished successfully", but when i re-compared
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
SQL Complete Formatting
Hi, Is it possible to format code where the values are all aligned? I've tried but could get it to work. From this... MERGE INTO [dbo].[SomeTable] AS [Target] USING ( VALUES ( 1 , N'AAA' , N'AAA' , 1 , 0 , N'CBE0001' , '2020-05-11T16:00:22.3466667') ,
Keeping the Snippets when changing OS
IT is updating our OS and have mentioned this requires a wiping of the hard drive. Are my snippets I have created safe when I reinstall SQL Complete and sign in again?
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;
SQL Compare Fails trying to CREATE function referencing a table it is creating later in script.
Title says it all, SQL Compare Fails trying to CREATE a function referencing a table it is creating later in script. Why on earth would the order of operations be to add the function before creating a table it is referencing? Seems ridiculous. Is there
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.
Next Page