Comments
Sort by recent activity
I found the issue! and it was a PICNIC ( problem in chair not in computer). Someone decided to change the spelling of these 2 databases to plural instead of single, which I didn't noticed on the GUI when selecting the databases, so the script was trying to connect to a non-existent database. Please disregards this posting ( delete it if you can to protect the innocents [image] ) / comments
I found the issue! and it was a PICNIC ( problem in chair not in computer).Someone decided to change the spelling of these 2 databases to plural instead of single, which I didn't noticed on the GUI...
Jon, As stated originally, I'm using Windows Authentication, I have SysAdmin rights to the server/instance, I can access the database using windows authentication from SSMS and with SQL Compare GUI, but not from the command line. the scripts I'm running look like this SQLCompare.exe /s1:"server1" /db1:mydatabase /s2:server2 /db2:mydatabase /filter:C:\workshop\script\TablesUDT.scpf /ScriptFile:"C:\Workshop\Script\HmgLakeTablesUTDUpdate.sql"
I'm running compares for 11 databases, 3 times each using different filters. of the 11 database 2 give me error mentioned above, regardless of the filter they are running with. Any suggestions are welcome Thanks, Mario Hernandez / comments
Jon,As stated originally, I'm using Windows Authentication, I have SysAdmin rights to the server/instance, I can access the database using windows authentication from SSMS and with SQL Compare GUI,...