Comments
Sort by recent activity
Hi chenchen300,
you cannot ignore the name of the objects in that way. How can you say that they are "the same thing"? / comments
Hi chenchen300,
you cannot ignore the name of the objects in that way. How can you say that they are "the same thing"?
Hi @...,
did you try to check into the Windows log via Event Viewer? If you cannot open the SQL Compare UI, you may not be able to enable the verbose logging, so you need to start from scratch. Check the Windows logs and let us know.
cheers / comments
Hi @...,
did you try to check into the Windows log via Event Viewer? If you cannot open the SQL Compare UI, you may not be able to enable the verbose logging, so you need to start from scratch. Che...
hi @Tianjiao_Li,
thanks for the mention. That is my blog and the link you're suggesting summarizes the usage of the project I've posted in my previous post.
so, Thanks :-) / comments
hi @Tianjiao_Li,
thanks for the mention. That is my blog and the link you're suggesting summarizes the usage of the project I've posted in my previous post.
so, Thanks :-)
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.
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.