Home

DB Comparer for Interbase/Firebird

1. Asis Edit Template Uppercase Delele Template F D Lowercase C First upper Expansion Add Template Pal Edit Template F2 SSSSSS88 Delele Template Del S S S S If necessary you can also edit the template name using the Edit Template button delete the template using the Delete Template button or edit the template expression within the Expansion area of the window For faster editing you can use the Sym bols menu and the Author Time Date buttons See also Environment Options Editor Options Visual Options 1999 2015 EMS Database Management Solutions Ltd no DB Comparer for Interbase Firebird User s Manual 8 Console application Additionally to the GUI version which is implemented in the form of a windows application the installation package of DB Comparer for Interbase Firebird includes the console version which is intended for being run from Windows command line with a project file name used as the execution parameter DB Comparer command line utility is intended for quick and powerful metadata comparison synchronization of Interbase Firebird databases Using the console application See also Getting started Managing Projects Working with Project SQL Script Editor Reports management DB Comparer Options 1999 2015 EMS Database Management Solutions Ltd m DB Comparer for Interbase Firebird User s Manual 8 1 Using console DB Comparer All t
2. The option has the highest priority for the tab controls If this option is selected the tabs are painted according to the native Windows style regardless of other painting settings Note The Native style option is currently supported for the Windows XP operating system only See also Bars and menus Trees and lists Edit controls Check boxes Buttons Group boxes Splitters 7 3 7 Group boxes Use the Group boxes section of the Visual options dialog to customize all DB Comparer group boxes to your liking 1999 2015 EMS Database Management Solutions Ltd 10 DB Comparer for Interbase Firebird User s Manual Visual Options x Scheme name Office 11 style Save As Delete sau Bars and menus fa Trees and lists Border style Edit controls Ultraflat M Check boxes Shadow Buttons ES Page controls 4 Native style Co Group boxes 4 gt Splitters Sample group Sample check box 1 Sample check box 2 C erce et Border style This setting determines the manner in which group box borders are painted Use the drop down list to select the painting style that will be applied to the group boxes None Single Thick Flat 3D UltraFlat W Shadow If this option is selected a shadow is displayed for the group boxes W Native style This option determines whether the native Windows style will be applied to the group boxes The option has the highest priori
3. Check this option if you wish to be prompted before replacing upon each occurrence of the search string When this option is off the search string is replaced automatically 1999 2015 EMS Database Management Solutions Ltd 117 DB Comparer for Interbase Firebird User s Manual Replace Text Text to find Employee afa Text to replace Employee_Address Options Direction Case sensitive F Whole words only Forward Regular expressions Backward Prompt on replace a Scope Origin Global From cursor Selected text Entire scope Mark search result with stack marker a Game Gee Ge Direction Forward Searches and replaces from the current position to the end of the SQL Script Editor area Backward Searches and replaces from the current position to the beginning of the SQL Script Editor area Scope Global Searches and replaces within the entire SQL Script Editor working area in the direction specified by the Direction setting Selected text Searches and replaces only within the currently selected text in the direction specified by the Direction setting You can use the mouse or block commands to select a block of text Origin From cursor The search and replace process starts at the cursor s current position and then proceeds either forward to the end of the scope or backward to the beginning of the scope depending on the Direction setting Entire scope Th
4. S He e CUSTOMER VIEW Miss H Ah PHONE_LIST Missed Procedures 2 Only target 4 4A Views 2 Procedures 2 ee 5 Missed ee ET Missed Ee Identical 31 H Domains 15 a Tables 8 H8 Procedures 1 B Exceptions 5 ui Generators 2 CUST_NO_GEN CUST_NO_GEN S S 9S 9 S S S S S S S S S S S To refresh the Database Tree use the corresponding lal Refresh button on the toolbar or press Ctr F5 To refresh a selected group of objects only right click the node and select the corresponding context menu item e g Refresh tables if you want to refresh the Tables group See also Viewing Summary Info Viewing Objects Definition Information window Working with Modification Scripts Switching windows 1999 2015 EMS Database Management Solutions Ltd sa DB Comparer for Interbase Firebird User s Manual 4 2 Viewing Objects Definition The Source Object Definition and the Target Object Definition windows contain the DDL structure Data Definition Language of the source and target database objects This area is read only hence you cannot modify object definitions using Object Definition windows You can synchronize scrolling of the contents in both windows i e when you scroll through one DDL text the other scroll bar moves synchronously using the Synchroni
5. V Find text at cursor If this option is checked the Text to find field in the Find Text and the Replace Text dialog windows is automatically filled with the text the cursor is set over W Always show hyperlinks If this option is checked hyperlinks are displayed in the editor window To open a link 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual click it with the Ctrl key pressed W Show line numbers If this option is checked the line numbers are displayed in the SQL editor area W Use smart tabs If this option is checked the tab length is variable After pressing the Tab key the cursor aligns with the nearest first or last position of the neighboring line Display Col ae Code Auto indent Insert mode Editor options J Use syntax highlight Find text at cursor Always show hyperlinks Show line numbers Use smart tabs Tab stops 4 Undo limit 50 Tab Stops Defines the tab length used when editing SOL text Undo Limit Defines the maximum number of changes that can be undone See also Display Color Quick Code 1999 2015 EMS Database Management Solutions Ltd s DB Comparer for Interbase Firebird User s Manual 7 2 2 Display Visible right margin Makes the right text margin visible W Visible gutter Makes the gutter visible in the editor window Right margin Defines the position of the right tex
6. a Progress Done 10 04 29 10 04 29 10 04 29 10 04 29 10 04 29 10 04 29 10 04 29 10 04 29 10 04 29 10 04 29 Processing of renamed objects Comparing objects Databases Comparing objects Domains Comparing objects Tables Comparing objects Views Comparing objects Procedures Comparing objects Exceptions Comparing objects Generators Creating list of synchronization scripts Done Close progress dialog after successful completion Close Note The comparing process cannot be stopped if renamed objects were found If the W Show summary after comparing option is selected in the Confirmations section of the Environment Options dialog the Summary Info window appears upon completion of the comparing process This window contains information concerning the differences between the compared databases 1999 2015 EMS Database Management Solutions Ltd a DB Comparer for Interbase Firebird User s Manual General information Total count 141 Different count 5 Unique master 57 Unique target 79 Identical count 0 Information by types of objects Domains total 18 different 1 master 15 target 2 equal 0 Tables total 31 different 1 master 15 target 15 equal 0 Views total 5 different 2 master 3 target 0 equal 0 Procedures total 32 different 0 master 11 target 21 equal 0 UD
7. Ce a ae a zi ReportData a Q EE DialogPage1 Ti lt m EG we c ReportData TfrxMasterDat v e T geep 7 j Properties Events I Dataset _ifferenceot 7 A Description 3 Ah z a Font TFont lt DifferenceObjects Object DifferenceObjects Obje v DifferenceO g FooterAftere False EZ Property Nam G Height 0 60 Jo poa j E source Value z KeepChild False a a i E Target Value KeepFooter False F i Ena Gill keepHeader CFalse j SummaryInfo Py KeepTogethe _ False i E Element Left all he E Count Name ReportDati PageFooter PageFooter 1 x a Only Source OutlineText eas J E a E only target ParentFont V True 7 Created on Date E Different PrintChild fin 0 False _ 4 4 E Identical ary inde i i Left m r The left coordinate of the 2 lt gt jobject Create field Ho m T7 Create caption Centimeters IE 21 00 0 60 ReportData DifferenceObjects y Viewing the report To preview the newly created report select the Project Preview main menu item or use the corresponding l Preview toolbar button You can also use the Ctrl P shortcut for the same purpose This mode allows you to view edit and print the result report To print the report use the G Print toolbar button or the corresponding context menu item 1999 2015 EMS Database Management Solutions Ltd e DB Comparer for Interbase Firebird User s Manu
8. DB Comparer for Interbase Firebird User s Manual See also Creating Project Compare Project Wizard Viewing Summary Info 1999 2015 EMS Database Management Solutions Ltd 3 DB Comparer for Interbase Firebird User s Manual 3 3 Compare Project Wizard The way of setting project options and comparison settings when creating or editing a project is to use Compare Project Wizard To create a new project using Compare Project Wizard select the Project I New Project main menu item or use the New Project button on the toolbar you can also use the Ctri Alt N shortcut for the same purpose To open an existing DB Comparer project select the Project Open Project main menu item or use the f Open Project button on the toolbar Alternatively you can use the Ctri O shortcut for the same purpose When the comparison process is finished the project will loaded into the DB Comparer application automatically and you will be able to start working with the project Wizard steps Setting database options Setting compare options Select objects for compare Renamed objects See also Creating Project Openin Saving Project Viewing Summary Info 3 3 1 Setting database options Database connection properties for the source and target databases are set in the same way If both the source and target databases are located on the same server you can check the Both databases on the same server option and set all the prope
9. EICREATE PROCEDURE SUB TOT BUDGE Copy HEAD DEPT CHAR 3 RETURNS TOT BUDGET DECIMAL 12 2 Select All AVG BUDGET DECIMAL 12 2 Find MIN _ BUDGET DECIMAL 12 2 MAX BUDGET DECIMAL 12 2 AS Search Next BEGIN Incremental Search SELECT SUM budget AVG budget budget FROM department WHERE head dept head dept INTO tot budget avg budget z budget SUSPEND Quick Code J Paste Replace The context menu of SQL Script Editor area contains most of the standard text processing functions Cut Copy Paste Select All and specific functions for working with the script e the Quick Code submenu allows you to select a character to toggle comments to change case of currently selected text and to manage indents e you are provided with saving and loading options as well use the corresponding context menu items or the appropriate toolbar buttons e if necessary you can use numerical bookmarks to make navigation within the script easier Use the Toggle Bookmarks context menu item to select a number to label the current code line If you want to jump to a bookmark select the Goto Bookmarks context menu item and pick one of the existing bookmarks within the submenu e the Go to Line Number item allows you to jump to the specified line e you Can ease the navigation by using markers within the corresponding submenu or shortcuts You can drop marker F2 collect marker ESC or swap markers last dr
10. Name Master k O omains total 15 different 2 master 10 target 3 equal 0 Tables total 55 different 3 master 49 target 3 equal 0 Views total 5 different 0 master 3 target 2 equal 0 Procedures total 16 different 1 master 8 target 7 equal 0 UDFs total 5 different 0 master 1 target 4 equal 0 Exceptions total 2 different 0 master 0 target 2 equal 0 Generators total 17 different 0 master 17 target 0 equal 0 Blob Filters Roles Database Triggers total 2 different 1 master 0 target 1 equal 0 Depending on the current selection in DB Tree the Information window either lists the total count of different objects in the source and the target database if a group of objects is selected in DB Tree or contains the complete list of properties of the source object as compared to the corresponding object in the target database if a particular object is selected in DB Tree At the header of the Information window the name and group of the objects are displayed Different Only Source Only Target Identical NEW_PROCEDURE NEW_PROCEDURE Different Name Master Target Declare AS AS Has Resultset compare Yes Yes Header Input Params NEW _INPARAM SMALLINT Output Params RESULTAT SMALLINT NEW _OUTPARAM SMALLINT If an object property in the source database differs from an object property in the target database it is highlighted re
11. Save visual scheme x Scheme name My visual scheme Cancel 1999 2015 EMS Database Management Solutions Ltd o DB Comparer for Interbase Firebird User s Manual 7 3 1 See also Environment Options Editor Options Keyboard Templates Bars and menus Use the Bars and menus section of the Visual options dialog to customize DB Comparer bars style menus animation and a number of general options concerning toolbars and menus usage Xx ae Schemerame Doe sye el Trees and lists Bar style Menu animation E Edit controls Office 11 None M Check boxes m z Sunken border Desktop style Buttons ES Page controls Use F10 for menu xP native z Ee Group ones Show full menus after delay Flat close buttons 4 gt Splitters Gray scale disabled images Bar style Use the drop down list to select the painting style that will be applied to the bars Standard Enhanced Flat XP native Office 11 Note If the XP native style is selected bars use the currently applied XP theme to paint themselves However if the currently installed operating system is not Windows XP or the Windows Classic theme is currently applied bars will be painted using the Enhanced style 1999 2015 EMS Database Management Solutions Ltd 95 DB Comparer for Interbase Firebird User s Manual Menu animation Use the drop down list to specify the menu animation effects
12. development to production database T Scroll to top DB2 SQL Management Studio for DB2 EMS SQL Management Studio for DB2 is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for DB2 Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for DB2 Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for DB2 Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for DB2 Migrate from most popular databases MySQL PostgreSQL Oracle MySQL InterBase Firebird etc to DB2 Data Generator for DB2 Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters den dad B DB Comparer for DB2 Compare and synchronize the structure of your databases Move changes on your development database to production with ease F DB Extract for DB2 Create database backups in the form of SQL scripts save your database structure and table 1999 2015 EMS Database Management Solutions Ltd 23 DB Compa
13. Built in SQL Script editor with syntax highlight New state of the art graphical user interface Latest Interbase Firebird version support Scroll to top Version 2 2 e Added the ability to filter analyzed objects using regular expressions This allows one to analyze only required objects and increases the speed of comparing and analyzing processes e Added the opportunity to connect via SSH tunnel e Visual representation of definition differences implemented e The Hide identical objects option added This option allows one to hide identical objects in the DB Tree e Large databases are now compared faster e Ability to refresh different types of objects separately implemented This may be helpful when you synchronize databases in the step by step style e Toolbar with list of working windows is added to the main program window e The Synchronize databases after comparing in console mode option added This project option allows you to run the console application in synchronization mode by default without defining the E option The Fill Table View on load option added This option can be used to increase the speed of comparing process and decrease memory usage The ability to set the default directories for grid exports and reports storage added No more delays occur while navigating DB Tree with large databases Fixed the saving passwords error Procedures were not compared correctly in some cases Fixed now Functions were not compa
14. Interbase amp Firebird IbComparerC exe DBComparer_IB icp Result sq E Upon running the command line utility the modification script will be generated into Result sq and executed Note The following exit codes can be returned by DB Comparer for Interbase Firebird to the operating system after performing the latest task 0 successful completion 1 error s occurred during task performing 2 fatal error occurred The task was not performed 1999 2015 EMS Database Management Solutions Ltd 112 DB Comparer for Interbase Firebird User s Manual See also Using GUI application 1999 2015 EMS Database Management Solutions Ltd ma DB Comparer for Interbase Firebird User s Manual 9 Appendix 9 1 Find Text dialog The Find Text dialog is provided for quick and flexible searching for specified text within the SQL Script Editor working area Text to find Enter a search string in this box The Arrow Down button which can be found next to the input box allows you to select any of the previously entered search strings Options Case Sensitive This option can be used to differentiate uppercase characters from lowercase ones during the search process Whole words only Use this option to search for words only with this option off the search string might be found within longer words Regular Expressions Recognizes regular expressions in the search string 5 Find Text Em Find T
15. None no animation Random random choice Unfold Slide Fade Unfold unfolding menus Slide sliding drop down and popup menus Fade menus fade in when appearing v Sunken border If this option is enabled the border of each dockable bar is drawn using sunken borders Otherwise no border is drawn around the dockable bar Wi Use F10 for menu If this option is disabled the application does not respond to the F10 key press events and the main menu will not will be called v Show full menus after delay This option is available only if the Menus show recently used commands first option available in the Customize dialog is selected If this option is enabled infrequently used menu items if they appear collapsed will be automatically expanded after a delay upon setting mouse cursor or upon selection with the Up Down keys on the bottom of the menu Otherwise the menu expands only after clicking its bottom most button or using the Ctri Down shortcut v Flat close buttons This option determines the border style of the Close buttons If this option is enabled the Close button is drawn flat Otherwise it has a 3D look v Gray scale disabled images This option specifies whether default images must be painted faded By default images within disabled links are painted grayscale when the XP native or Office11 bar style is used For other bar styles such images are painted grayed out If this option is enabled images of d
16. Studio in the Select Host or Database dialog Tunneling settings To setup the connection via SSH tunnel input the following values in the corresponding fields e SSH host name is the name of the host where SSH server is running e SSH port indicates the port where SSH server is activated e SSH user name stands for the user on the machine where SSH server is running Note it is a Linux Windows user not a user of Interbase Firebird server e SSH password is the Linux Windows user password Note When the SSH tunneling is set then the symbol appears near the head of the tab Source Database Connect Options Tunneling Don t use tunneling Connect through the Secure SHell SSH tunnel SSH host name vadsry z SSH user name tester SSH port e Both databases on the same server Use Private Key for authentication Check this option to enable Private Keys usage for the connection For details see SSH tunneling options When done press the Next button to set compare options Next step gt 1999 2015 EMS Database Management Solutions Ltd a DB Comparer for Interbase Firebird User s Manual See also Setting database options Setting compare options Select objects for compare Renamed objects 3 3 1 1 Selecting registered database Use this dialog to select a database for comparison This dialog is available only in EMS SQL Management Studio version of DB Comparer for Interbase Firebird
17. Target databases script of this type is generated to eliminate the differences CREATE ADD script if an object exists in the Source database and it does not exist in the Target database script of this type is generated to create the object in the Target database DROP script if an object exists in the Target database and it does not exist in the Source database script of this type is generated to drop the object in the Target database Note Synchronization is always performed in one direction i e in one database depending on the tab selected Note To change the height of the script entries use the List of modify scripts group of options available within the Preferences section of the Environment Options dialog See also Viewing Summary Info Browsing Database Tree Viewing Objects Definition Information window Switching windows 1999 2015 EMS Database Management Solutions Ltd so DB Comparer for Interbase Firebird User s Manual 5 SQL Script Editor SQL Script Editor allows you to edit and execute SQL scripts for modifying compared databases To open SQL Script Editor you can either use the context menu of DB Tree or double click a script in the Modification scripts list or select the corresponding item of the context menu Alternatively you can use the 4 Open selected scripts in SQL Script Editor and the Open all scripts in SQL Script Editor buttons on the project window toolbar The main wo
18. a user can generate a pair of cryptographic keys the Private key and the Public key The Public key is placed on the SSH server and the Private key is the part you keep secret inside a secure box that can only be opened with the correct passphrase or an empty string as the passphrase When you wish to access the remote system you open the secure box with your passphrase if any and use the private key to authenticate yourself with the Public key on the remote Linux computer SSH Key file Specify the location the secure box of the Private key file on your local machine Supported Private Key file formats are OpenSSH Putty SSH com Note that you need to trust your local machine not to scrape your passphrase or a copy of your Private key file while it is out of its secure box Passphrase dialog Please enter the passphrase for the key a 1999 2015 EMS Database Management Solutions Ltd 120 DB Comparer for Interbase Firebird User s Manual 9 4 Customize toolbars and menus The Customize dialog allows you to create and personalize DB Comparer menus and toolbars To call this dialog click the down arrow button on the right side of any toolbar then click Add or Remove Buttons and select Customize from the drop down menu Alternatively you can right click any toolbar and select the Customize popup menu item File Options Windows Edit Window List Customize Toolbars Th
19. apear aaao makeh Koai aeea daea aaa aeaea Aasna aa Keh onnaa anaiena 45 Viewing Summary INFO cecececeeeeeceeeeeeeceeeeeeneesneeenenaeseneaesesnsnsnaeaeanansnaensaeaeseaeaeaesesesesaaaaaaaaaaes 47 Part IV Working with Project 50 Browsing Database Tree sscecscsssssseseeneneeenceauseseenenenenceausassenenseseeeauaassesensesseeaeaassenenees 52 Viewing Objects Definition cccccccceseseseseeeseeneeseeesneesusuansuenensuauauausuauauaususususueusususususssnsnanens 54 Information WiINGOW A A seen en eeceneeeee A 55 Working with Modification Scripts cccccccceseseseseeeseseseseseseseeeseeeseeusuensusususeansusnensusnansnanees 57 Part V SQL Script Editor 60 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual Part VI Reports management 64 Report Designer 2 cccccsssssssssceeeeeeeseesseaneeeeeeensnnssesnaneeseeesusenssaneeseseeusnssssscaeseseeesnssesssanees 65 Sample reports oe ccccccececececeseeeensesnseenensnanauauansuausuauaususususuausuauauauausususususususususussaususnsusnsnsussonses 70 Part VII DB Comparer Options 75 Environment 8e 9 ee 76 Preference 8 a ol acces a a eee heh reed eee eee teed aa ea a aaa sce ty seed hace eee neni 76 Project Options r E A E E E E E EE T A E 78 Confirm ations nzia eea eaaa aaa a n e otat de raa aa aaea Vaai aa aeaa Aaa Pa Gate tee Eia radau 79 Compare OPTtiONS a e EEE E EEE 80 Fo s O nea e a pa ua dae aa aAa ee
20. bug fixes and more Scroll to top Version 1 3 e Fixed a bug concerned with incomplete maximization of the main program window e Some minor visual improvements and bug fixes Scroll to top Version 1 2 e Implemented the console version of the database comparison utility now you can schedule your database structure synchronization routine using the database utility e Now DB Comparer does not try to create a primary key if the table already has one The utility drops the existing primary key and creates another one e Using this version you can compare and synchronize primary keys regardless of key names e Now you can use the tool to compare names of fields and field order in views Check the Names of Fields and the Order of Fields options within the Compare Options section of the Environment Options dialog e Support of Firebird 1 5 e Now you can view project properties without actually loading the project file just open it while holding down the Shift key e We have implemented synchronous scrolling in the Master Definition and Target Definition windows e Now project files are associated with particular database comparison utilities e Some small improvements and bug fixes Scroll to top Version 1 1 Significantly increased the comparison speed for the databases with large amount of objects e Now the fields order is considered on comparing tables You can enable or disable this feature by using the Field order opt
21. development database to production with ease w A mw dd ad B DB Extract for PostgreSQL Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for PostgreSQL Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more wi Data Comparer for PostgreSQL lt Compare and synchronize the contents of your databases Automate your data migrations from development to production database al L Scroll to top InterBase Firebird 89 SQL Management Studio for InterBase Firebird EMS SQL Management Studio for InterBase and Firebird is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before Ei SQL Manager for InterBase Firebird Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways 1999 2015 EMS Database Management Solutions Ltd 21 DB Comparer for Interbase Firebird User s Manual Data Export for InterBase Firebird Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for InterBase Firebird Import
22. file E Languages 7 Show splash screen at startup Colors Reports directory C ProgramD ata EMS D atabase Comparer for InterBase and Firebird Reports D List of modified scripts Row auto height Max row line count 10 amp Default Cancel Help List of modified scripts W Row auto height If this option is selected script row height in the Modification Scripts area is adjusted to the content automatically Max row line count Defines the maximum number of lines displayed in each script row in the Modification Scripts area 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual See also Project Options Confirmations Compare Options Fonts Localization Colors Project Options W Show object related scripts only If this option is checked then the script of only selected in DB Tree object is displayed in the Modification scripts window Hide identical objects This option can be used to hide the identical objects in DB Tree It makes navigation easier and may increase the navigation speed Environment Options E Preferences Project Options R 2 i J Show object related scripts only Compare Options ide identi j Fonts LS Languages Colors Load last password for new projects Default Cancel Help Load connection info for new projects This option can be used to insert the latest used login autom
23. g doom_server 3050 8 employee on doom_server 3 localhost 32009 E employee on localhost 32009 a userver 32010 E hr on userver 32010 E test on doom_server Cancel Help employee on userver 32010 All databases registered in EMS SQL Management Studio for Interbase Firebird are displayed in the list Select the necessary database and click the OK button Database registration information will be filled on the first step automatically 3 3 2 Setting compare options Set comparison options for the project 1999 2015 EMS Database Management Solutions Ltd e DB Comparer for Interbase Firebird User s Manual Compare Project Wizard Choose the objects to be compared and synchronized and set their properties Specify the direction for comparison and filter options Compare options V Case sensitive comparing Analyze renamed objects F Add comments to generated script Database object Compare A Domains v DB EH Tables v Comparer Fields F Script generation Vv Generate create script Compare Options Filter Options InterBase Firebird for Triggers Constraints Indices G8 Views Generate alter script Generate drop script mpare properties Fields Description Triggers 7 Type Procedures 7 Not Null UDFs Default Value 0 Exceptions Collation B Generator
24. purposes in a simple and direct way Wide range of data generation parameters DB Comparer for MySQL Compare and synchronize the structure of your databases Move changes on your development database to production with ease oe dd B DB Extract for MySQL Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for MySQL Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more w Data Comparer for MySQL Compare and synchronize the contents of your databases Automate your data migrations from development to production database sil Scroll to top 1999 2015 EMS Database Management Solutions Ltd 9 DB Comparer for Interbase Firebird User s Manual Microsoft SQL Sd SQL Management Studio for SQL Server EMS SQL Management Studio for SQL Server is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before ES EMS SOL Backup for SOL Server Perform backup and restore log shipping and many other regular maintenance tasks on the whole set of SQL Servers in your company ce SQL Administrator for SQL Server a Perform administrative tasks in the fastest easiest and most efficient way Manage maintenance tasks monitor
25. source and target databases See also Openin Saving Project Compare Project Wizard Viewing Summary Info 1999 2015 EMS Database Management Solutions Ltd 36 DB Comparer for Interbase Firebird User s Manual 3 2 Opening Saving Project To open an existing DB Comparer project select the Project Open Project main menu item or use the P Open Project button on the toolbar Alternatively you can use the Ctr O shortcut for the same purpose Project Edit View Options Windows Help New Project Ctrl N F gt Open Project Ctrl O Save Project Ctrl S 4 Save Project As Ctrl Alt S Project Options Shift Ctrl P 3 Close Project Cirle Shift F10 Reopen Project To save a DB Comparer project select the Project Save Project Save Project As main menu item or use the ba Save Project bee Save Project As button on the toolbar Alternatively you can use the Ctrl S Ctrl Alt S shortcuts for the same purpose If this is the first time that this project is being saved or if you select Save Project As you are to specify the path to the project file and provide a name for the project file within the Save project options dialog File name C DBComparerProjects HrCompare pcp f Comment Comparison of databases HA on Merlin and HR on localhost v Abort script executing on error Direction From Source to Target 1999 2015 EMS Database Management Solutions Ltd
26. splitter can be dragged by its hot zone If this option is enabled you can drag the splitter by its hot zone i e use any part of the splitter s area for dragging Otherwise attempts to drag the splitter by the hot zone will have no effect See also Bars and menus Trees and lists Edit controls Check boxes Buttons Page controls Group boxes 1999 2015 EMS Database Management Solutions Ltd 107 DB Comparer for Interbase Firebird User s Manual 7 4 Keyboard Templates The Keyboard Templates window allows you to create new keyboard templates for quicker typing regularly used expressions and to edit the existing ones To open this window select the Options Keyboard Templates main menu item or use the 1 Keyboard Templates button on the main toolbar El Project Edit View Windows Help Environment Options Editor Options Keyboard Templates re Select Program Language Visual Options To add a new keyboard template click the Add Template button set the template name and define the template expression In the upper right area of the window you can change the case of the template expression You can deactivate an existing template by selecting it from the list on the left and removing the Active flag of the template 1999 2015 EMS Database Management Solutions Ltd 108 DB Comparer for Interbase Firebird User s Manual Case of Templates Add Template
27. their performance schedule frequency and the last execution result SQL Manager for SQL Server Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for SQL Server Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for SQL Server Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for SQL Server Migrate from most popular databases MySQL PostgreSQL Oracle DB2 InterBase Firebird etc to Microsoft SQL Server Data Generator for SQL Server Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters H D AT B DB Comparer for SQL Server Compare and synchronize the structure of your databases Move changes on your development database to production with ease pe DB Extract for SQL Server Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for SQL Server Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more w Data Comparer for SQL Server Compare and synchronize the cont
28. your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for InterBase Firebird Migrate from most popular databases MySQL SQL Server Oracle DB2 PostgreSQL etc to InterBase Firebird Data Generator for InterBase Firebird Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for InterBase Firebird Compare and synchronize the structure of your databases Move changes on your development database to production with ease w wm di a DB Extract for InterBase Firebird Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for InterBase Firebird Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for InterBase Firebird Compare and synchronize the contents of your databases Automate your data migrations from development to production database a D wW Scroll to top Oracle 89 SQL Management Studio for Oracle EMS SQL Management Studio for Oracle is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before g SQL Manager for Oracle Simplify and automate your dat
29. 2010 employee gdb gt shared testdb ib2010 emp gdb CREATE VIEW CUSTOMER_VIEW CUST_NO CUSTOMER CONTACT_FIRST Database Tree shared testdb ib201 0 employee gdb 8 Database objects E e Different 7 E e Only source 5 6E Tables 1 shared testdb ib2010 emp PROJ_DEPT_BUDGET Missed A Views 2 det a Bey PHONE 4 Open All Scripts in SOL Script Editor Procedures 2 Recompare Views Show quick report Ee Only target 4 Se Identical 32 6 Domains 15 5 Tables 9 Expand Node Collapse Node Full Expand Full Collapse E Generators 2 Show object related scripts only SiS SSss88 CONTACT_LAST PHONE_NO ADDRESS_LINE1 ADDRESS_LINE2 CITY STATE_PROVINCE s gt CREATE TRIGGER CUSTOMER_VIEW_BU FOR CUSTOMER_VIEW ACTIVE BEFORE UPDATE POSITION 0 AS BEGIN UPDATE CUSTOMER SET ONET MN went OTET MNA SS 888888888 5 Source Object Definition arget Object Definition CREATE VIEW CUSTOMER_VIEW CUSTOMER_VIEW Missed Unique Source Name Source Description Body SELECT Name CUSTOMER_VIEW CUST_NO CUSTOMER CONTACT_FIRST CONTACT_LAST PHONE_NO ADDRESS _LINE1 ADDRESS _LINE2 city STATE_PROVINCE COUNTRY mnetrar rnane 1999 2015 EMS Database Managemen
30. C A Show object related scripts only See also Script context menu Definition area context menu 2 2 2 Script context menu The context menu of a modification script allows you to e find the object the one used in the selected script in DB Tree 1999 2015 EMS Database Management Solutions Ltd 30 DB Comparer for Interbase Firebird User s Manual execute the selected modification script s execute all modification scripts of the project open the selected modification script s in SQL Script Editor open all modification scripts of the project in SQL Script Editor manage the order of the modification scripts copy the text of the selected script s to Windows clipboard Find in DB Tree 4 Execute Selected Scripts Execute All Scripts Open Selected Scripts in SQL Script Editor Open All Scripts in SOL Script Editor Move Script First Move Script Up Move Script Down Move Script Last Copy Ctrl C See also DB Tree context menu Definition area context menu 2 2 3 Definition area context menu The context menu of the Object Definition area allows you to e copy the object DDL definition to Windows clipboard e enable synchronous scrolling of the Source object definition and the Target object definition text Copy Object Definition to Clipboard Synchronization See also DB Tree context menu Script context menu 1999 2015 EMS Database Management Solu
31. Compare Options Choose program language Default x m Fonts laos E Colors Language Name Language File Default none French C Program Files x86 EMS DB Comparer for InterBase amp Firebird Languages French Ing Deutsch C Program Files x86 EMS DB Comparer for InterBase amp Firebird Languages German ng Russian C Program Files x86 EMS DB Comparer for InterBase amp Firebird _Languages Russian Ing Add Defaults Edit Delete Default OK Cancel Help 1999 2015 EMS Database Management Solutions Ltd e DB Comparer for Interbase Firebird User s Manual In the Available Languages area the list of available languages and the names of the corresponding localization ng files is displayed You can manage the list of languages using the buttons below Add Defaults Adds languages from the default directory to the list of available languages Add Opens the Add language dialog where you can specify your own localization file and set the language name a Cl Add Language a a l Language name Spanish Language file C EMS DBComparerSpanish Ing S Edit Opens the Edit language dialog where you can change the language name or select another localization file for the specified language la Cl Edit French Language Co fa Language name French Language file C Program Files EMS SQL Studio for Postgre C Terca Delete Removes the selected language from th
32. E Preferences Project Options Compare options F Confirmations Case sensitive comparing 4 Analyze renamed objects Eii onns E Add comments to generated script Fonts E Languages Database object Compare Colors Fania ss T Er Compare Options Filter Options EB Tables Fields 7 Script generation Triggers v V Generate create script Constraints 7 v Generate alter script lindines 7 V Generate drop script i Views i F Compare properties Fields m v Description Triggers jv v Collation Procedures iv V Check Source UDF z Not Null E a Default Value 5 Exceptions Z Type Generators v B Roles 7 F Blob Filters E Database Triggers v Default Cancel Help Case sensitive comparing Enable this option to make the comparing process case sensitive W Analyze renamed objects This option enables disables comparing databases object which might have been renamed Add comments to generated script Use this option to toggle comments in modification script You can also set filtering criteria for objects to be compared Use the Filter options tab for that purpose For details see Setting compare options 1999 2015 EMS Database Management Solutions Ltd 22 DB Comparer for Interbase Firebird User s Manual See also Preferences Project Options Confirmations Fonts Localization Colors 7 1 5 Fonts Application font Defines the font used by DB Comparer for Interbase Firebird S
33. Edit controls Ultraflat z M Check boxes eee Native style ES Page controls Group boxes 4 gt Splitters Sample button 2 Sample button 3 M Cira Heb Button kind This setting determines the manner in which a button is painted Use the drop down list to select the painting style that will be applied to buttons Standard Flat UltraFlat W Native style This option determines whether the native Windows style will be applied to the buttons The option has a higher priority than the Button kind setting If this option is selected the buttons are painted according to the native Windows style otherwise the Button kind selection is applied Note The Native style option is currently supported for the Windows XP operating system only 1999 2015 EMS Database Management Solutions Ltd 102 DB Comparer for Interbase Firebird User s Manual See also Bars and menus Trees and lists Edit controls Check boxes Page controls Group boxes Splitters 7 3 6 Page controls Use the Page controls section of the Visual options dialog to customize the style of all DB Comparer page controls Visual Options lt Scheme name Office 11 style Save As Delete og Bars and menus Eal Trees and lists Tab style Edit controls Flat M Check boxes Hot track Buttons i 5 Page controls Multiline pages O Group boxes 4 gt Splitters J Native styl
34. Fs total 33 different 0 master 0 target 33 equal 0 Exceptions total 6 different 0 master 5 target 1 equal 0 Generators total 11 different 1 master 5 target 5 equal 0 Blob Filters total 1 different 0 master 1 target 0 equal 0 Roles total 3 different 0 master 2 target 1 equal 0 Database Triggers total 1 different 0 master 0 target 1 equal 0 Do not show summary To disable this window for the future projects check the Do not show summary option See also Creating Project Openin Saving Project Compare Project Wizard 1999 2015 EMS Database Management Solutions Ltd so DB Comparer for Interbase Firebird User s Manual 4 Working with Project Having created or opened a project you see the Project window By default the Project window contains the Database Tree Source and Target Object Definitions Modification Scripts and Information windows Browsing Database Trees Viewing Objects Definition Information window Working with Modification Scripts Switching windows Options 2 Full Recompare View Reports p out none zh Database Tree Modification scripts a o shared testdb ib201 0 employee gdb shared testdb ib2010 emp shared testdb ib201 0 employee gdb gt shared testdb ib2010 emp adb shared testdb ib2010 emp adt 3 E E Datab
35. Non commercial license 3 Year Maintenance EMS DB Comparer for Interbase Firebird Trial version Download Now EMS Maintenance Program provides the following benefits e Free software bug fixes enhancements updates and upgrades during the maintenance period e Free unlimited communications with technical staff for the purpose of reporting Software failures e Free reasonable number of communications for the purpose of consultation on operational aspects of the software 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual After your maintenance expires you will not be able to update your software or get technical support To protect your investments and have your software up to date you need to renew your maintenance You can easily reinitiate renew your maintenance with our online speed through Maintenance Reinstatement Renewal Interface After reinitiating renewal you will receive a confirmation e mail with all the necessary information See also How to register DB Comparer 1999 2015 EMS Database Management Solutions Ltd 12 DB Comparer for Interbase Firebird User s Manual 1 5 Howto register DB Comparer If you have not registered your copy of DB Comparer for Interbase Firebird yet you can do it by selecting the Help Register DB Comparer for Interbase Firebird main menu item or by selecting the Help About main menu item and pressing the Register Now
36. RDER_ALREADY_SHIPPED InterBase 4 Ay REASSIGN_SALES REASSIGN_SALES Firebird A Ay UNKNOWN_EMP_ID UNKNOWN_EMP_ID IS SSSSS888 On Source Only Name in Target EHX Views 2 4 CUSTOMER_VIEW h PHONE_LIST S E Procedures 2 MAIL_LABEL 9 SUB_TOT_BUDGET On Target Only Name in Source Name in Target LR Views 2 PHONES PROJECT_VIEW Procedures 2 rr eeraa The objects that exist in both databases are displayed in the On Source and Target window 1999 2015 EMS Database Management Solutions Ltd s DB Comparer for Interbase Firebird User s Manual The objects that exist in either source or target database are displayed in On Source Only and On Target Only window correspondingly You need to check the objects to be synchronized Please note that you need to have sufficient privileges to be able to write to the source and or destination database on Interbase Firebird server lt Previous step Next step gt See also Setting database options Setting compare options Select objects for compare Renamed objects 3 3 4 Renamed objects At this step you can see the list of objects which might have been renamed This list includes similar objects with different names in source and target databases 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual Compare Project Wizard Choose the objects to be treated as r
37. SQL Manager net EMS Database Management Solutions DB Comparer for Interbase Firebird User s Manual 1999 2015 EMS Database Management Solutions Ltd Em3 DB Comparer for Interbase Firebird User s Manual 1999 2015 EMS Database Management Solutions Ltd All rights reserved This manual documents EMS DB Comparer for Interbase Firebird No parts of this work may be reproduced in any form or by any means graphic electronic or mechanical including photocopying recording taping or information storage and retrieval systems without the written permission of the publisher Products that are referred to in this document may be either trademarks and or registered trademarks of the respective owners The publisher and the author make no claim to these trademarks While every precaution has been taken in the preparation of this document the publisher and the author assume no responsibility for errors or omissions or for damages resulting from the use of information contained in this document or from the use of programs and source code that may accompanyit In no event shall the publisher and the author be liable for anyloss of profit or any other commercial damage caused or alleged to have been caused directly or indirectly by this document Use of this documentation is subject to the following terms you may create a printed copy of this documentation solely for your own personal use Conversion to other formats is al
38. SQL Script Editor DB Comparer Options Console application 1999 2015 EMS Database Management Solutions Ltd e DB Comparer for Interbase Firebird User s Manual 6 1 Report Designer Report Designer allows you to create and edit reports This tool is opened when you create a report in the Reports window or select any of the existing reports for editing For your convenience several sample reports are available within the program_directory Reports folder This module is provided by FastReport http www fast report com and has its own help system Press F1 key in the Report Designer to call the FastReport help Please find the instructions on how to create a simple report in Report Designer below Adding bands In order to add a band to the report e proceed to the Page1 tab of Report Designer e select the 2 Insert Band component on the toolbar on the left e select the band to be added to the report e click within the working area the corresponding element appears in the area e set element properties within the Properties Inspector Note The Properties Inspector panel that allows you to edit report object properties can be shown hidden by pressing the F11 key 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual GE
39. Text dialog is provided for searching and replacing text within the SQL Script Editor working area Text to find Enter a search string in this box The Arrow Down button which can be found next to the input box allows you to select any of the previously entered search strings Text to replace This box allows you to enter a string to replace the search string The Arrow Down button which can be found next to the input box allows you to select any of the previously entered strings To replace the search string with an empty string leave this input box blank Options Case Sensitive This option can be used to differentiate uppercase characters from lowercase ones during the search process Whole words only Use this option to search for words only with this option off the search string might be found within longer words Regular Expressions Recognizes regular expressions in the search string 4 Replace with template This option requires the Regular expressions option selection Enable this option to use regular expressions in the Text to replace field Expression used in this field will be applied to each string that matches the Text to find expression Note The syntax of regular expressions that can be used in the Text to find and the Text to replace fields is similar to that used in Perl regular expressions Comprehensive information about it can be found at http perldoc perl org perlre html V Prompt on replace
40. abase development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways E Data Export for Oracle Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more FFl Data Import for Oracle Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface a Data Pump for Oracle Migrate from most popular databases MySQL PostgreSQL MySQL DB2 InterBase Firebird etc to Oracle 1999 2015 EMS Database Management Solutions Ltd 22 DB Comparer for Interbase Firebird User s Manual Data Generator for Oracle Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters ee DB Comparer for Oracle Compare and synchronize the structure of your databases Move changes on your development database to production with ease is DB Extract for Oracle Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially re SQL Query for Oracle Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Ee Data Comparer for Oracle Compare and synchronize the contents of your databases Automate your data migrations from
41. al Si aAA o QG GHUR N 1 EMS DB Comparer DEMO Report employees Table TestDB Unique department Table TestDB Unique address Table TestDB Unique account Table TestDB Unique tbltest2 Table TestDB Unique tbltest1 Table TestDB Unique mymreports Table TestDB Unique UserList Table TestDB Unique Employees Table TestDB Unique DevicesList Table TestDB Unique Department Table TestDB Unique Dealers Table TestDB Unique DB_Names Table TestDB Unique DB_List Table TestDB Unique DB_Hosts_List Table TestDB Unique Customers2007 Table TestDB Unique Countries Table TestDB Unique Page1 of 1 Saving the report When all report parameters are set you can save the report to an external fr3 file on your local machine or in a machine in the LAN 1999 2015 EMS Database Management Solutions Ltd e DB Comparer for Interbase Firebird User s Manual To save the report select the Project Save main menu item or use the corresponding bilSave Report toolbar button You can also use the Ctr S shortcut for the same purpose 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 6 2 Sample reports There are several sample reports implemented in Report Designer Detailed Info Summary Info with Chart Summary Info The location of the templates can be defined in the Environment options of the utility Sample reports can be accessed from the utility too
42. ase objects Y gt CREATE VIEW CUSTOMER VIEW m a amp Different 7 CUST_NO a ee Only source 5 E CUSTOMER SE Tables 1 W CONTACT_FIRST 7 co Ei PROJ_DEPT_BUDGET Missed E CONTACT LAST E S X Views 2 F PHONE_NO Bem ay ADDRESS _LINE1 5 0 amp y PHONE T ADDRESS_LINE2 Procedures 2 7 5 v CITY a MAILL Recompare Views STATE PROVINCE seb a SUB_T Eid Show quick report e CREATE TRIGGER CUSTOMER _VIEW_BU FOR CUSTOMER_VIEW E e Only target 4 Expand Node 7 ACTIVE BEFORE UPDATE Ee Identical 32 l a POSITION 0 amp Domains 15 g corerse Noe E Bl AS Tables 9 Full Expand 7 BEGIN amp Procedures 1 2 Full Collapse A UPDATE CUSTOMER 5 Exceptions 5 7 SET 4 iil Generators 2 Show object related scripts only T 5 i mmer mna a otter wma 5 Source Object Definition o Target Object Definition CREATE VIEW CUSTOMER VIEN CUST_NO CUSTOMER CONTACT_FIRST CONTACT_LAST CUSTOMER_VIEW Missed Unique Source Name Source Target PHONE NC Description ADDRESS_LINE1 Body SELECT ADDRESS LINE2 Name CUSTOMER_VIEW CITE T STATE_PROVINCE COUNTRY naoerart rnane When working with your project you are provided with a powerful project toolbar which is available at the top of the project window E Open project in Project Wizard 2 Perform a full r
43. astheport Report tr 2 fon xs File Edit Report View Help Duala anulen e m m lela ee 10 ava o gt BIU RAYS S SS S ih m EEE Rh Code Data Page1 DialogPage 1 Dimes 1 x Ji 2 6 24 34 4 5s Bt Q B Data E T a Page1 gy ad EE DialogPage1 g E Report Title Fe Report Summary Page Header gt A Page Footer z Header i EF Footer e FE Master Data M a j Detail Data Aj 4 Subdetail Data Data 4th level is Data Sth level Data 6th level rl Group Header ES Group Footer Child Q Column Header E Column Footer z Overlay y ia M Create field Vertical bands gt gjen T7 Create caption Adding report data In order to add data to the report e proceed to the Data tab within the panel on the right side of the window e pick an element within the U Data tree and drag it to the working area e add all necessary elements one by one using drag and drop operation for each of them 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual z File Edit Report View Help pgun annule seal Tey Tes Gt 100 els 7 Traral o gt BIu hA 2ee m mw Toe oles al ih Code Data P Diog OO O 22 ay ixj H See a gar en ce a OC
44. atically when creating a new project V Load last password for new projects This option can be used to insert the latest used password automatically when creating a 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual new project See also Preferences Confirmations Compare Options Fonts Localization Colors 7 1 3 Confirmations Confirm exit from DB Comparer for Interbase Firebird If this option is set you are prompted for confirmation each time when you exit the application Recompare object after executing the script The process of re comparing objects starts automatically right after execution of the modification script 7 Autosave project before closing Disables enables a confirmation window that appears upon closing the project If the option is checked modifications made in the project are saved automatically 7 Show summary after comparing Toggles displaying the Summary Info window that appears after the comparison process is finished 1999 2015 EMS Database Management Solutions Ltd s DB Comparer for Interbase Firebird User s Manual Environment Options s Ei Preferences i Project Options fa 4 Confirm exit from Database Comparer for InterBase and Firebird Compare Options Recompare objects after executing the script Fonts F Autosave project before closing LA Languages i Colors Show summary after comparin
45. button to call the Register DB Comparer for Interbase Firebird dialog About Database Comparer for InterBase and Firebird m B Database Comparer for InterBase and Firebird 4 0 0 build 44579 1999 2014 EMS Database Management Solutions Ltd All rights reserved Developers Alexey Karpovich Michael Kuzevanov Ivan Plyusnin Alexey Butalov Alexander Zhiltsov Company Home Page http www sqlmanager ne Product Home Page http www sglmanager net products ibfb dbcomparer Registered to EMS Business license Software Maintenance Period Valid Till 29 08 2015 Read the License Agreement Warning This program is protected by copyright law and international treaties OK Unauthorized reproduction or distribution may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under the law ani Register Now To register your newly purchased copy of EMS DB Comparer for Interbase Firebird perform the following steps e receive the notification letter from Share it with the registration info e enter the Registration Name and the Registration Key from this letter e make sure that the registration process has been completed successfully check the registration information in the About DB Comparer for Interbase Firebird dialog use the Help About main menu item to open this dialog 1999 2015 EMS Database Management Solutions Ltd 13 DB Compa
46. chemas on different servers as well as ona single server e Comparing all database objects or selected ones only Comparing by all or by selected properties of objects only Visual representation of differences between databases with details and modification scripts for the different objects e Ability to synchronize databases manually step by step or automatically e Ability to generate reports with database differences Possibility to add custom reports Ability to automate the database comparison and synchronization using the Console Application Working with several compare projects at once Saving and loading projects with all their parameters A wide variety of options for comparison and synchronization Built in SQL Script Editor with syntax highlight New state of the art graphical user interface Latest Interbase Firebird versions support and more Product information Homepage http www sqlmanager net en products ibfb dbcomparer Support Ticket http www sqlimanager net support System Register online at http www sqlmanager net en products ibfb dbcomparer bu 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 1 1 What s new Version Release date DB Comparer for Interbase Firebird 4 1 July 20 2015 What s new in DB Comparer e Dependencies processing mechanism enhanced e In some cases the connection using SSH tunneling could not be established Fixed now
47. d by default in the Information window Use the button to hide identical objects 1999 2015 EMS Database Management Solutions Ltd s DB Comparer for Interbase Firebird User s Manual See also Viewing Summary Info Browsing Database Tree Viewing Objects Definition Working with Modification Scripts Switching windows 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 4 4 Working with Modification Scripts The Modification Scripts window displays differences between the database objects as a row of modification scripts You can view edit any generated scripts There is an icon for each script denoting its script type ALTER CREATE DROP and corresponding object type To change the direction of synchronization from Source to Target to Target to Source switch between the corresponding tabs of the Modification scripts window Use the amp toolbar buttons or items of the context menu to manage the script order Moreover the context menu allows you to specify which of the scripts should be executed and edit scripts using SQL Script Editor You can also double click a script to open it in SOL Script Editor Upon selecting an entry within the Modification scripts window the corresponding element can be selected in the database tree right click the required script and use Find in DB Tree context menu item Note multiple selection of script entries is po
48. e Tab1 Tab2 Tab3 ima He Tabs are visual elements of tab controls Their purpose is to identify pages and switch between them Once a tab is clicked the corresponding page is selected Pages are container controls that represent the contents of tab controls Tab controls contain a single page whose context is to be updated each time the selected tab changes Page controls contain the number of pages equal to the number of tabs Tab style 1999 2015 EMS Database Management Solutions Ltd 103 DB Comparer for Interbase Firebird User s Manual Use the drop down list to select the painting style that will be applied to the tab controls Tabs tabs are painted as notebook tabs Buttons the selected tab is painted as a pressed button other tabs are painted as released buttons Flat tabs are painted as notebook tabs but appear lowered slightly Hot track This option specifies whether tab captions are highlighted when the mouse pointer hovers over tabs Select this option to enable tab highlighting Multiline pages This option specifies whether tabs are arranged across several rows If this option is enabled tabs are automatically arranged into the minimum number of rows required to fit all of them If this option is disabled tabs are displayed within a single row W Native style This option determines whether the native Windows style will be applied to the tab controls
49. e Available languages list without confirmation See also Preferences Project Options Confirmations Compare Options Fonts Colors 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 7 1 7 Colors This section of the Environment Options dialog allows you to set colors of various elements used in your project General colors used in DB Tree Identical objects Non identical objects Unique source objects Unique target objects Non identica l properties and Definition View colors Non identical lines Deleted lines Added lines Additional lines Environment Options Ee Ei Preferences Fy Coste Bic z Compare Options Identical objects HE ciwindowText x Jl Fonts Non identical objects B cue z l Unique source objects B Green o B Unique target objects DE ive 5 li Non identical properties E Fed x J Definition View 7 Highlight definitions Nor identical lines CAFFCB ee Deleted lines FFEGE6 Je Added lines D2E1FF ee Additional lines EEEEEE mi Default l Best performance OK Cancel Help General Options of this group allow you to set colors for basic DB Tree elements Select a system color from the list or use the b ellipsis button to open the Color dialog allowing you to select the required color from the palette Definition View Options of this group allow you to set colors for Definition View elements Select a
50. e The comments of objects were synchronized incorrectly Fixed now The comparison of views fields is now improved Added the detection of renamed Constraints Lots of other improvements and bug fixes See also Version history 1999 2015 EMS Database Management Solutions Ltd Ez DB Comparer for Interbase Firebird User s Manual 1 2 System requirements e 300 megahertz MHz processor 600 MHz or faster processor recommended e Microsoft Windows NT4 with SP4 or later Microsoft Windows 2000 Microsoft Windows 2000 Server Microsoft Windows XP Microsoft Windows 2003 Server Microsoft Windows 2008 Server Microsoft Windows Vista Microsoft Windows 7 Microsoft Windows 8 Microsoft Windows 8 1 e 64 MB of RAM or more 128 MB or more recommended 20MB of available HD space for program installation e Super VGA 800x600 or higher resolution video adapter and monitor Super VGA 1024x768 or higher resolution recommended e Microsoft Mouse or compatible pointing device e Interbase Firebird client e Possibility to connect to any local or remote Interbase Firebird server e Supported InterBase and Firebird server versions InterBase up to XE3 Firebird up to 2 5 1999 2015 EMS Database Management Solutions Ltd 9 DB Comparer for Interbase Firebird User s Manual 1 3 Installation If you are installing DB Comparer for Interbase Firebird for the first time on your PC e download the DB Comparer for Interbase Firebird dis
51. e edit control buttons ellipsis button arrow down combo box button etc respectively None Single Thick Flat 3D UltraFlat Button transparency Represents the button transparency mode within an editor Use the drop down list to specify the transparency that will be applied to the edit control buttons ellipsis button arrow down combo box button etc None a button is always displayed in a non transparent fashion Inactive a button is drawn when the editor has focus or when the mouse cursor is positioned over the button otherwise the button is transparent Always a button is always transparent Hide inactive a button is drawn only when the editor has focus otherwise the button is invisible Hide unselected a button is drawn when the editor has focus or when the mouse cursor is positioned over the editor region otherwise the button is invisible Edges This group defines which edges are displayed within an editor Check uncheck the boxes to hide show individual edges of the edit controls Left if unchecked the left border edge is invisible v Right if unchecked the right border edge is invisible v Top if unchecked the top border edge is invisible v Bottom if unchecked the bottom border edge is invisible W Hot track This option specifies whether editor items are highlighted when the mouse cursor is positioned over an edit control Select this option to highlight an edit control in response t
52. e project By default the corresponding I New Project Open Project buttons are available on 1999 2015 EMS Database Management Solutions Ltd z DB Comparer for Interbase Firebird User s Manual the toolbar and within the Project menu When the project is created opened and the settings are specified you can proceed to Working with Project See also Using context menus Selecting program language Switching windows 1999 2015 EMS Database Management Solutions Ltd 2 DB Comparer for Interbase Firebird User s Manual 2 2 Using context menus The context menus are aimed at facilitating your work with DB Comparer for Interbase Firebird you can perform a variety of operations using context menu items Select an element of DB Comparer project interface and right click it to call its context menu e DB Tree context menu e Script context menu e Definition area context menu See also First time started Selecting program language 2 2 1 DB Tree context menu The context menu of the DB Tree allows you to e open all scripts in SQL Script Editor e refresh all objects of the type depending on the current selection in DB Tree e open a simple printing report of the tree e expand collapse the selected node in the tree e enable Forward Navigation for the project Open All Scripts in SQL Script Editor Show quick report Expand Node Collapse Node Full Expand Full Collapse mm gat a t
53. e search and replace process covers either the entire block of selected text or the 1999 2015 EMS Database Management Solutions Ltd ns DB Comparer for Interbase Firebird User s Manual entire script no matter where the cursor is in the Editor area depending upon the Scope options Click the Replace All button to replace every occurrence of the search string If you have checked the Prompt on replace option the confirmation dialog box appears upon each occurrence of the search string 1999 2015 EMS Database Management Solutions Ltd no DB Comparer for Interbase Firebird User s Manual 9 3 SSH tunneling options To setup the connection via SSH tunnel input the following values in the corresponding fields e SSH host name is the name of the host where SSH server is running e SSH port indicates the port where SSH server is activated e SSH user name stands for the user on the machine where SSH server is running Note it is a Linux Windows user not a user of Interbase Firebird server e SSH password is the Linux Windows user password Please note that Interbase Firebird host name should be set relatively to the SSH server in this case For example if both Interbase Firebird and SSH servers are located on the same computer you should specify localhost as host name instead of the server external host name or IP address W Use Private Key for authentication If the SSH encryption is enabled on the SSH server
54. ebird User s Manual Sort by scope Sort by name Switches between sorting objects in the popup menu by name or by type Table View etc See also General Display Color 1999 2015 EMS Database Management Solutions Ltd 93 DB Comparer for Interbase Firebird User s Manual 7 3 Visual Options Visual Options allow you to customize the application interface style to your liking To open the Visual Options window select the Options Visual Options main menu item or use the Visual Options button on the main toolbar GL Project Edit View Windows Help h Environment Options Editor Options Visual Options z Keyboard Templates Select Program Language Bars and menus Trees and lists Edit controls Check boxes Buttons Page controls e Group boxes e Splitters Use the Scheme name box to select the interface scheme you would like to be applied MS Office 11 style MS Office XP style MS Office 2000 style Windows XP native style or Classic style For your convenience the previews illustrating the changes are displayed in the Sample Group area at the bottom of each section within the Visual options dialog It is also possible to create one s own interface scheme if necessary e set your preferences within the available sections of the Visual Options dialog Bars e click the Save As button e specify the new scheme name in the Save Visual Scheme dialog p an
55. eceeeeeeneesnsnaneeseeeensenssnanansesesesensessanenseeeenseesssanes 111 Part IX Appendix 114 Find Text dialog ssssesennnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nnmnnn nnmnnn nnmnnn nnmnnn nnmnnn nnman ma 114 Replace Text dialog 2 cccccsssssssseeseeceeeceanssseenenseenceacaasesnenseseeeacausesnenseseeeacausesnensessenscansenees 116 SSH tunneling Options ccceceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeseseseeeseseseeeeeseseeeseseseseseseseeeenenenenenenen 119 Customize toolbars and MENUS cccccecececececececeueuneneueneneueneuenecenecenacecucusecueusususeesenececuceseaeaes 120 1999 2015 EMS Database Management Solutions Ltd 6 DB Comparer for Interbase Firebird User s Manual 1 Welcome to DB Comparer for Interbase Firebird DB Comparer for Interbase Firebird is an excellent tool for comparing Interbase Firebird databases and discovering differences in their structures You can view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences A simple and intuitively comprehensive GUI allows you to work with several projects simultaneously define comparison parameters and alter modification scripts Many other features are implemented to make your work with our database comparison tool easy and fast Visit our web site for details http www sqlmanager net Key features e Comparing and synchronization of databases or s
56. ecompare View e Show hide Identical node in the Database Tree e Choose the way objects should be grouped e Show hide All objects node in the Database Tree 1999 2015 EMS Database Management Solutions Ltd 51 DB Comparer for Interbase Firebird User s Manual Reports e View Summary Info Report e View Summary Info with Chart Report e View Detailed Report Eeg Open selected scripts in SQL Script Editor E Open all scripts in SQL Script Editor Execute selected scripts Execute all scripts amp change script order Layout Use this drop down list to specify a name for current positional layout of the windows If necessary you can click the bil Save Layout toolbar button to save the layout for future use or the X Remove Layout toolbar button if you do not need the current layout any longer See also Getting started Managing Projects SQL Script Editor Reports management DB Comparer Options Console application 1999 2015 EMS Database Management Solutions Ltd 52 DB Comparer for Interbase Firebird User s Manual 4 1 Browsing Database Tree The Database Tree contains the objects of both databases and is situated on the left by default It displays objects of both source and target databases side by side Database Tree consists of four major groups amp Different objects are to be modified to become identical with the same objects in the source target databases Only Source objects that exist in t
57. eee A ected aE aa aaa aa aa aaa raaa aa a ees 82 LANQuage E EE A E A A AA 83 o oT Ro N E EE EE A E AET EA AEE E A EIE EE EAE E TN E EEE E E EAEE 85 Editor Options oireina aan aana NAKAA E AANA EA ANAKARA NAE AA EENEN ANAA ONNAN NA KNARAS ANENE NENANA AANRAAI 87 General E E EE E E E EE ah NS cre eee SS ee ae 87 DiS Play e a ceteisouactanpacndseusdused sainsusvavdedacndedousedeusuateussusidncadeansdveveusds dei uedsceussucnuadeddunsuatansdveavedbouhsesbensedan 89 Color AE ESEE EE E ee ees E Ee at SS N 90 QUICK C d nai e e teases oetenad a e a ne eee eee nee eae anaes 91 Visual Options oerien anerian eunana ear RENEA ARENAEN R ERENNERT RANNAN AAA EKNER 93 Barssand Menus EEA E E E ee a A See TA E 94 ARLS alo M EEE EEE E E tea E E ETE E AEE E EE A A ES 96 e COMUNOIS a E A EE ETIT T L A E ATT pene soeee me teaceesssecceet 97 Check JOX Siaran aaa a a e a ar oa aa reece a a d a a 99 BBRUTLONIS osu cic A a cus e E E E E E A TE E E E A 100 Page COMPOS serea iadaa idaran aaa aAa paaa E aaea Eoi adaa dds sadedate sili ec aaea Eaa E 102 GROUP DOXC S E E 103 Splitter S ccccedsssctccansaicsiansugiarveeseccsccocsadenssadsndsusntsaiecsugdeduessndudideitedcvsusctensensadseduassaieaWaduuudeevanaad ueievadeseuudebacasusduenuaieds 105 Keyboard Templates s s ecccceeeeeesessesseeeeeeensnessnscaneeseeesnssnsscanaeeesesesessnsssaneeeeeesnssessssnes 107 Part VIII Console application 110 Using console DB Comparer ccccccsssssssse
58. elect the font name from the drop down list of available system fonts Environment Options Preferences Project Options a F Confirmations Application font Compare Options amp MS Sans Serif hd Fonts LA Languages Colors Application font size 8 X Sample Text 12345 Default Cancel Help Application font size Defines the font size used by DB Comparer for Interbase Firebird Type in or use the spin editor to specify the required value The box below displays the sample text with the selected font applied 1999 2015 EMS Database Management Solutions Ltd e DB Comparer for Interbase Firebird User s Manual See also Preferences Project Options Confirmations Compare Options Localization Colors 7 1 6 Languages The Localization page is provided for managing DB Comparer localization files You can create your own ng files similar to those available in the program_directory Languages folder add them to the list of available languages and set the new language as the program interface language Default directory Use the button to specify the directory where the ng files are to be stored by default Choose program language Use the drop down list of available languages to select the interface language to be applied to the application A iaaa Default directory C Program Files x86 EMS DB Comparer for InterBase amp Firebird Languages S
59. elect the painting style that will be applied to the check boxes and radio groups None Single Thick 1999 2015 EMS Database Management Solutions Ltd 10 DB Comparer for Interbase Firebird User s Manual Flat 3D UltraFlat v Hot track This option specifies whether the check box is highlighted when the mouse cursor is positioned over it Select this option to highlight an edit control in response to mouse movements v Shadow If this option is selected a shadow is displayed for the check boxes and radio groups v Native style This option determines whether the native Windows style will be applied to the check boxes and radio buttons The option has the highest priority for check boxes and radio buttons If this option is selected the check boxes and radio buttons are painted according to the native Windows style regardless of other painting settings Note The Native style option is currently supported for the Windows XP operating system only See also Bars and menus Trees and lists Edit controls Buttons Page controls Group boxes Splitters 7 3 5 Buttons Use the Buttons section of the Visual options dialog to customize DB Comparer buttons 1999 2015 EMS Database Management Solutions Ltd 101 DB Comparer for Interbase Firebird User s Manual f Visual Options exe Scheme name Office 11 style Save As Delete s Bars and menus Ea Trees and lists Button kind
60. enamed Renamed objects Name in Source Name in Target Constraints 27 E CUSTOMER 1 INTEG_61 INTEG_82 3 CUSTOMER 1 B INTEG_59 INTEG_81 Comparer DEPARTMENT 1 for INTEG_17 INTEG_80 DOLEE 3 E DEPARTMENT 1 Firebird A E INTEG_31 INTEG_79 A 5 DEPARTMENT 1 INTEG_15 INTEG_51 EMPLOYEE 1 INTEG_28 INTEG_78 o EMPLOYEE 1 T INTEG_29 INTEG_77 S E EMPLOYEE 1 INTEG_30 INTEG_76 a S E EMPLOYEE_PROJECT 1 Wie s CREATE TABLE EMPLOYEE PROJECT CREATE TABLE EMPLOYEE PROJECT EMP NO EMPNO NOT NULL EMP_NO EMPNO NOT NULL PROJ_ID PROJNO NOT NULL PROJ_ID PROJNO NOT NULL Hab eeraa The script for the selected objects is displayed in the bottom part of the window Click the Compare button to start the database comparison process After the comparison has finished the project is loaded in DB Comparer automatically and you can start working with it lt Previous step See also Setting database options Setting compare options Select objects for compare Renamed objects 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 3 4 Viewing Summary Info After you have created opened a project the selected databases are analyzed for differences The Progress window displays the total progress of the comparison process and the sequence of operations performed by the utility appears
61. ents of your databases Automate your data migrations from development to production database Scroll to top PostgreSQL 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual s9 SQL Management Studio for PostgreSQL EMS SQL Management Studio for PostgreSQL is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for PostgreSQL Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for PostgreSQL Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for PostgreSQL Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for PostgreSQL Migrate from most popular databases MySQL SQL Server Oracle DB2 InterBase Firebird etc to PostgreSQL Data Generator for PostgreSQL Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for PostgreSQL Compare and synchronize the structure of your databases Move changes on your
62. esesseusevsevseeaneseeseesnesaesaesaeseeseesaesoesausaesaesaevaesenvaneseeaeanaeseesaesansaes 29 Definition area context MENU uuu cece eteetessesseveeveesseeseeseeseeseessessesseusesseeseesoesoesaesaesaesaesaesaeesnesneseesoeseesaesaeuaneas 30 Selecting program laAMQuage o cscccceceseeesesesesesnsesesusnsesususnsusususnsususususuausuansususuausususususnensnanens 31 Switching WiIMGOWS oneesecccecececeeeeeeneeenensnsnsnensnsuansuauanauausuauauauansuauauausususuauanaususususnsususususnsnsnanses 32 Part Ill Managing Projects 34 Creating Project aii i nnn nn nnn nnn nnn nnn a a aaa aa rN eaaa aea ieia aa aaa ia aa a E Ea aeania aS 35 Opening Saving Project ti nnn nnn nnn nnn nnnnnnnnnnnnnninneeeneneneneneeeeeeenees 36 Compare Project WiZard nnn nn nnn nnnnnninnnnnenenneenneenseneneneneeennea 38 Setting database Options ou cece seeeeeeesteesesseesessevseveneseeseeseeseeseesesaessesseesessoesoesaesaesaesaeusevonrseesneaeeneesnenaesannans 38 Selecting registered database eeseeceeceeseeeneeeneeeaeeeeeeeeeeeeeseneseeeeeeeaeeeaeseaeeeaeeeaeseaeenaeseeseeseeseesaeeeaeeeaeesae 41 Setting compare OPTIONS ce ceceseeeeeeeestessesseesesseveeveeesneseeneeneesnesaesaeseseesessoesnesaesaessesaevevenvaneaneaneneesnesaesansans 41 Select objects for COM PAPiSON ceseeteeesesseeseesesseveeeseeseeseeseeseesaesoesesseesessoesoesausaesaesaevevenvanesneaneneesnesaesansaes 44 Renamed ODjCCHS aeae raene aman saarep ea aaar eotea paa
63. ext to find ALTER x Options Direction Case sensitive i ee Be ae ees poe Forward Whole words only Regular expressions Backward Scope Origin Global From cursor Selected text Entire scope Mark search result with stack marker showa cancel Hel Direction Forward Searches from the current position to the end of the SQL Script Editor area Backward Searches from the current position to the beginning of the SQL Script Editor area 1999 2015 EMS Database Management Solutions Ltd 115 DB Comparer for Interbase Firebird User s Manual Scope Global Searches within the entire SQL Script Editor working area in the direction specified by the Direction setting Selected text Searches only within the currently selected text in the direction specified by the Direction setting You can use the mouse or block commands to select a block of text Origin From cursor The search starts at the cursor s current position and then proceeds either forward to the end of the scope or backward to the beginning of the scope depending on the Direction setting Entire scope The search covers either the entire block of selected text or the entire script no matter where the cursor is in the Editor area depending upon the Scope options 1999 2015 EMS Database Management Solutions Ltd ne DB Comparer for Interbase Firebird User s Manual 9 2 Replace Text dialog The Replace
64. g 4 Show message after successfully executed script Close progress dialog after successful completion 7 Confirm close project Default Cancel Help Show message after successfully executed script Toggles the Script executed successfully message upon successful script execution Close progress dialog after successful completion If this option is selected the project dialog is closed automatically when the operation is completed successfully Confirm close project If this option is set you are prompted for confirmation each time when you exit the project See also Preferences Project Options Compare Options Fonts Localization Colors 7 1 4 Compare Options This section of the Environment Options dialog allows you to set specific parameters of comparison for each type of database objects 1999 2015 EMS Database Management Solutions Ltd a DB Comparer for Interbase Firebird User s Manual Select an object type in the object tree set a flag to include the object type into the comparison process and define Compare properties in the corresponding group within the Compare Options tab The Script generation group allows you to specify whether a specific type of script CREATE ALTER DROP should be generated for objects of the selected type The Select All Unselect All and Invert Selection buttons are implemented to make options selection easier Environment Options Px
65. he Foreground color control to open the Color dialog allowing you to select the required color from the palette Click the Background color control to select the required color using the Color dialog or leave the default value white if no background color is necessary for the selected text fragment 1999 2015 EMS Database Management Solutions Ltd oa DB Comparer for Interbase Firebird User s Manual See also General Display Quick Code 7 2 4 Quick Code W Code completion If this option is checked then on typing the first characters in SQL Script Editor you are offered several options for the word completion as a popup list an analogue of the Code Insight list in Delphi IDE The code completion list popups after a delay defined by the Delay option W Code parameters If this option is checked the Delphi like hint for key words is enabled Delay sec Using this option you can change the time for code completion popup Editor Options xa Ei General Display Color B Quick Code 7 Code completion Code parameters Automatic features Delay sec 1 Keyboard templates Use keyboard templates Quick code list options Sort by scope Sort by name Use keyboard templates Allows you to use keyboard templates for faster typing of regularly used expressions see Keyboard templates 1999 2015 EMS Database Management Solutions Ltd 2 DB Comparer for Interbase Fir
66. he comparison options can be saved in Project icp files A project file can be also used in the Console version of DB Comparer for Interbase Firebird For your convenience the console version of DB Comparer for Interbase Firebird is included in the distribution package of the utility The command line utility is intended for quick and powerful database structure comparison and synchronization Usage lt path to DB Comparer for Interbase Firebird console application gt IbComparerC exe Project_FileName Output_FileName E Project_FileName Stands for the icp file to be used as the console version execution parameter See Opening Saving Project for instructions on saving project files Output_FileName Specify the output file name to save the modification script generated by the utility If not specified the script will be saved as Project_FileName sq in the home directory of DB Comparer for Interbase Firebird E Execute generated script after comparison Examples C Program Files EMS DB Comparer for Interbase amp Firebird IbComparerC exe DBComparer_Project icp Upon running the command line utility the modification script will be generated into DBComparer_Project sq C Program Files EMS DB Comparer for Interbase amp Firebird IbComparerC exe DBComparer_IB icp Result sq Upon running the command line utility the modification script will be generated into Result sq C Program Files EMS DB Comparer for
67. he source database but do not exist in the target database Only target objects that exist in the target database but do not exist in the source database Identical objects in the source database coincide with the ones in the target database Numbers in brackets next to the captions of the group nodes denote the amount of objects inside each group The objects which are identical in both databases are displayed in black by default You can customize all the colors using the Colors section of the Environment Options dialog If Forward Navigation is enabled within the Project Options section of the Environment Options dialog upon selecting an element in the Database Tree the corresponding entry will be selected in the Modification scripts window Note You can expand and collapse lists of objects quickly using the context menu Moreover the context menu of the DB Tree allows you to open the appropriate modification scripts in SQL Script Editor 1999 2015 EMS Database Management Solutions Ltd 53 DB Comparer for Interbase Firebird User s Manual Database Tree shared testdb ib2010 employee gdb shared testdb ib2010 E 8 Database objects B Different 8 E Tables 1 Eg Eza PROJECT PROJECT E Fields 5 Constraints 3 E Indices 1 Triggers 28 Procedures 7 E e Only source 5 w Tables 1 S S S S S S S S S S S
68. ion available within the Compare Options tab of the Project Options dialog e Now you can view the project options just before the project loading Check the 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual Show Project Options before Loading option available within the Project Options section of the Environment Options dialog to enable this feature e Added two new options to the Project Options section of the Environment Options dialog Enable Forward Navigation and Enable Backward Navigation Using these options you can customize the navigation behavior If the forward navigation is enabled you can navigate between the generated SQL scripts by selecting the proper objects from object trees and vice versa if the backward navigation is enabled e Now you can copy the Object definition to the clipboard e Some small improvements and bug fixes Scroll to top Version 1 0 Basic features e Comparing databases on one server as well as on different servers e Synchronous navigation between database objects with displaying the corresponding scripts for modifying databases Possibility of execution modification statements one by one or all together Possibility of editing modification statements and changing their order Built in SQL Script Editor with syntax highlight An ability to work with several compare projects at once as well as save and load projects with all their parame
69. irebird User s Manual K gt Ll Summary Info with Chart lo foe agul ox 0 uB w gt Close Master database C shared testdb fb21 alen fdb Target database C shared testdb fb21 alen1_copyfdb Generated 13 06 2012 30 12 1899 16 17 24 Legend Only Master objects exist in C shared testdb fb21 alen fdb but there is no in C Shared testdb fb21 alen1_copy fdb Only Target objects exist in C shared testdb fb21 alen1_copy fdb but there is no in C shared testdb fb21 alen fdb Different objects exist n both databases but are different a icity IRAE ras a ae a hacen ac a a ee 1 l j l i i i EE Total i i i i i i i Different Database Triggers E Only Master A A E st Deran acces Led olen dn EES PEETS OET aad SEESE EE Only Target ee a a a E identical Roles oo a Blob Fitters j So ca a acer ae seecebeccsepesces 17 i i e A E ET O ae t H r r Page1 of1 A Summary Info The result of this report is a table with the summary numeric information about compared databases 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual ATOE w QAGB SHURA u 1 Summary Info Master database C shared te stdb fb21 alen fdb Target database C shared testdb fb21 alen1_copy fdb Generated 13 06 2012 30 12 1899 16 18 06 Element Different Only Master Only Target Identical Domains 2 10 3 Tables 3 49 View
70. is list displays all currently existing toolbars of DB Comparer both default and user defined toolbars Check uncheck the box at a toolbar name to show hide the toolbar New Use this button to add a new user defined toolbar to the Toolbars list Set a name for the newly created toolbar and dock it by dragging it to any permitted location within the application window Rename Use this button to rename the selected user defined toolbar Delete Use this button to delete the selected user defined toolbar Reset Use this button to reset the selected toolbar 1999 2015 EMS Database Management Solutions Ltd 121 DB Comparer for Interbase Firebird User s Manual IV Window List Commands This tab allows you to browse the list of all commands available within the menus and toolbars of the application window Selecting categories in the Categories list displays commands of the selected category e g File or Options in the Commands list If necessary you can pick a command and drag it to any toolbar to create a button for this command Options Categories Commands U Exit View Options New Project Wind Help ii Save Project As Menus i Edit Open Project Window List Save Project Editor Menu Gutter Bag Menu s Close Project Dannan Drainat Description 1999 2015 EMS Database Management Solutions Ltd 122 DB Comparer for Interbase Firebird User s Manual Options Pers
71. isabled links will be painted grayscale independently of the selected bar style See also Trees and lists Edit controls Check boxes Buttons Page controls Group boxes Splitters 1999 2015 EMS Database Management Solutions Ltd 96 DB Comparer for Interbase Firebird User s Manual 7 3 2 Trees and lists Use the Trees and lists section of the Visual options dialog to view and edit the corresponding options Visual Options xs Scheme name Office 11 style Save As Delete og Bars and menus EAJ Trees and lists Look amp feel Edit controls Ultraflat M Check boxes 3 Hide selection Buttons CS Page controls v Native style 3 Group boxes 4 gt Splitters item 1 Column 1 Column 2 ltem 2 ltem 1 Subitem 1 ltem 3 ltem 2 Subitem 2 C erce ee Look amp feel This setting determines the manner in which tree and list elements are painted Use the drop down list to select the painting style that will be applied to the trees and lists Standard Flat UltraFlat W Hide selection This option specifies how selected tree nodes and list items are displayed when focus leaves the tree or list control If this option is enabled selected nodes look like other nodes Otherwise selected nodes items are highlighted within the tree list W Native style This option determines whether the native Windows style will be applied to the trees and lists The op
72. lbar H Open All Scripts in SQL Script Editor Summary Info Summary Info with Chart Detailed Report Detailed info This sample report provides you with the complete list of compared database objects with their DDL properties and their values 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual GL D 4GH 4 82 o QEG S3HUF u 3 NEW_PROCEDURE_12_NEW Procedure Unique Target Script DROP PROCEDURE NEW_PROCEDURE_12_NEW Procedure Unique Target Procedure Unique Target Script DROP PROCEDURE TABLE1_D x Body Declare Has Resultset Header Input Params Output Params xxx KK Identical Property Name Master Value x Body x Declare x Has Resultset x Header x Input Params x Output Params NEW_PROCEDURE_12_NEW_1 Script DROP PROCEDURE NEW_PROCEDURE_12_NEW_1 Identical Property Name Master Value x Body x Declare x Has Resultset x Header x Input Params x Output Params TABLE1_D Identical Property Name Master Value Target Value BEGIN AS Yes NEW_INPARAM SMALLINT NEW_OUTPARAM SMALLINT Target Value BEGIN AS Yes NEW_INPARAM SMALLINT NEW_OUTPARAM SMALLINT Target Value BEGIN AS No Page 3 of 38 Summary Info With Info Chart Use this sample report to get graphical summary info about the compared databases 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase F
73. lowed as long as the actual content is not altered or edited in any way Document generated on 16 07 2015 3 DB Comparer for Interbase Firebird User s Manual Table of Contents Part Welcome to DB Comparer for Interbase Firebird 6 What S NOW siscecscsesecceed E E E E tes Decade E A 7 System requirements cccccececsercrsceceeeeneesesesesesesesnsesesesesnsasnsesesasanasesasasanesasesesenasasansnasananes 8 ECU ENN a rE EE EE E EE T T 9 Registration is tiiinesii renskinn enairada aoui atenen eniai a encheres etian aone a eaa k arii aoni h atda aeris anui ia rannis 10 How to register DB Comparer rssernrnnnrnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nnmnnn nnmnnn nnmnnn 12 Version hiStOFY s secccecececececeeeceeeceseseseceeesnaeseseseanseaennneanannnanseseseananseneanaeseanansnsasasaseaasanaasaasanaaes 14 Other EMS PROGUCUS tiiccce ccesccnecs naani cnan nedor anaana anna aaa aneo i dahana a ceina iwe daN 18 Part II Getting started 25 First time started cccccccceeseceeeeeseeeeeseeeeeeseeeeeeeseseeeeeseseaeesseseeesususeanaaueseanaauuseanageessonsuessongues 27 Using context MONUS cceccccsesssseeeeeeseeescaseseenenseeeccausaseeneeseeeceauaaseesenseeeeeauaassesensesseeaeaaseenenees 29 DB Tree Conte xt MENU ou csscscsssssssensensussussessussnsonsnesaosnseaueasssosnosensnasansaseansaneusausausaesnesaesneeaeansanteasanausasensnasansaasans 29 Script CONT EXt MENU cess sesseeseseeeeseeseeseeseessess
74. nt dll for Firebird Please note that the client library file must be located on your local machine e g in the directory where the utility is installed Bear in mind that the path to the database file should be set relatively to the Interbase Firebird server file system Click the B button of the Database file field to specify the location of the Interbase Firebird database file using the standard Open file dialog Authentication type Select the preferable type of server authentication to be used for the connection e Normal traditional IB FB authentication with security database e Win32 NTLM authentication only FB 2 1 or above e Mixed Security DB Authorized Interbase Firebird users are stored in a security database Each Interbase Firebird server has its own security database which means that a user definition is bound to the server where it is stored The security database also stores an encrypted password for each user 1999 2015 EMS Database Management Solutions Ltd 4 DB Comparer for Interbase Firebird User s Manual Type in or use the B button to specify the path to the security database The drop down list contains the previously specified security databases If you are using the EMS SQL Management Studio for Interbase Firebird version of DB Comparer for Interbase Firebird then the Select registered database button is available Click this button to pick a database already registered in the EMS SQL Management
75. o mouse movements WI Shadow If this option is selected a shadow is displayed for the edit controls W Native style This option determines whether the native Windows style will be applied to the edit controls The option has the highest priority for edit controls If this option is selected the edit controls are painted according to the native Windows style regardless of other painting settings Note The Native style option is currently supported for the Windows XP operating system only 1999 2015 EMS Database Management Solutions Ltd 9 DB Comparer for Interbase Firebird User s Manual See also Bars and menus Trees and lists Check boxes Buttons Page controls Group boxes Splitters 7 3 4 Check boxes Use the Check boxes section of the Visual options dialog to customize the border style and the appearance of check boxes and radio buttons Visual Options x Scheme name Office 11 style Save As Delete oqu Bars and menus Eal Trees and lists Border style Edit controls Ultraflat zl Me Check boxes Buttons V Hot track CS Page controls Shadow O Group boxes 7 Native style 4 gt Splitters Sample radio group 4 Sample check box re Sample radio item 1 Sample radio button Sample radio item 2 ima He Border style This setting determines the manner in which check box and radio group borders are painted Use the drop down list to s
76. onalized Menus and Toolbars M Menus show recently used commands first This option determines whether the most frequently used items will be placed in menus at first position If this option is enabled frequently used menu items are promoted and displayed higher on the list Unused and infrequently used menu items are visually suppressed and appear collapsed M Show full menus after a short delay This option is available only if the Menus show recently used commands first option is selected If this option is enabled infrequently used menu items if they appear collapsed will be automatically expanded after a delay upon setting mouse cursor or upon selection with the Up Down keys on the bottom of the menu Otherwise the menu expands only after clicking its bottom most button or using the Ctri tDown shortcut Reset my usage data Resets the lists of recently used commands in the toolbars and menus 5 Customize goscessoesesegessessesssea h Personalized Menus and Toolbars MV Menus show recently used commands first j Show full menus after a short delay Reset my usage data Other Large icons V Show ToolTips on toolbars j Show shortcut keys in ToolTips Menu animations None v Close Other M Large icons This option displays larger icons on the parent window toolbars M Show ToolTips on toolbars 1999 2015 EMS Database Management Solutions Ltd 123 DB Comparer for Interbase Fi
77. opped marker will be moved to the current cursor position and the cursor will be set 1999 2015 EMS Database Management Solutions Ltd e DB Comparer for Interbase Firebird User s Manual to the initial marker position e implementation of the Find Text and the Replace Text dialogs contributes to more efficient work with the SQL code Each of these operations can be also performed with the corresponding hot keys used When all the script parameters are set you can immediately execute the script in SQL Script Editor To execute a script press the F Execute toolbar button or use the F9 hot key for the same purpose See also Getting started Managing Projects Working with Project Reports management DB Comparer Options Console application 1999 2015 EMS Database Management Solutions Ltd e DB Comparer for Interbase Firebird User s Manual 6 Reports management DB Comparer for Interbase Firebird provides Report Designer for creating powerful reports By default the Reports panel is located on the right side of the project window Using its toolbar buttons you can create delete rename view and edit reports e Report Designer e Sample reports Reports Report File FullReport Objec List of object properties fe According to current Table View Detailed Infot Detailed Info eport Info eport HR Report Inf HR R Info See also Getting started Managing Projects Working with Project
78. ral options of the DB Comparer application To open the Environment Options window select the Options Environment Options main menu item or use the dh Environment Options button on the main toolbar G Project Edit View Windows Help Environment Options KEL Editor Options H Keyboard Templates Visual Options Select Program Language Preferences Project Options Confirmations Compare Options Fonts Localization Colors The Default button located at the bottom of the Environment Options form can be used to set option values to defaults See also Editor Options Visual Options Keyboard Templates Preferences W Disable multiple instances Checking this option prevents one from running multiple instances of DB Comparer for Interbase Firebird W Save passwords into project file If this option is checked database connection passwords are saved in project files W Show splash screen at startup Displays the splash screen of DB Comparer for Interbase Firebird at the application 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual startup Reports directory Use the B Explorer button to specify the directory where DB Comparer reports will be stored by default Environment Options a a Project Options General E Confirmations F Disable multiple instances aa Dpiane 4 Save passwords into project
79. ralian Dollars Canadian Dollars or Swiss Franks by Credit Card Visa MasterCard EuroCard American Express Diners Club Bank Wire Transfer Check or Cash If you have ordered EMS software online and would like to review your order information or if you have questions about ordering payments or shipping procedures please visit our Customer Care Center provided by Share it Please note that all of our products are delivered via ESD Electronic Software Delivery only After purchase you will be able to immediately download the registration keys or passwords and download links for archives of full versions Also you will receive a copy of registration keys or passwords by e mail Please make sure to enter a valid e mail address in your order If you have not received the keys within 2 hours please contact us at sales sqlmanager net To obtain MORE INFORMATION on this product visit us at http sqlmanager net en products ibfb dbcomparer Product distribution EMS DB Comparer for Interbase Firebird Business license 1 Year Maintenance EMS DB Comparer for Interbase Firebird Business license 2 Year Maintenance EMS DB Comparer for Interbase Firebird Business license 3 Year Maintenance Register EMS DB Comparer for Interbase Firebird Non commercial license 1 Now Year Maintenance EMS DB Comparer for Interbase Firebird Non commercial license 2 Year Maintenance EMS DB Comparer for Interbase Firebird
80. rebird User s Manual If this option is selected ToolTips hints popup when the mouse cursor is positioned over a toolbar button M Show shortcut keys in ToolTips If this option is selected the corresponding shortcuts are displayed in ToolTips hints for toolbar buttons Menu animations Use the drop down list to specify the menu animation effects None no animation Random random choice Unfold Slide Fade Unfold unfolding menus Slide sliding menus Fade menus fade in when appearing 1999 2015 EMS Database Management Solutions Ltd 124 DB Comparer for Interbase Firebird User s Manual Credits Software Developers Michael Kuzevanov Alexey Butalov Dmitry Schastlivisev Alexander Zhiltsov Technical Writers Semyon Slobodenyuk Dmitry Doni Olga Ryabova Cover Designer Tatyana Mak urova Translators Anna Shulkina Serge Fominikh Team Coordinators Alexey Butalov Alexander Chelyadin Roman Tkachenko 1999 2015 EMS Database Management Solutions Ltd
81. red correctly in some cases Fixed now Sometimes an error occurred while refreshing databases Fixed now Altering procedures scripts were generated incorrectly Fixed now Fixed the error with comparing views and other minor improvements and small bug fixes Scroll to top Version 2 1 e Now the direction of synchronization can be saved in the project file also can be used by the Console application Now it is possible to specify the client library Export to Excel Text XML and HTML formats is now available from the Grid view New more detailed console application log is implemented Now it is possible to select fields from the list when creating user reports Hints for the objects in tree are now displayed correctly 1999 2015 EMS Database Management Solutions Ltd 16 DB Comparer for Interbase Firebird User s Manual e When creating a new report its pages used to be missing Fixed now e When changing Compare Options for a project the Access Violation error emerged Fixed now Scroll to top Version 2 0 Completely re designed top of the art user interface Ample opportunities for customizing your working environment New way of browsing differences between compared databases Easy viewing of all different properties of database objects Ability to print a pre defined differences report or create a new one New advanced comparison options Improved sync script generation Multilanguage support e A lot of other improvements and
82. rer for Interbase Firebird User s Manual Please enter the registration information you received when purchasing Database Comparer for InterBase and Firebird Registration Name Registration Key See also Registration 1999 2015 EMS Database Management Solutions Ltd m DB Comparer for Interbase Firebird User s Manual 1 6 Version history Full version history is available at http www sqlmanager net products ibfb dbcomparer news Version 4 0 e Significantly improved algorithm of object comparison and script generation e Now it is possible to search and analyze renamed objects The application analyzes databases and creates a list of objects that might have been renamed Added wizard for project work e Advanced list of compared object properties allows to make database analysis more complete Significantly improved work with object dependencies Added support of new features of Microsoft Windows 7 Microsoft Windows 8 8 1 progress indicator at task pane and project jump list Data types processing improved Correct checks comparison with names generated by a server Objects comments comparison added Procedures views and triggers bodies comparison improved Fields domains and functions parameters comparison is improved considering field charset and default database charset Expression indices comparison added Autoincrement field property comparison added Cyclic objects dependencies processing added O
83. rer for Interbase Firebird User s Manual data as a whole or partially re SQL Query for DB Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for DB2 Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top Tools amp components Advanced Data Export Advanced Data Export Component Suite for Borland Delphi and NET will allow you to save your data in the most popular office programs formats Advanced Data Export NET i Advanced Data Export NET is a component suite for Microsoft Visual Studio NET 2003 2005 2008 and 2010 that will allow you to save your data in the most popular data formats for the future viewing modification printing or web publication You can export data into MS Access MS Excel MS Word RTF PDF TXT DBF CSV and more There will be no need to waste your time on tiresome data conversion Advanced Data Export will do the task quickly and will give the result in the desired format Advanced Data Import Component Suite for Delphi and C Builder will allow you to Pq Advanced Data Import import your data to the database from files in the most popular data formats 30 gt Advanced PDF Generator f Advanced PDF Generator for Delphi gives you an opportunity to create PDF documents with your applications writ
84. rking area of SQL Script Editor is available within the Script tab of the editor window and is provided for working with SQL scripts in text mode The drop down list above the main working area allows you to select the database for the script execution The status bar area at the bottom is used to view the log of the execution process successful execution reports and error messages if any are listed in this area For your convenience the syntax highlight code completion and a number of other features are implemented If necessary you can enable disable or customize most of SQL Script Editor features using the Editor Options dialog You can set the delay for code completion within the Quick code section of the Editor Options dialog or manually activate the completion list using the Ctrl Space shortcut The Database combo box allows you to switch source target databases where the script is to be executed 1999 2015 EMS Database Management Solutions Ltd st DB Comparer for Interbase Firebird User s Manual LOCATION PHONE_NO HAS SELECT CAST NULL AS SMALLINT CAST NULL AS VARCHAR 15 CAST NULL AS VARCHAR 20 CREATE TABLE PROJ DEPT BUDGET FISCAL YEAR INTEGER NOT NULL PROJ_ID PROJNO NOT NULL Toggle Bookmarks gt Collect Marker DEPT_NO DEPINO NOT NULL S QUART_HEAD CNT INTEGER 4 PROJECTED BUDGET BUDGET Go to Line Number Swap Marker The object has a circula correction script a Lut
85. rties except for the database name only once 1999 2015 EMS Database Management Solutions Ltd 3 DB Comparer for Interbase Firebird User s Manual Source Database Connect O ptions Tunneling Host userver B Login sysdba Port 32010 x Password peneem Role Cien chase NONE a Database file hared testdb ib2010 employee gdb x gt Network Protocol TCP IP B Security DE e Client library C LIBS Nibxe gds32 dll D Library for InterBase Client 10 0 1 335 Both databases on the same server Connection options Enter Interbase Firebird host name in the Host field and specify the preferable Network protocol TCP IP NetBEUI Novel SPX Local Embedded The Host drop down list contains the list of already used hosts Enter Interbase Firebird port to connect through in the Port field Afterwards you should specify authorization settings Login and Password The default superuser name is SYSDBA and the default password is masterkey If necessary use the drop down list to specify the preferable Client charset to be used by the application You also need to specify the Role optionally the path to the Client library and the path to the Database file gdb for InterBase or fdb for Firebird in the corresponding fields For successful connection to the server it is crucial to use the appropriate client library the one that is compatible with the server you are using gds32 dll for InterBase and fbclie
86. s Roles Blob Filters Database Triggers Select All Unselect All Invert Selection Computed By Position Help Save Project Select object type in the Database object tree set a flag to include the object type into the comparison process The Select All and Unselect All buttons in the popup menu are implemented to make option selection easier Define Compare properties in the corresponding group within the Compare Options tab Filter Options For your convenience the filter of object names is added By default filter by mask is used A valid mask consists of literal characters sets and wildcards Each literal character must match a single character in the string The comparison to literal characters is case insensitive Each set begins with an opening bracket and ends with a closing bracket You can use standard wildcards such as asterix or percent sign which are the same or the question mark 1999 2015 EMS Database Management Solutions Ltd 3 DB Comparer for Interbase Firebird User s Manual Compare Options Filter Options Filter 0 9 J Case sensitive 4 Regular expression Always exclude following objects tempcount tempresult To apply filter using regular expression check the Regular expression option Enable Case sensitive op
87. s Procedures UDFs Exceptions Generators Blob Filters Roles Database Triggers Total Legend Only Master objects exist in C shared testdb fb21 alen fdb but there is no in C shared testdb fb21 alen1_copy fdb Only Target objects exist in C shared testdb fb21 alen1_copy fdb but there is no in C shared testdb fb21 alen fdb Different objects exist n both databases but are different 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 7 DB Comparer Options DB Comparer for Interbase Firebird provides full customization of the program interface windows behavior various options of all tools and more This chapter informs you how to use these options The following list contains the three basic groups of options available in DB Comparer for Interbase Firebird Environment Options General DB Comparer options environment style confirmations project options compare options fonts colors and more Editor Options Customizing of the SQL editing tool SQL Script Editor Visual Options Customizing program interface bars trees menus etc See also Getting started Managing Projects Working with Project SQL Script Editor Reports management Console application 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 7 1 Environment Options Environment Options allow you to customize gene
88. ssible with the Ctrl and Shift keys used Modification scripts shared testdb ib201 0 employee gdb gt shared testdb ib2010 emp gdb shared testdb ib2010 emp gdb gt shared testdb ib2010 employee gdb o gt CREATE VIEW CUSTOMER _VIEW CUST_NO CUSTOMER CONTACT_FIRST CONTACT_LAST PHONE_NO ADDRESS_LINE1 ADDRESS _LINE2 CITY STATE_PROVINCE wd CREATE VIEW PHONE LIST EMP NO FIRST NAME LAST NAME Find in DB Tree PHONE EXT LOCATION 3 Execute Selected Scripts PHONE _NO 4 Execute All Scripts AS Gara AARS of Open Selected Scripts in SQL Script Editor EEES A AANE CREATE TABLE PROJ DEPT BUDGE Open All Scripts in SQL Script Editor FISCAL YEAR INTEGER NOT PROJ_ID PROJNO NOT NULL DEPT_NO DEPTNO NOT NULL QUART _HEAD CNT INTEGER 4 PROJECTED BUDGET BUDGET Move Script First Move Script Up amp Move Script Down amp Move Script Last amp The object has a cird script gt CREATE PROCEDURE SUB_TOT Bul v 4 1i J Script type According to the kind of difference between objects in the Source and the Target 1999 2015 EMS Database Management Solutions Ltd s DB Comparer for Interbase Firebird User s Manual databases DB Comparer generates the following modification scripts amp ALTER script if there are different objects with the same name in the Source and the
89. system color from the list or use the t ellipsis button to open the Color dialog allowing you to select the required color from the palette 1999 2015 EMS Database Management Solutions Ltd s DB Comparer for Interbase Firebird User s Manual See also Preferences Project Options Confirmations Compare Options Fonts Localization 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 7 2 Editor Options Editor Options dialog allows you to set the parameters of SQL statements viewing and editing in DB Comparer for Interbase Firebird To open the Editor Options window select the Options Editor Options main menu item or use the 4 Editor Options button on the main toolbar Windows Help d Environment Options Editor Options Visual Options 4 Keyboard Templates Gh Project Edit View Select Program Lanquage General Display Color Quick Code See also Environment Options Visual Options Keyboard Templates 7 2 1 General W Auto indent If this option is checked each new indention is the same as in the previous line in SQL Script Editor Indents and outdents are used in the process of text editing to make the source code easier to read Insert mode f this option is checked the insert symbols mode is on by default 4 K Use syntax highlight nables syntax highlight in the editor area m
90. t Solutions Ltd DB Comparer for Interbase Firebird User s Manual See also First time started Managing Projects Working with Project SQL Script Editor Reports management DB Comparer Options Console application 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual 2 1 First time started This is how DB Comparer for Interbase Firebird looks when you start it for the first time EL Database Comparer for InterBase and Firebird Project Edit View Options Windows Help DAAR x The main menu allows you to perform various operations Project cre a new project or open an existing one view edit database connection settings and project c ire options save the current project close the project exit the application Edit the database synchronization script eit Script Editor effectively activate deactivate the Source object definition and t object definition windows show hide the reports panel Manage toolbars within the View menu Customize application options and localization Ke T using items of the Options menu Manage DB Comparer Windows Access Registration information and product documentation using the corresponding items available within the Help menu To start pn with pion Interbase Firebird databases you should du ate t or p _ if it already exists and adjust database t and oje pare opt for th
91. t margin in the editor window Gutter width Defines the gutter width in the editor window eE General O ol Dipl Margin and Gutter ff Color eee a Quick Code Visible right margin Right margin Gutter width Visible gutter 80 Le 30 Editor font Size T Courier New 1 0 v Sample Text 12345 Editor font Size Use these options to set the editor font and its size The box below displays the sample text with the selected font applied 1999 2015 EMS Database Management Solutions Ltd 90 DB Comparer for Interbase Firebird User s Manual See also General Color Quick Code 7 2 3 Color In the Color section of the Editor Options dialog you can set the background colors and text attributes Bold Italic Underlined used by the editor to mark out different text fragments Default Comments Strings SQL Keywords Numbers Wrong Symbols Identifiers Symbols Tables Selected Text etc Editor Options g Displa Element Foreground color Text attributes ae 000000 Bole A Quick Code Comment a Wi String Background color SOL Keyword Unde Number not selected Link Wrong Symbols Use defaults for Symbol AT Tables ois Selected Text E CREATE TABLE EMPLOYEES EMPLOYEE_ID integer NOT NULL LAST_NAME varchar 20 NOT NULL CITY varchar 50 DEFAULT M ageagor CONSTRAINT PK EMPLOYEES PRIMARY KEY EM i Cramment 7 an an a G N Use t
92. te save and open saved projects To make your work easier you can create a project configure and save it and open the project when necessary instead of setting all the parameters each time you need to run database comparison in DB Comparer for Interbase Firebird You can modify options of an existing project any time your work with it To do so load the project in DB Comparer then press the Project Options button on the toolbar You can also use the Ctrl P shortcut for the same purpose Creating Project Openin Saving Project Compare Project Wizard See also Getting started Working with Project SQL Script Editor Reports management DB Comparer Options Console application 1999 2015 EMS Database Management Solutions Ltd 35 DB Comparer for Interbase Firebird User s Manual 3 1 Creating Project To start working with DB Comparer for Interbase Firebird you should either create a new project or open an existing one The project file contains connection information about the Source and the target databases a number of comparison options Project Edit View Options windows Help Fa New Project Ctrl N gt Open Project Shift F10 Reopen Project To create the new project select the Project New Project main menu item or use the I New Project button on the toolbar you can also use the Ctr N shortcut for the same purpose Then you need to set connection properties for
93. ten on Delphi or C Builder Advanced Query Builder Advanced ste Builder is a powerful component suite for Borland Delphi and C Builder intended for visual building SQL statements for the SELECT INSERT UPDATE and DELETE clauses Advanced Excel Report for Delphi is a powerful band oriented generator of template based reports in MS Excel T Advanced Excel Report Advanced Localizer Advanced Localizer is an indispensable component suite for Delphi for adding multilingual support to your applications Source Rescuer at EMS Source Rescuer is an easy to use wizard application for Borland Delphi and C py Builder which can help you to restore your lost source code Scroll to top 1999 2015 EMS Database Management Solutions Ltd 25 DB Comparer for Interbase Firebird User s Manual 2 Getting started DB Comparer for Interbase Firebird gives you an opportunity to contribute to efficient Interbase Firebird server administration and development by running database comparison and synchronization operations easily and quickly The succeeding chapters of this document are intended to inform you about the tools implemented in the utility Please see the instructions below to learn how to perform various operations in the easiest way First time started Using context_ menus Selecting program language Enjoy your work with DB Comparer for Interbase Firebird Modification scripts shared testdb ib
94. ters Customizable and easy to use MDI Interface e A wide variety of options for customization Keyboard templates for faster editing SQL scripts and more Scroll to top See also What s new 1999 2015 EMS Database Management Solutions Ltd 18 DB Comparer for Interbase Firebird User s Manual 1 7 Other EMS Products Quick navigation a g J 2 MySQL Microsoft SQL PostgreSQL InterBase Oracle IBM DB2 Tools amp FireBird components MySQL 89 SQL Management Studio for MySQL EMS SQL Management Studio for MySQL is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for MySQL Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for MySQL Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for MySQL Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for MySQL Migrate from most popular databases MySQL PostgreSQL Oracle DB2 InterBase Firebird etc to MySQL Data Generator for MySQL Generate test data for database testing
95. ther improvements and bug fixes Version 3 2 Database comparison speed is considerably increased e Other minor improvements and bug fixes Version 3 1 e When comparing a Firebird 2 0 database with the one on the Firebird 2 1 identical views used to be marked as different Fixed now e The modifying script used to be generated twice for domains with different size of type Fixed now e When comparing databases on Chinese Windows localization the Error RichEdit line insertion error message used to appear Fixed now e Other minor improvements and bug fixes Version 3 0 e Comparing and synchronization of databases or schemas on different servers as well as ona single server 1999 2015 EMS Database Management Solutions Ltd 15 DB Comparer for Interbase Firebird User s Manual e Comparing all database objects or selected ones only Comparing by all or selected properties of objects only Visual representation of the differences between databases with details and modification scripts for the different objects e Ability to synchronize databases manually step by step or automatically e Ability to generate reports with database differences Ability to add custom reports e Ability to automate the database comparison and synchronization using the Console Application Working with several compare projects simultaneously Saving and loading projects with all their parameters A wide variety of options for comparison and synchronization
96. tion has the highest priority for trees and lists If this option is selected the tree nodes and list items are painted according to the native Windows style regardless of other painting settings 1999 2015 EMS Database Management Solutions Ltd DB Comparer for Interbase Firebird User s Manual Note The Native style option is currently supported for the Windows XP operating system only See also Bars and menus Edit controls Check boxes Buttons Page controls Group boxes Splitters 7 3 3 Edit controls Use the Edit controls section of the Visual options dialog to customize the appearance of various DB Comparer for Interbase Firebird edit controls Border style Button style Button transparency etc Scheme name Office 11 style Save s Delete w Basondmenus eiO Trees and lists Border style Button style Edit controls uU Itraflat iy uU Itratlat Check boxes Buttons Button transparency Page controls None Left Group boxes 7 Hot track Right Splitters F Shadow Top 7 Native style Bottom Sample text edit Sample button edit fi Sample combo box Border style Button style 1999 2015 EMS Database Management Solutions Ltd 98 DB Comparer for Interbase Firebird User s Manual Use these drop down lists to specify the style around an editor the edit control borders and select the painting style that will be applied to th
97. tion to make the regular expression filter case sensitive Always exclude following objects Enter the objects one on the line that you do not want to be compared To delete filter condition you may use the Clear Filter button of the Database objects popup menu W Analyze dependencies Enable this option to sort the modification scripts taking object dependencies into consideration Case sensitive comparing Enable this option to make the comparing process case sensitive Note that you can use a Case sensitive filter as well just turn on the corresponding option W Analyze renamed objects This option enables disables comparing tables and fields which might have been renamed Add comments to generated script 1999 2015 EMS Database Management Solutions Ltd a DB Comparer for Interbase Firebird User s Manual Use this option to toggle comments in modification script lt Previous step Next step gt See also Setting database options Setting compare options Select objects for compare Renamed objects 3 3 3 Select objects for comparison You can review objects for both databases at this step Compare Project Wizard Choose the objects for comparison On Source and Target Name in Source Name in Target E Domains 15 Tables 9 GE Procedures 8 EH Exceptions 5 DB CUSTOMER_CHECK CUSTOMER_CHECK Comparer Ay CUSTOMER_ON_HOLD CUSTOMER_ON_HOLD for A ORDER_ALREADY_SHIPPED O
98. tions Ltd 31 DB Comparer for Interbase Firebird User s Manual 2 3 Selecting program language The Select Language dialog allows you to select one of the available interface localizations to be applied to DB Comparer for Interbase Firebird To open this dialog use the Options Select Program Language main menu item The window contains the list of available languages according to the directory specified within the Localization section of the Environment Options dialog Select Language x Default no localization English French Deutsch Russian ima He Select a language in the list and click OK to apply changes See also First time started Using context menus 1999 2015 EMS Database Management Solutions Ltd 32 DB Comparer for Interbase Firebird User s Manual 2 4 Switching windows The Windows Toolbar allows you to switch between child windows easily like in Windows Task Bar To activate the window you need simply click one of the window buttons m DBComparerProjects Project1 icp Project Projecti Project Project2 SQL Script Editor Project2 See also Viewing Summary Info Browsing Database Tree Viewing Objects Definition Information window Working with Modification Scripts 1999 2015 EMS Database Management Solutions Ltd 34 DB Comparer for Interbase Firebird User s Manual 3 Managing Projects DB Comparer for Interbase Firebird allows you to crea
99. tribution package from the download page available at our site unzip the downloaded file to any local directory e g C unzipped e run IbComparerSetup exe from the local directory and follow the instructions of the installation wizard after the installation process is completed find the DB Comparer shortcut in the corresponding group of Windows Start menu If you want to upgrade an installed copy of DB Comparer for Interbase Firebird to the latest version e download the DB Comparer for Interbase Firebird distribution package from the download page available at our site e unzip the downloaded file to any local directory e g C unzipped e close DB Comparer application if it is running e run IbComparerSetup exe from the local directory and follow the instructions of the installation wizard See also System requirements 1999 2015 EMS Database Management Solutions Ltd 10 DB Comparer for Interbase Firebird User s Manual 1 4 Registration To make it easier for you to purchase our products we have contracted with share it registration service The share it order process is protected via a secure connection and makes online ordering by credit debit card quick and safe The following information about share it is provided for your convenience Share it is a global e commerce provider for software and shareware sales via the Internet Share it accepts payments in US Dollars Euros Pounds Sterling Japanese Yen Aust
100. ty for the group boxes If this option is selected the group boxes are painted according to the native Windows style regardless of other painting settings Note The Native style option is currently supported for the Windows XP operating system only 1999 2015 EMS Database Management Solutions Ltd 105 DB Comparer for Interbase Firebird User s Manual See also Bars and menus Trees and lists Edit controls Check boxes Buttons Page controls Splitters 7 3 8 Splitters Use the Splitters section of the Visual options dialog to customize all DB Comparer splitters to your liking Visual Options lt Scheme name Office 11 style Save As Delete s Bars and menus Eal Trees and lists Hot zone style Edit controls Windows XP task bar z M Check boxes Buttons J Hot zone drags a splitter ES Page controls O Group boxes 40 gt EMIGE ima He Hot zone style This setting determines the manner in which splitter hot zones are painted Use the drop down list to select the hot zone style that will be applied to the splitters Windows XP task bar Media Player 8 Media Player 9 Sim ple 1999 2015 EMS Database Management Solutions Ltd 106 DB Comparer for Interbase Firebird User s Manual None hot zone is disabled 7 Hot zone drags a splitter This option is applied when the Hot zone style value is different from None and specifies whether the
101. zation item of the context menu Moreover the context menu of the Object Definition area allows you to copy the DDL displayed within the area to Windows clipboard By default the Object Definition windows are located at the bottom of the project window under the Modification scripts window For your convenience visual representation of definition differences is implemented you can see the corresponding DDL differences highlighted in both Object Definition windows If necessary you can customize the colors using the Colors section of the Environment Options dialog Master Object Definition E 5 Target Object Definition o E CREATE VIEW NEW_VIEW CREATE VIEW NEW_VIEW COUNTRY D1 CURRENCY ID2 AS jas SELECT COUNTRY WITH CURRENCY WCTE_A id fid 1 f_id2 AS SELECT id fid_1 fid FROM COUNTRY CTE_B id AS SELECT id from NEW_TABLE1 SELECT fid 1 id2 FROM CTE_A JOIN CTE_B ON CTE A Note You can show hide these windows using the View Source Object Definition and the View Target Object Definition main menu items See also Viewing Summary Info Browsing Database Tree Information window Working with Modification Scripts Switching windows 1999 2015 EMS Database Management Solutions Ltd 55 DB Comparer for Interbase Firebird User s Manual 4 3 Information window The Information window displays detailed information on the database objects being compared Information

DB Comparer for Interbase/Firebird

Contents

Download Pdf Manuals

Related Search

Related Contents