Comments
Sort by recent activity
Hi @RitaR,
SQL Compare does the ddl comparison (CREATE TABLE, PROCEDURE, FUNCTION, and so on). This means that the generated script involves only the structures, not data. If you want to compare data, you've to use SQL Data Compare.
That said, you're speaking bout "static data" which is the term used by SQL Source Control for "linked" records. This tool allows you to store into your version control also the INSERT of the data of tables, but it is separated from the comparison tools concepts. They should be used both for comparing structures and data, but they don't depend on how your SQL Source Control is set.
If your goal is to "deploy" the artifacts created by SQL Source Control, you've to use DLM Automation tool or to create a nuget package (that could be used in deployment tools) / comments
Hi @RitaR,
SQL Compare does the ddl comparison (CREATE TABLE, PROCEDURE, FUNCTION, and so on). This means that the generated script involves only the structures, not data. If you want to compare da...
Hi,
Could you please tell us how did you link the database with SQL Source control? Did you link it using the "Link database to Source Control" option? If so, and you're receiving errors, I think that it should work following these steps:
1. create database using the script (not checkin in into the SQL Source Control folder)
2. linking using the "Link to Source Control" (to git) using Sql Server Management Studio
after these two options, everything should work.
I'm a little bit confused about the Databases\OnlineBanking\_Initialization\ folder, which should not be part of the working base folder.
In this link, there's how SQL Source Control works behind the scenes.
Sorry if I didn't get it. / comments
Hi,
Could you please tell us how did you link the database with SQL Source control? Did you link it using the "Link database to Source Control" option? If so, and you're receiving errors, I think t...
Hi @Elizabeth_Close_M1st,
can you try to send the error details? If you get a view with an error string, you get also a hyperlink with the error description. / comments
Hi @Elizabeth_Close_M1st,
can you try to send the error details? If you get a view with an error string, you get also a hyperlink with the error description.
Hi @Pat,
are you speaking about SQL Source Control and git versioning? When you save the objects, you will see in uncommitted status using git/team explorer. Are you thinking about a tab into SSMS before sending objects to git? You've already the Push/Pull button right now.
Did I get it? / comments
Hi @Pat,
are you speaking about SQL Source Control and git versioning? When you save the objects, you will see in uncommitted status using git/team explorer. Are you thinking about a tab into SSMS ...
Did you try to follow the other options? Like using online licenses manager?
[...]
1. The license administrator logs in to their account on the Redgate website.
2. On the My Products summary page, click on the product or serial you want to deactivate.
3. On the product detail page the list of identified users is displayed:
[...] / comments
Did you try to follow the other options? Like using online licenses manager?
[...]
1. The license administrator logs in to their account on the Redgate website.
2. On the My Products summary page, ...
Hi @hrudy,
please read here.
In order to deactivate the serials, You can use the tool inside the documentation link.
hope this helps / comments
Hi @hrudy,
please read here.
In order to deactivate the serials, You can use the tool inside the documentation link.
hope this helps
Hi Kazoo60,
are you trying to do so in a default instance SQL Server installation or a named one? In case of named instance, you've to enter (local)\INSTANCENAME. You could try also "." instead of "(local)".
Please try and let us know ;-) / comments
Hi Kazoo60,
are you trying to do so in a default instance SQL Server installation or a named one? In case of named instance, you've to enter (local)\INSTANCENAME. You could try also "." instead of ...
Hi GregDodd,
I know that it could be just a workaround, but you can try to change the tab size. / comments
Hi GregDodd,
I know that it could be just a workaround, but you can try to change the tab size.
hi @itzikpaz,
If I remember right, there is no option in SQL Compare to do so.
I've found this idea in uservoice: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/6014210-ignore-final-semicolons-when-comparing-stored-proc. You can try to upvote. / comments
hi @itzikpaz,
If I remember right, there is no option in SQL Compare to do so.
I've found this idea in uservoice: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/6014210-ignore-...
Not right now, but you can upvote for adding the feature. / comments
Not right now, but you can upvote for adding the feature.