Evaluating SQL Source Control - Linked server on Get Latest
Hello! I am trying to run a get latest command in the Source Control module - there's 1 stored procedure it's trying to update my local DB with that has a linked server. The linked server does not allow distributed transactions and I saw that the tool
Trouble installing SQL Source control add-ins for SSMS
Hi all, Trying to follow the steps in the installation guide to evaluate this vs redgate, and the first bump is that the download link for source control goes to the DBForge SQL Tools download, and not a standalone installer. Ok, fine. I install the full
Can't install SQL Search version 2.7.25 for SSMS version 20.0
Hi, This is the error that I get. With SSM 19.X, it's working.
How to delete a Db in dbForge Studio for Postgres
How can I delete a database in dbForge Studio for Postgres (without running a command) I don't see such an option when I right click database
dbForge Studio: Is it possible to work with diagrams (*.DBD) without being connected to a database?
Hi, I am trying out dbForge Studio and would like to use its DB Design features without necessarily being connected to an instance of SQL Server. Is this possible? Thanks and regards, Mario
How to draw/sync db with ER Diagram?
We are evaluating DBForge Studio for PostgreSQL, and in a prior position while using the DBForge for SQL Server, I saw that it had a ER Diagramming tool. Since PGAdmin is so very basic and lacks much, I was hoping to make up for that deficit with DBForge
Support .gitignore in dbForge Source Control (Feature Request)
Please follow .gitignore for SQL Objects. For instance, we have a convention to deprecate objects by prefixing them with "zzz_old_YYYYmmdd" and then waiting a few months before finally deleting them. Source Control doesn't follow the .gitignore file so
SQL Complete - Management Studio 20?
I just migrated to a new machine, and by default installed the current release of SQL Server Management Studio, which is version 20.0. When I installed SQL Complete, it doesn't add itself to SSMS; is this because version 20 is not yet supported? If this
Is DbForge for postgres unfinished ?
There is no designer for creating objects like: Tables PK and FK indexes triggers Functions Domains See this post from the year 2021 where it said it was in the plans and it's been 2 years. forums.devart.com/viewtopic.php?f=51&t=47836 I am very interested
Schema compare not syncing
Using the MySQL Schema compare I have a field in a view which does not sync, it sees the difference every time but does not update it. the difference is: CAST(LEFT(`assets`.`AssLocation`, 30) AS char(30) CHARSET utf8) AS `Asst_Locn`, and CAST(LEFT(`assets`.`AssLocation`,
Color schema for matching brackets like in Azure Data Studio
Is there an option (or is it at least planned) in dbForge Studio for SQL Server to use different colors for matching brackets like in Azure Data Studio?
How to configure automatic formatting of function words in a text editor?
Hi, dbForge Studio for MySQL v.10.0.150 There is a problem with the word "SET" . How can i customize text editor to print this word in upper case automatically? The parameter "Automatically format words while typing" is on. I print SET in upper case mannualy,
[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
Next Page