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.
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
SQL Schema Compare between revisions of TFVC
Im using Source Control on TFVC. When I'm trying a comparison between different changeset, the source is always empty and the result is a drop for every object in the target. For example between head and changeset 5 there's only a change But the tool
Issue when migrating data
Hello, I face this error message for every table inside my schema. although I just created the schema structure only and all tables are empty. I did this step while leaving it without tables and let dbforge create the tables, miss the already configured
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,
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, and it's working fine. call ea.usp_procedure_name(parm_1,parm_2,'ref_result_data1'); fetch all FROM ref_resu
dbForge doesn't recognize null. It has to be "null"
I am having several issues when importing from a json file when using dbForge version 6.4.7 - I have the setting to ignore errors yet dbForge imported nothing. - I attached the log file. The file mentions Row: 201. If it read 200 rows successfully, why
Is there a way to extract whole postgres schema without the data ?
Hello I am looking for a solution to extract all my postgres schema to a file. DDL format would be nice. Thank you for help!
Export results from dbForge Search within SSMS
Hi I've done a search for the name of a table, and have a list of around 40 results. I need to go through each of these items and check / update some code. However, I'm not going to get it all done today, so I'd like to export the list of results to a
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
Saturday night, buds are gaming, but you'd rather drain your sack-so hit these adult cams instead. Real couples broadcast from their bedroom, fuck-music rumbling, roommate still awake next door, risky shit gets the heart pounding. Blonde wife deepthroats
Is SQL Complete going to be created as an extension for Azure Data Studio?
Are there plans to port over the functionality of "SQL Complete" for SSMS into Azure Data Studio as an extension? Azure Data Studio vs dbForge SQL Complete: Which One’s Best at Code Completion? Thanks!
How to use Kerberos auth
I've got an Aurora postgres database set up to use Kerberos authentication. How can I configure dbForge to connect with Kerberos?
Error while running schema comparison (PostgreSQL)
Hello! The same error exists in dbForge Schema Compare for PostgreSQL and in the dbForge Studio. As I can see these both tools using the same files: Devart.DbForge.DbObjects.dll Devart.DbForge.DbObjects.PostgreSql.dll I have sent Error Report yesterday.
Exception when generating diff report for PostgreSQL from command line
Evaluating schema compare tool using PostgreSQL 14.7 local databases. Can successfully generate HTML report from User interface, but same process is failing when generating via command line. We want to plug this into our build server pipeline, so command
Importing CSV with french boolean
Hi, I'm testing dbForge studio for PosgreSQL. I'm trying to impot CSV file with french boolean value in a column ('VRAI', 'FAUX')... but it fails How can I handle that ? (PS : I cannot change the source CSV file)
Attaching dbForge to a new version of SQL Server
My company pushed SQL Management Studio 19.0.1 to my computer but left SQL Management Studio 18.5 also installed. I cannot install or uninstall any software on my own. I've tried re-installing dbForge SQL Complete, but it remains connected to the 18.5
Database Explorer does not show all objects, even if 'Show All Objects' option is enabled for the connection.
Hi Team! I faced an issue with Database Explorer View when it does not show all objects, even if 'Show All Objects' option is enabled for the connection. The problem seems relates to the fact that query: SELECT * FROM ALL_OBJECTS WHERE OWNER = 'MY_SCHEME'
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
"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
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
Next Page