Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Enhancements

User login

Frontpage Sponsor

Main

Google search


Poll
What version of Baan have you installed
Baan IV
31%
FP3
4%
FP4
0%
FP5
0%
FP6
2%
FP7
4%
10.2 (incl. 10.2.1)
4%
10.3
6%
10.4
19%
10.5
28%
Other
2%
Total votes: 83

Baanboard at LinkedIn


Reference Content

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 15th May 2003, 04:40
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,043
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Check Table's Data Dictionary

We have had many issues with the bdbreconfig and I guess we customize heavily. We have code migrations every weekend and a Table/Domain migrations every 2 weeks.

Among the major issues with the bdbreconfig is that the actual change did not happen on the tables in certain companies. And we used to use some fake changes on the table to trick (also posted on the board here) the create/convert runtime sessions to make it work.

The session Check Table - ttaad4232m000 gives us only a top view of the problems with the 506-tables do not exists, 512-corrupted DD, 2017-wrong database login/password etc.

Hence, we developed this tool which checks the BaaN and Oracle Data Dictionaries across all the company in all the databases and gives a report.

It will be nice if there are any verification tools in the standard tools to do this process for Oracle/Informix, DB2 etc.
Attached Files
File Type: doc check-table-dd.doc (136.5 KB, 156 views)
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 06:38
What does Reorganize Tables do when you check Data and Indexex Joy Conner Tools Administration & Installation 3 13th August 2004 23:32


All times are GMT +2. The time now is 09:32.


©2001-2017 - Baanboard.com - Baanforums.com