Questions tagged [sqlcompare]
The sqlcompare tag has no usage guidance.
5
questions
0
votes
1answer
20 views
What is causing BETWEEN to be replaced with <= and >=?
We have a Visual Studio solution for our SQL Server 2019 database, and it is stored in a git repo. One table has a couple of check constraints using the BETWEEN operator, like this.
CONSTRAINT ...
0
votes
0answers
25 views
How to compare EF core code-first database with existing Azure Sql Server database
we have multi-tenants databases and we have special stored procedure to compare the structure of the tenents after each release. Now, we are moving to Azure SQL Server and the stored procedure is not ...
1
vote
1answer
93 views
How to compare and MERGE two SQL Server environments (not just databases)
Many similar questions were asked before, and mostly about comparing database schemas and data. That's all fine, but what about all the other SQL Server objects in the system overall?
This is the ...
0
votes
3answers
34 views
SQL Compare data from two joined tables
i used SQL Server, and have two joined table
Select b.team, SUM(a.total) FROM data1 A
INNER JOIN team b ON a.teamID = b.teamID
WHERE month = 1 and year = 2019
GROUP by team
second one is like this
...
-1
votes
1answer
186 views
Red gate SQL Compare error while running using SQL Agent Job
I created a SQL agent job to perform a SQL Compare using the below command line
powershell.exe -File D:\SQLCompareReports\DEVvsPRJ\DEVvsPRJ.ps1
This below given is the command line code in DEVvsPRJ....