Community
Showing results for 
Search instead for 
Do you mean 
Reply

compare databases

New Member
Posts: 6
Country: USA

compare databases

Is there a way to compare two separate databases to see what duplicates there are that appear in both?  I know ACT can scan for dups within a single database but I need to copmpare 2 separate one.  I believe this was available in an older version. I am using ACT 2007. Thanks.
Copper Contributor
Posts: 172
Country: USA

Re: compare databases

Im not sure if that is a feature - though I have done this sort of filtering with 2 databases... first I exported them as a cvs then did the filtering in excel

 

Hope this helps

 

Copper Super Contributor
Posts: 128
Country: USA

Re: compare databases

this maybe off the beaten path a bit but i am comparing csv files`

before and after changes are made

whats the best tool for comparing csv/excel  sheet  maybe somthing that will generate difference report

i viewed some of the import/export add-ons but way out of my price range

 

short of placing the excel sheets side by side wanted to know what people are using

 

thanks inadvance

server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide