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
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.
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
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
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?
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
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
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
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
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
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
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
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,
Next Page