Search found 5 matches

by nileshgupta
Tue Jun 12, 2018 6:13 pm
Forum: BH Backup Information
Topic: Tables Without Any Description
Replies: 0
Views: 5880

Tables Without Any Description

Hello BH, I can see there are a lot of tables without any information and multiple tables without any PK or any ID. Tables whose information is not present- - BOT - BOT Condition - BOT Department Association - BOT Execution History - BOT Outcome - BOT User Type Association Tables without any ID( PK)...
by nileshgupta
Mon May 21, 2018 7:43 pm
Forum: BH Backup Information
Topic: Job and Note table join
Replies: 0
Views: 5219

Job and Note table join

Hi All,

How job and notes table/package are linked? As while trying to retrieve information for job sendouts candidate ID and Candidate Name doesnt shows up. So I tried to make join on Job ID however it doesnt shows up. Could you please let me know what needs to be done to fix this?

Thank you.
by nileshgupta
Mon May 21, 2018 7:39 pm
Forum: BH Backup Information
Topic: BH SQL Database Merging
Replies: 4
Views: 3308

Re: BH SQL Database Merging

Hi Jake, Thank you so much for the reply. I'm trying to merge 2 BH databases only. One is incremental database and the other is complete database that we have purchased from BH. So it is two Bullhorn Databases. If you could please recommend what needs to be done, that would be highly appreciated Tha...
by nileshgupta
Tue May 08, 2018 2:54 pm
Forum: BH Backup Information
Topic: BH SQL Database Merging
Replies: 4
Views: 3308

Re: BH SQL Database Merging

Hello Jake, Thank you for the reply. I wanted to know why so many constraints are used and can we drop the constraints? Also I can see a candidate history table, I'm not sure why it is there and in order to merge one candidate table with other do I need to first merge with Candidate history first? i...
by nileshgupta
Thu May 03, 2018 5:04 pm
Forum: BH Backup Information
Topic: BH SQL Database Merging
Replies: 4
Views: 3308

BH SQL Database Merging

Hello BH Team,

While merging database Im facing problem, when I merge one BH SQL database to other BH SQL database, it creates problem. Please let me know what are all the tables which are interdependent(dependency) on each other.

Also why there are so many constraints used?

Thanks,
Nilesh