> For the complete documentation index, see [llms.txt](https://dbi-services.gitbook.io/omrun-help/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dbi-services.gitbook.io/omrun-help/readme/release-notes/version-5.0.md).

# Version 5.0

## Version 5.0.1.40

### News

* OMrun release 5.0..x.x experienced a complete face lifting of the OMrun GUI as well as large enhancement on plug-in's.
* Major change and enhancement including many bug fixes.
* New look and feel (additional dark mode) and more stability; light colour style and better result visibility and readability.
* Test result presentation with enhanced statistical information on row and column level.
* Test result additional filter function, allowing to reduce the visible columns to key columns and columns with differences only.
* New symbols and colour on test result column headers for key and info fields.
* A new query only functionality ensuring to execute a simple query test data object without the comparison.
* New sophisticated Excel on demand reports.
* New XML plug-in component able to import almost any xml format.
* New data staging plugin, loading test results of an OMrun component and csv files automatically into an MS SQL Server database without effort.
* New plug-in to generate test data objects derived from the database schema to run a 1:1 compare on the whole database content.
* New plug-in to generate a test scenario object based on the generated test data objects to run all SQL-scripts needed to compare the whole database content.
* New plug-in to run a 1:1 database migration from MS SQL to PostgreSQL.
* New plug-in to run a 1:1 database migration from MySQL to Oracle.
* New plug-in to run a 1:1 database migration from Oracle to MySQL.
* New license model to reflect the detailed customer needs.
* Logs “reduced to the max” to get a better overview.
* Introduction of many new OMrun internal variables to make scripting even more generic.
* Many different generic use case standard templates for downloading, like pseudonymization, 1:1 database comparison, data migration and many more.
* Updated and modernized OMrun-help on web.

**Attention!** OMrunGuiProvider\_4.2.cfg / OMrunGuiProvider\_4.3.cfg needs to be deleted, new Parameter #OMrunEnvironment# and the Migration config is added.

**Precondition** :warning:

* .Net 4.8 (install always first)
* .Net 6.0.4

## Detailed Notes

### Tasks

* omrun#832\_RTB-should-delete-formation-of-text-when-pasted-in
* omrun#668\_right-click-functionality-should-be-standard-again-instead-of-the-overwritten-undo
* omrun#507\_Restrict-the-Data-Source-of-a-New-Test-Data-Object-to-the-Connections-in-the-Drop-down-list
* omrun#784\_close-omrun-after-license-key-deactivation
* omrun#97\_add-about-to-logging
* omrun#790\_soraco-log-missing
* omrun#827\_OMrun-closing-after-license-activation
* omrun#826\_Package\_Solution\_For\_JSON\_Dependence\_Files
* omrun#824\_Link\_OMrun\_EULA
* omrun#778\_Update\_Soraco\_To\_Newest\_Version
* omrun#783\_OMrun\_End\_User\_Agreement\_Missing
* omrun#822\_Help\_Add\_One\_Pager\_Offline\_Docu
* omrun#821\_BSS\_Wizzard\_Check\_Input\_On\_Next
* omrun#807\_Console\_Text\_Not\_Aligned
* omrun#800\_Enhance\_Log\_Msg
* omrun#798\_Adjust\_Look\_And\_Feel\_Of\_Soraco\_Windows\_To\_The\_OMrun\_Style
* omrun#796\_Simplify\_No\_Runtime\_Error\_Msg
* omrun#794\_Enhance\_Logging\_Of\_All\_Plugins
* omrun#791\_Enhance\_Log\_Msg\_On\_Cli\_License
* omrun#758\_Create\_Test\_Scenario\_Generator
* omrun#757\_CSV\_Converter\_Creates\_Unexpected\_Output
* omrun#751\_Fill\_TOB\_Data\_Set\_With\_Parameter
* omrun#749\_Add\_Compare\_Generator\_To\_Prog\_Adapter\_Config
* omrun#748\_Create\_Test\_Program\_Object\_Generator
* omrun#747\_Create\_Test\_Data\_Object
* omrun#746\_Create\_Component
* omrun#745\_Path\_Mismatch\_Reports\_Batch
* omrun#742\_Szenario\_Splitter\_Over\_Scrollbar
* omrun#741\_Missing\_Console\_Content\_In\_Plugins
* omrun#740\_Check\_Vs\_Environment\_Post\_Process
* omrun#739\_Missing\_Console\_Content\_In\_Datastaging
* omrun#738\_Missing\_Console\_Content\_In\_CSV
* omrun#719\_OMmig\_Does\_Not\_Migrate\_To\_Pg
* omrun#714\_Reduce\_Log\_File\_Content\_To\_Minimum
* omrun#713\_Implement\_Dynamic\_Query\_For\_Darkmode\_Part\_1
* omrun#711\_Update\_Copyright\_Year\_to\_2023
* omrun#710\_Add\_Internal\_Variable #OMrunBSS#
* omrun#707\_Result\_History\_Image\_&\_Label\_Are\_Not\_Positioned\_Correctly
* omrun#705\_Removing\_Colon\_From\_Result\_History\_Label
* omrun#704\_Make\_The\_Formsomrun\_Background\_Of\_The\_Forms\_Change\_Dynamically\_Depending\_On\_Selected
* omrun#702\_Selected\_Query\_Font\_Size\_Should\_Be\_Taken\_Over\_To\_A\_Newer\_OMrun\_Version\_Installation
* omrun#696\_Fix\_Naming\_Postgre\_To\_Postgres\_Or\_Postgre\_SQL
* omrun#695\_Resizing\_The\_Query\_Slider\_Causes\_Scroll\_Functionality\_To\_Disappear
* omrun#693\_SQL\_Pasted\_From\_Word\_Into\_Query\_Keeps\_Formation\_Of\_Word. (f.e: fontsize, fontstyle)
* omrun#692\_Improve\_Performance\_Of\_The\_Keyword\_Highlighting\_In\_The\_Querry\_Field
* omrun#689\_Create\_Packaging\_X64\_For\_.Net6.0 (integrated .net4.8 dashboard call into .net6 omrun application)
* omrun#688\_OMmigration\_Multiple\_Errors\_After\_.Net6\_Upgrade (system.data.oledb not installable with nuget, dll Assembly not working / configuration manager not upgradable to v6.0.0)
* omrun#683\_Implement\_New\_Logging\_Tool\_Into\_OMrun (.net6)
* omrun#682\_2\_Colums\_Should\_Show\_White\_Background\_In\_Dark\_Mode
* omrun#680\_Make\_The\_Forms\_OMrun\_Background\_Of\_The\_Forms\_Change\_Dynamically\_Depending\_On\_Selected\_Colormode
* omrun#679\_Datastaging\_Performance\_Optimization\_Add\_Direct\_CSV\_Load\_And\_Refactor\_TOB\_Load
* omrun#676\_OMrun\_To\_.net\_6.0\_Upgrade
* omrun#648\_Add\_Internal\_Variables
* omrun#634\_Missing\_Logo\_On\_Forms\_Create\_New\_Project\_Wizard
* omrun#461\_Highlight\_All\_Parts\_Of\_SQL\_Syntax\_In\_Query\_Fields
* omrun#172\_Reminder\_For\_License\_Expiery\_Date
* omrun#168\_Add\_Environment\_Variables\_During\_Installation
* omrun#148\_Resizing\_Font\_Size
* omrun#136\_Check\_Dependences\_Of\_OMrun\_4.0\_To\_OMgenerator
* omrun#107\_Implement\_Shortcutsom
* omrun#98\_Refresh\_License\_Key\_After\_Entering

### Bugs

* omrun#844\_Plugin-Program-does-not-pass-Parameters-correctly
* omrun#842\_Row-counter-of-DataStaging-shows-incorrect-number
* omrun#843\_DataStaging-stopps-when-any-Field-contains-CR-LF
* omrun#841\_DataStaging-does-not-properly-handle-double-quotes
* omrun#840\_Pasting-text-into-query-field-inserts-text-always-at-the-end
* omrun#830\_XML-And-Json-Adapter-Allways-Pass
* omrun#838\_ctr+z-on-query-b-does-undo-on-query-a
* omrun#831\_undo-deletes-sql-Highlighting
* omrun#825\_OMrun\_does\_not\_start
* omrun#787\_remove-omrun-version-number-in-licence-wizard
* omrun#819\_Link\_To\_Help\_Is\_Hardcoded
* omrun#818\_Bss\_Wizzard\_Checks\_Field\_Content\_Too\_Early
* omrun#817\_Crossover\_Definition\_Between\_Local\_Global\_Env\_Not\_Working
* omrun#813\_Button\_About\_Fails\_Without\_Internet\_Connection
* omrun#811\_Feature\_License\_Check\_Not\_Working\_After\_Soraco\_Reimplementation
* omrun#810\_Online\_Activation\_Not\_Working\_After\_Rreimplementation\_Of\_Soraco
* omrun#809\_RTL\_First\_ResultHistory\_Selection\_Always\_Empty
* omrun#806\_Typo\_In\_Popup\_Win
* omrun#803\_After\_App\_Start\_Export\_To\_Excel\_Wrongly\_Activated
* omrun#802\_RTL\_Result\_Export\_To\_Excel\_Inactivated
* omrun#799\_TSC\_Result\_Export\_To\_Excel\_Inactivated
* omrun#797\_License\_Without\_Runtime\_Can\_Execute\_OMrun\_Cli
* omrun#795\_Runtime\_Execution\_Does\_Not\_Work
* omrun#792\_No\_Deactivation\_Of\_Cli\_License
* omrun#785\_License\_Offline\_Activation\_Does\_Not\_Work
* omrun#770\_Sort\_Flag\_Wrong
* omrun#768\_Creating\_Excel\_Manually\_Not\_Working
* omrun#757\_CSV\_Converter\_Creates\_Unexpected\_Output
* omrun#756\_Remove\_Datacrawler\_On\_Program\_Adapter\_Config
* omrun#745\_Path\_Mismatch\_Reports\_Batch
* omrun#743\_Missing\_Console\_Content\_In\_Program\_Object
* omrun#742\_Scenario\_Splitter\_Over\_Scrollbar
* omrun#737\_Dependency\_Fail
* omrun#736\_BSS\_Wizzard\_Save\_Later
* omrun#735\_Initial\_State\_If\_BSS\_Nok
* omrun#734\_BSS\_Wizzard\_Mandatory\_Fields
* omrun#731\_Breadcrumb\_Icons\_And\_Text\_Not\_Aligned
* omrun#719\_OMmig\_Does\_Not\_Migrate\_To\_Pg
* omrun#718\_Error\_If\_Object\_To\_Be\_Opened\_Has\_Object\_Name\_Editor\_Activated
* omrun#717\_Create\_New\_Search\_Icon\_Fitting\_Dark\_Mode
* omrun#714\_Reduce\_Log\_File\_Content\_To\_Minimum
* omrun#712\_Check\_If\_Dark\_Query\_Is\_Possible
* omrun#710\_Add\_Internal\_Variable #OMrunBSS#
* omrun#708\_Refresh\_Of\_Current\_Result\_History\_Row\_Color\_On\_Next\_Tab\_Refresh\_Only (tsc)
* omrun#707\_Result\_History\_Image\_&\_Label\_Are\_Not\_Positioned\_Correctly
* omrun#704\_Query\_Color\_Of\_Aliases\_Sometimes\_Partly\_Changed
* omrun#701\_Strange\_Logging\_By\_?
* omrun#700\_Selection\_Of\_Text\_Elements\_In\_Query\_Not\_Possible
* omrun#699\_Vertical\_Scroll\_Bar\_Of\_Result\_History\_Does\_Not\_Appear
* omrun#697\_Global\_Environment\_Auto\_Scroll\_Bar\_Does\_Not\_Work
* omrun#695\_Datastaging\_Missing\_Rows\_From\_TOR\_File
* omrun#688\_Dot\_Net\_6.0\_Migration\_Errors
* omrun#669\_Resizing\_The\_Query\_Slider\_Causes\_Scroll\_Functionality\_To\_Disappear
* omrun#667\_Fix\_Create\_New\_Project\_Wizard\_To\_Not\_Allow\_Maximizing\_Window
* omrun#531\_Scroll\_Bar\_On\_Query\_Missing\_After\_Slider\_Moving\_Down\_Up
* omrun#398\_Scenario\_Column\_Test\_Object\_Does\_Not\_Take\_Enough\_Column\_Space

### Non\_listed Bugs / Tasks

* Null\_Pointer\_Exception\_Timing\_Case\_During\_Result\_Percentage\_Double\_Click
* Data\_Crawler\_Plugin\_Deleted (decommissioned)
* Embedded\_Debug\_Symbols\_For\_All\_Projects
* Create\_Default\_Folder\_Structure\_With\_Example\_BSS\_On\_New\_Projects
* Selected\_Proper\_Managed\_Data\_Access\_Adapter\_For\_Oracle\_Data\_Bases
* Tree\_Environment\_Showing\_Global\_Environment\_On\_Tree\_Is\_Wrong
* Starting\_OMrun\_Latest\_BSS\_On\_Root\_Level\_Causes\_A\_Fatal\_Error
* Background\_Color\_On\_New\_From\_For\_LightMode\_Wrong\_Color
* Formating\_Changes\_On\_New\_Project\_Wizzard
* Issue\_With\_Query\_Color\_And\_Generate\_Button\_Activation
* Stabilized\_GUI\_With\_Null\_Pointer\_Check\_If\_Scrolling\_In\_Query
* Extraction\_Of\_Param\_In\_EnvVar\_Integrated

### General

* Packaging\_Updated\_To\_.Net6.0\_Platform\_Added\_New\_File\_Version\_Of\_Config\_Data/Prog\_Adapter
* Updated OMrun help link <https://dbi-services.gitbook.io/omrun-help/>