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
V7.0.158 has broken Intellisense support when working with SQL Queries
Myself and another developer in my company upgraded from v6.x to v7.x and now intellisense for selection of Tables/Fields via the dropdown in the SQL editor no longer work? The dropdown shows completely unrelated options and NONE of them help with table/field
Function 'sessionproperty' not supported after upgrade to 7.0.158
Hi We're working on Azure serverless SQL pools, and have been for a while. Recently SQL Complete updated to 7.0.158, and now after running each query in the editor I get an error "Function 'sessionproperty' is not supported" I am running ssms 20.2.3
Feature Request - Object Bookmarks
It would be very useful to be able to bookmark objects in the Database Explorer. It can get tedious moving between different objects in different tables in different servers... It would be useful to be able to right-click and bookmark an object (table,
Compare to schema inside same database
Hi, I started to evaluate DbForge Studio for PostgreSQL. I wan't to compare schemas inside database. (I mean those schemas which are created by CREATE SCHEMA myschema); our use case is for example a franchising chain, where all companies are under same
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 Formatter Select List Margin Break
Hi there. Is it possible to break the SELECT list at a particular margin point? I'd like to leave the Select List "Stack Columns" option as Single Line, but I'd like to be able to specify when the Select column list should break to a new line. Is this
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!
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
What happend to dbForge Studio for SQL Server?
Hi there I have now updated to the latest version of dbForge Studio for SQL Server. And in hindsight, that was a big mistake. - The time it takes for the program to start has increased by a factor of ten - Intellisense no longer works automatically -
ERROR: FUNCTION 'SESSIONPROPERTY' is not supported.
Hi, Anyone had this error when trying to conect do a Microsoft Fabric instance? The endpoints works fina on Azure Data Studio and SSMS but i get this error on DBFORGE Studio for SQL Server
Stop tab rows from shifting in dbForge Studio
I have "Show tabs in multiple rows" on. Is there a way to stop the tab row of a clicked tab from always being moved to the bottom row? It's not helpful having tab positions always being moved around and no other IDE I use does this.
How to show table name on windows with retrieved data?
When I'm retrieving data from table through context menu option in previous versions on opened tab was shown name of the table. But now its just "SQL", "SQL1", "SQL2"
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
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
Oracle - EFCore - Hints
Hi, I am trying to use OracleFunctions.Hints("ALL_ROWS") in a project that is using Devart.Data.Oracle.Entity.EFCore. What is the recommended way to add Oracle optimizer hints in EFcore ?
HasConversion not working with EF Core 8 when converting an Enum
Hi, We're using HasConversion<string> to convert an Enum to string and vice versa but it's throwing an Exception. We've also tried the following syntax : .HasConversion( v => v.ToString(), v => (EUserType)Enum.Parse(typeof(EUserType), v)); But we're getting
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
STRING_TO_ARRAY
i'm getting an "error" while trying to format a document SQL1.sql: Error (6,5): Unexpected symbol 'STRING_TO_ARRAY'
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
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
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
Is there a better way to view this panel info?
When viewing indexes for a table, the index "details" panel (see image attached) is incredibly awkward, being compressed into a small space. Is there a way to better view that panel to use it more easily? e.g. a different window/panel arrangement or an
Where can I view Java Classes in dbforge Studio for Oracle Database Explorer?
I can easily expand and select Java classes to view the source code in Oracle SQL Developer. But, how to do it in dbforge Studio for Oracle?
Is it possible to connect to oceanbase?
I got a error message by test connection "Unknown table 'PLUGINS' in information_schema (code 1109)"
How to compile a db object loaded from a file?
I can't find any documentation on how to use DB Forge Studio for Oracle to load a package spec and body from a file on my PC and then compile it. It only seems possible to create them from scratch or to edit existing objects. My team keeps all of our
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 hide the column type in the suggestion list in SQL Complete?
How to hide the column type in the suggestion list in SQL Complete?
getting error connection error 08006 or Error: No such host is known
Hi, We got an error on and off as "connection error 08006" or "Error: No such host is known" when we try to run some report . But if we re-run the same report again, then no error will be shown. Do you have an idea what causing the issue? below is a sample
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
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
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') ,
How to make a Order and Order Items report
I have two tables: Orders: OrderID Name Address etc. Order Items: Item ID Item Name Qty etc. How do I make a report that shows the Order and then all the Items on the Order? In the Detail Band, I can only see one record, not all the records in the Order.
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
dbForge doesn't release a file after importing it
dbForge doesn't release a file after importing it. I can't delete it because it says it's locked by dbForge. I have to use an unlocking tool or close dbForge. dbForge needs to release it after the import is done.
"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
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
Feature Suggestions : Schema Filter
Feature Suggestions : add a "Schema Filter" function like "Table Filter"
SQL Complete - Add selection token which will be replaced by selected text
Coming from other tool, I am missing a option, to create snippet which would replace token in code with text selected before snippet was invoked. I was used to invoke snippets with key shortcut. Dont really know if that is possible in SQL Complete.
SQL Complete Support for Synapse/Serverless
We are moving our SQL Servers to Synapse/Fabric, and are using the Serverless options. However SQL Complete does not work with these. Are there any plans on making it compatible?
Next Page