Comments
Sort by recent activity
Hey @scalderon,
I started to write a PoSh script described here. As you can see, you can automate the link using working folder. I'd love to get the git version of the tool, would you like to make some change to my open project? It's also on MVP open projects here.
Feel free to contact me :-)
cheers / comments
Hey @scalderon,
I started to write a PoSh script described here. As you can see, you can automate the link using working folder. I'd love to get the git version of the tool, would you like to make ...
hi Frangooch,
try this guide. However, you can enable it pressing the intellisense button into SSMS [image] / comments
hi Frangooch,
try this guide. However, you can enable it pressing the intellisense button into SSMS
hi @nirms,
data compare will generate the diff script (and will execute it if you wish) without any schema change. / comments
hi @nirms,
data compare will generate the diff script (and will execute it if you wish) without any schema change.
If I got it correctly, you're speaking about me!!
if so, cool, thank you! / comments
If I got it correctly, you're speaking about me!!
if so, cool, thank you!
Hey @AnnabelB
we've organised DevOpsHeroes, and we will speak also about DLM Automation (on-prem and cloud) too. We're proud to have with us Martin Woodward (from MS) and to share real scenarios (HP Enterprise point of view and Upgrade, another company from Italy, which uses DevOps in production). I will present the case study of my own company about Source controlling the database, checking the drifts, using VSTS with DLM Automation in the cloud.
that's all for now :-) / comments
Hey @AnnabelB
we've organised DevOpsHeroes, and we will speak also about DLM Automation (on-prem and cloud) too. We're proud to have with us Martin Woodward (from MS) and to share real scenarios (H...
Got it, typical problem, isn't it? I can understand you :-)
Actually, it's really simple to "rewrite" them all. You could script only the stored procedures in one file, then, replace the full qualified name with the synonym. For creating the synonyms, you can extract with a regexp the fully qualified names and generate the CREATE SYNONYM script.
If you figure out how to match the strings, it will be simple, don't you think? / comments
Got it, typical problem, isn't it? I can understand you :-)
Actually, it's really simple to "rewrite" them all. You could script only the stored procedures in one file, then, replace the full quali...
Hi @MrBaas,
my reply is related to a certain SQL Server object. I've been in the same trouble years ago, and now the solution is still working. Would you try to use SYNONYMS instead a fully qualified name when calling "external" databases? The compilation of the stored procedures should use the deferred name resolution.
Hope I've got it correctly.
Let us know :-) / comments
Hi @MrBaas,
my reply is related to a certain SQL Server object. I've been in the same trouble years ago, and now the solution is still working. Would you try to use SYNONYMS instead a fully qualifi...
SQL Compare is an helper for deployment. It generates diff scripts, it doesn't mark the "version" of the release and it doesn't allows you to link the changesets. Since you're using TFS, you could comment a changeset in order to know if it's ready for deployment, but if you want to know the information release by release, you should use a combination of a build server and a release management tool.
Take a look here, DLM Automation. You can use also the Release Management tool in TFS. / comments
SQL Compare is an helper for deployment. It generates diff scripts, it doesn't mark the "version" of the release and it doesn't allows you to link the changesets. Since you're using TFS, you could ...
Hi SKIT,
if you're not using any tool for deployment, SQL Source Control is not related to this task. You can understand the version and the drift using DLM Dashboard. / comments
Hi SKIT,
if you're not using any tool for deployment, SQL Source Control is not related to this task. You can understand the version and the drift using DLM Dashboard.
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...