User profile for DanC

Hi @friedrich_eberharter Would you be able to provide the syntax for the object you're creating? Using the example here I'm having no issues: https://learn.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-sample?view=sql-server-ver16 / comments

Hi @friedrich_eberharter Would you be able to provide the syntax for the object you're creating?Using the example here I'm having no issues: https://learn.microsoft.com/en-us/sql/relational-databas...

0 votes

Hi @RomekAtomek If you have SQL Compare installed, you can do a comparison using your live database and the scripts' folder that is your local repository. This may then give you an insight into the object causing trouble. If that doesn't help, we may need a copy of the database to troubleshoot / comments

Hi @RomekAtomek If you have SQL Compare installed, you can do a comparison using your live database and the scripts' folder that is your local repository. This may then give you an insight into the...

0 votes

Hi, Are you asking how to generate a deployment script which will ignore constraints and indexes? If that's the case, you can make use of the SQL Compare Options https://documentation.red-gate.com/sc/using-the-command-line/options-used-in-the-command-line For example there's Ignore system named constraint and index names Ignore indexes Ignore constraint and index names / comments

Hi,Are you asking how to generate a deployment script which will ignore constraints and indexes?If that's the case, you can make use of the SQL Compare Optionshttps://documentation.red-gate.com/sc/...

0 votes

Hi @depropiru Have you tried with the latest version of SQL Compare 15? https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_15.3.12.27078.exe / comments

Hi @depropiru Have you tried with the latest version of SQL Compare 15?https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_15.3.12.27078.exe

0 votes

Hi @jmbelina Thank you for the quick reply with an example, and don't worry about the formatting! I'm going to pass this along to the developers and get their thoughts on the issue, and I'll provide you with an update once I have one. / comments

Hi @jmbelina Thank you for the quick reply with an example, and don't worry about the formatting!I'm going to pass this along to the developers and get their thoughts on the issue, and I'll provide...

0 votes

Hi @jmbelina Do you have an example case of this, with some code for me to create the necessary objects to reproduce? / comments

Hi @jmbelina Do you have an example case of this, with some code for me to create the necessary objects to reproduce?

0 votes

Hi @jmbelina Whilst the developers recognize this as a bug, due to their current workload and priorities they're unfortunately unable to work on it. / comments

Hi @jmbelina Whilst the developers recognize this as a bug, due to their current workload and priorities they're unfortunately unable to work on it.

0 votes

Hi AlexTs There are no plans for Git to be supported in a shared environment, and this is the rationale: Our database development team is Alix and Bob. Alix and Bob develop against a single, shared database. They use SQL Source Control to commit their changes. They use git as their VCS. Like a lot of git users, they have a central repo (stored on github), and local clones of those databases. Alix adds NewTable_1 to the development database. At this point, both Alix and Bob are in the same state: • A new table is in their database • It isn’t in their local git repo (i.e. will be on SOC’s commit tab) • It isn’t on github Since she’s a clever one, Alix immediately commits that change to her local repo. Now they diverge: • A table is in the database for everyone • It shows as uncommitted for Bob, but committed for Alix. This is different to shared model for SVN, Vault and TFS. • It isn’t on github Let’s say that Alix is super-disciplined and she pushes that change to github right away. Where are we now? • A table is still in the database for everyone • It still shows as uncommitted for Bob, but committed for Alix • The table is on github, but Bob still has no idea about that So what does Bob have to do? How does he get back in sync? Well, there are options.He could commit Alix’s NewTable_1 himself. That makes things look the same on the commit tab in SOC. But that actually means that he and Alix have different git commits with the same content. That’s an easy way to get merge conflicts*, and could prevent him pushing his changes to github. He arguably should pull Alix’s changes from github to get his local git repo in-sync**. Pulling is an action you do on the ‘Get Latest’ tab, which is considered all-but-redundant when using the Shared model. Once you need to perform that pull step, the behaviour of Shared and dedicated model are really very similar. So that’s the important difference: • Distributed git repositories mean that, even if the database is centralised and shared, users will often need to coordinate their repositories by both pushing and pulling (steps not used in any other VCS that SOC supports) • Attempting to manually synchronise local repositories by duplicating commits can easily lead to merge conflicts • For people to synchronise local repos without leaving Management Studio (or SOC, at least), they need to use the Get Latest tab for clarity, this simple example may not actually result in a merge conflict, but it’s an intentionally trivial example ** when he pulls, his git repo will get Alix’s committed copy of NewTable_1. SOC will see that’s the same as the database version, NoOp it and everything will be right with the world. If after reading the above you still want to use the shared mode, there is a workaround you can use, which is to set git using a custom configuration file. / comments

Hi AlexTs There are no plans for Git to be supported in a shared environment, and this is the rationale: Our database development team is Alix and Bob.Alix and Bob develop against a single, shared ...

0 votes

Hi @jboyer Could you please elaborate on what you're trying to achieve? / comments

Hi @jboyer Could you please elaborate on what you're trying to achieve?

0 votes

Hi @Sean_Lively Unfortunately, it's not possible to skip the shadow database verification step entirely, however, you can exclude specific objects: https://documentation.red-gate.com/sca/developing-databases/concepts/verifying-projects/excluding-objects-from-script-verification / comments

Hi @Sean_Lively Unfortunately, it's not possible to skip the shadow database verification step entirely, however, you can exclude specific objects: https://documentation.red-gate.com/sca/developing...

0 votes

How can we help you today?

DanC

Comments