Activity overview
Latest activity by thom.bolin
Thanks for the edit. kdupree is an user in the db1 database that does not exist in db2 database. She has been granted permissions but I don't sync ids. The permissions could be ignored to make the issue go away but if an error occurs I need the failure recorded.
i'm running the compares using my id tpbolin. / comments
Thanks for the edit. kdupree is an user in the db1 database that does not exist in db2 database. She has been granted permissions but I don't sync ids. The permissions could be ignored to make t...
Below are the contents of the file:
C:\Temp>type mkdb2_pmf.txt
Serial Number: 507-005-******-****
Registering data sources
Creating mappings
Comparing
Applying Command Line Items
Creating SQL
Synchronizing databases (from DB1 to DB2)
Error: Synchronization of 'mkdb2.PMF' and 'mcktorcdev09\rgdb2.PMF' failed: Windows NT user or group
'TORCHMARKCORP\KDUPREE' not found. Check the name again.
C:\Temp>
If you would like to could send you snaps of both databases. / comments
Below are the contents of the file:
C:\Temp>type mkdb2_pmf.txt
Serial Number: 507-005-******-****
Registering data sources
Creating mappings
Comparing
Applying Command Line Items
Creating SQL
Synch...
Error on command line sync but no error returned
I am using an SSIS package and a table that holds target and source database information. This information is read and the command line of SQLcompare 8 is called and passed in a some parameters. i...
the owners in both databases are the same, but neither is dbo. Is there a work around/fix for this issue.
I can attach the output comparision if needed. / comments
the owners in both databases are the same, but neither is dbo. Is there a work around/fix for this issue.
I can attach the output comparision if needed.
Sorry Anu,
Got sidetracked onto some other projects and just now returning to this issue. The owners are the same in both databases, however when I compare the databases they show are different.
I can upload the actual compare output if that would assist. / comments
Sorry Anu,
Got sidetracked onto some other projects and just now returning to this issue. The owners are the same in both databases, however when I compare the databases they show are different.
I...
Non DBO Owner objects always show as different
I am running SQLCompare 8.2.1.50. When I compare two databases that have object owners other than DBO the objects show up in both of the only exists windows.
The owners are listed correctly in the...
Next Button on Synchronization Screen does not work
I am using SQLCompare 8, after I compare two databases and select Synchronization Wizard, the wizard pops up, but will not proceed when I hit next. It works in other cases but with the current pro...
SQL Changeset with SQL Compare 8.0
I am setting up SQL Changeset with our VSS environment. When I compare the live database to the scripts I get objects that do not exist in the scripts and objects that do not exist in the live dat...