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.
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)
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
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
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
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.
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 -
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.
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
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?
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
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
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
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
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,
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!
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
"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
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.
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
Output the Search (Find a database object) to a file, table, excel, clipboard
After doing a "Search" (Find Database Object) thru my database, I'm unable to copy the results. Is this just not possible? Or, do I need to request a feature/enhancement?
Full-text index support in dbForge Studio 2022 for SQL Server
Are there any plans to add support for full-text indexes in dbForge Studio 2022 for SQL Server as found in SSMS?
dbForge Studio for SQL Server on Manjaro
Hi, Did anyone try running dbForge Studio for SQL Server on Manjaro or any other Linux distro using CrossOver? Thanks, Tom
Color correction in import
I have two issues/question in Studio 2022 for SQL server. 1. Using "Visual Studio Blue" Skin, go to Data pump / Import external data / ODBC. In ODBC options, enter the necessary data, then go to "Destination". In there, when you select a table from Source
Issue with Devart.SSIS.Salesforce.SalesforceLookup
For the last couple of days we're receiving this errors when we tried to get data from salesforce. Could you please help us? Thanks a lot. Error Code: 0xC00490F7 Description: The managed pipeline component "Devart.SSIS.Salesforce.SalesforceLookup" could
SQL Complete - Is there a way using the formatter to ensure spaces exist between brackets in the where clause
Is there a way using the formatter to ensure spaces exist between brackets in the where clause? example: WHERE (Column1 = @Column1 Or Column1 > 0) would become WHERE ( Column1 = @Column1 Or Column1 > 0 )
Connect to Microsoft Analysis Services
Is it possible to connect to Microsoft Analysis Services using dbForge Studio? I'd like to use dbForge to query SQL data in Analysis Services
dbForge for SQL Server
Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server