Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sqlcompare]

9 questions
1
vote
2 answers

Need help in rewriting query

I have 2 databases test1 and test2. where I need to compare columns from schema1 to schema2 and fetch the results.If table in test1 schema not present on test2 schema ,it should ignore that table. I have below query which shows all the results…
Kulal
  • 11
  • 1
1
vote
1 answer

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 closest answer I've found, but it doesn't answer my…
Fandango68
  • 295
  • 2
  • 11
0
votes
1 answer

How to Do a Sub Query and JOIN for Comparison Report

Hi I was trying to do a Sub Query and Comparison Report For Example, I have a Table of Teams with Color AND Name in a Single Table. A person can be on more than one Team and Multiple Team Colors can exist in the table. CREATE TABLE [TEAMS]( …
user1207381
  • 101
  • 2
0
votes
2 answers

Compare two tables for discrepencies

I am trying to compare two tables in two separate databases (same instance) for a new data extract The tables have around 4 millions rows and due to how they've been extracted are not in the same order in each table, as they are just staging tables…
QueryQuirk
  • 3
  • 1
0
votes
2 answers

Oracle: Simple way to compare all objects of a schema in two databases?

I'm attempting to compare all objects of two schemas located in two different databases. I know there may be ways to do this with TOAD and SQL Developer, but is there another way to do this by script or Sql*Plus? Thanks in advance.
Phillip
  • 11
  • 2
  • 8
0
votes
1 answer

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 chk_FileTbl_MonthlyDate CHECK (MonthlyDate BETWEEN 1 AND…
SQLDoug
  • 247
  • 3
  • 7
0
votes
0 answers

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 working anymore because we use the…
Fatemeh Ramezani
  • 1
  • 1
0
votes
3 answers

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 Select b.team, SUM(c.total) FROM data2 C INNER…
Ary Maulana
  • 3
  • 1
-1
votes
1 answer

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.ps1 file set-location "C:\Program Files (x86)\Red…
l.lijith
  • 918
  • 4
  • 9
  • 27