Activity overview
Latest activity by BenKim
Can I get some information? We have 7 toolbelt licenses. Can we install SQL compare and SQL data compare on our servers (prod and non-prod) to run sql compare or sql data comare as a batch job on sql-agents? / comments
Can I get some information? We have 7 toolbelt licenses. Can we install SQL compare and SQL data compare on our servers (prod and non-prod) to run sql compare or sql data comare as a batch job on s...
Can I compare unique values only?
On version 15.Is it possible to compare unique values only?Currently, one side has duplicates. The other side does not. The duplicates show up as differences. But I have a case where it is desirabl...
Our team has 7 toolbelt licenses. Can we use that on our servers? Or, should we purchase a separate license for each service account? Thanks. / comments
Our team has 7 toolbelt licenses. Can we use that on our servers?Or, should we purchase a separate license for each service account?Thanks.
Thanks / comments
Thanks
How can I execute a sdc file as a sql agent job on a sql server?
I want to automate comparing data between two servers daily, and get a report of differences.Does anyone have experience with running a data compare as a sql agent job on a server?What kind of lice...
I don't think it is a good design, but I can live with it. Thanks. / comments
I don't think it is a good design, but I can live with it. Thanks.
Improvement
Hi, currently, whenever there is an update to sql compare and sql data compare, there is a popup banner at the top of the comparison screen, hiding the source and destination connections. Banner sa...
Can I make Sql prompt overwrite snippets with new definition.
Can I make Sql prompt overwrite snippets with new definition? I am on 10.12.4.29949.When I create a snippet with the same name, Sql prompt asks if I want to overwrite the old definition.I answer ye...
non-unique comparison key
Data compare tool says "add rows ... with non-unique comparison key" although I chose a key set that make each row unique. Key columns are all int. I don't have a constraint on either side.
Compar...
Run sqldatacompare on sql server as a job
What is needed to run sqldatacompare on sql server as a job?I can run a batch like
sqldatacompare /pr:MSTest.sdc /sync
Does anyone run this type of batch process as a scheduled job?We have ab...