hello all
I desperately need some help with Perl! I am very new to this programming language, never practiced it before, however where I work I have to write a program that does the following:
There are two very large databases one is done on Oracle, the other in SQL server. The overall aim is to report the differences of certain fields in the databases. They are both meant to contain similar (if not) the same information but ofcourse the field names may not necessarily be written in the exact same words. The idea later on is to use this kind of report to possibly synchronize the databases, but that is well down the track. Currently, the only thing that is required is to report the differences on a small number of fields (5 of them). The report generation is to be done automatically and to be put in an output file preferably and excel spreadsheet or text file. This is then to be emailed automatically to the appropriate team... At this stage I have worked out the SQL statement that is to be used to extract this information from both databases, also how to connect to both the database, but in order to write a program like this, where do i start? what do i incorporate? what are the main things to consider? And in what order? I am very lost..
I also found this piece of code that I can use as basis to do mine. I believe this code (from my limited perl understanding) extracts the data and updates the DB. I am only meant to be extracting data from the 'LES' and 'Twenty' databases and find the differences. From what I have been informed that the term 'point_to_twenty' is the old term for 'LES'. Also i think this code is only concerned with the 'LES' DB. I am very confused... Here is the code below, thank you in advance
<MODERATOR moved code to attachment.>