Comments
Sort by recent activity
Hello,
You can configure custom comparison keys for each table to match rows based on specific columns, like using the role name rather than role id. Here's how you can set it up: 1. Open SQL Data Compare and set up your data sources for comparison. 2. In the "Tables & Views" mapping screen, locate the tables you want to compare. 3. For the table where you want to use a custom key (e.g., the "roles" table), click on the "Comparison Key" column next to the table name.
If SQL Data Compare hasn't automatically selected a comparison key, or if you want to change it, you can specify a custom comparison key.
Select the columns you want to use as the comparison key (e.g., the "role name" column).
By setting a custom comparison key, SQL Data Compare will match rows based on the specified columns, allowing you to synchronize data accurately even when using natural keys like role names instead of surrogate keys like role IDs.
/ comments
Hello,
You can configure custom comparison keys for each table to match rows based on specific columns, like using the role name rather than role id. Here's how you can set it up: 1. Open SQL Data...
I tried this under the latest update, 10.16.3 and the issue doesn't appear to be happening there. Can you try updating to the latest version and see if that alleviates the issue?
/ comments
I tried this under the latest update, 10.16.3 and the issue doesn't appear to be happening there. Can you try updating to the latest version and see if that alleviates the issue?
Hello, Do you know when this started happening? I have an older version (10.14.21) installed currently and did not see the same kind of issue. See screenshot below: [image] [image] [image] [image] / comments
Hello, Do you know when this started happening? I have an older version (10.14.21) installed currently and did not see the same kind of issue. See screenshot below:
Unfortunately, you're correct. There isn't currently a way to do this in Data Compare more efficiently. You can put in a feature request here if you'd like. / comments
Unfortunately, you're correct. There isn't currently a way to do this in Data Compare more efficiently. You can put in a feature request here if you'd like.
To look further into this, I'm going to need to see some logs. I'll respond via the ticket we have opened. / comments
To look further into this, I'm going to need to see some logs. I'll respond via the ticket we have opened.
Hello, When you say DR database, just to clarify, are you talking about the replicated database? I ask because we sometimes call our Data Repository database for Monitor a DR. Also, does the activity show on both or just the DR? I don't believe that the dtu vs vcore model would have any impact on this as that is just a billing model. Are there any other differences between the new database and the others? To diagnose further, I'd likely need to look into the logs to see what is happening. / comments
Hello, When you say DR database, just to clarify, are you talking about the replicated database? I ask because we sometimes call our Data Repository database for Monitor a DR. Also, does the activi...
Hi, You may be able to use the DeployPath variable as discussed in this article. / comments
Hi, You may be able to use the DeployPath variable as discussed in this article.
I would take a look at this article. The person was getting the same error when querying from their local machine to a remote server. / comments
I would take a look at this article. The person was getting the same error when querying from their local machine to a remote server.
Hi Adam, have you tried uninstalling and reinstalling SQL Prompt? / comments
Hi Adam, have you tried uninstalling and reinstalling SQL Prompt?
Hi, could you share what version of SQL Prompt you are using? I checked my own test environment and the menu item is available on version 10.14.21, which is an older version. I also updated to 10.14.23 and the bulk actions menu item is available. [image] [image] [image] [image] [image] / comments
Hi, could you share what version of SQL Prompt you are using? I checked my own test environment and the menu item is available on version 10.14.21, which is an older version. I also updated to 10.1...