Topic: Database
Client/Server Open-Source Database Tips
How to migrate varbinary UTF-8 data to varchar, going from MySQL to MSSQL
This post talks about converting theBitnami MediaWiki v1.34 on Ubuntufrom MySQL v8 database to Microsoft SQL Server 2017. The solution probably applies to any conversion ofvarbinary to varchar data from MySQL v8 to MSSQL2014, 2016 and 2017.The challenge is that these fields, TEXT.old_text and TEXT.
How to backup a remote Firebird SQL database using GBAK
The following BAT file may be of interest if your local machine is not too far away from the database server. It shows how to use the freeGBAKutility to backup a remote Firebird SQL database, with the destination file landing locally.This BAT syntax is for use on Windows.:: backup-sample.bat setlo
Install FirebirdSQL 2.5.8 on AWS EC2 CentOS 7
☑ Launch an EC2 instance from the AWS Marketplace -- look for "CentOS 7 (x86_64) - with Updates HVM" which issupported by CentOS, here. I used a t2.micro instance.☑ Make sure the AWS EC2 firewall ("security group") allows you to SSH in but no one else.☑Display CPU information to confirm what you
Firebird SQL 32-bit client library install on 64-bit CentOS 7
The use-case for this is wanting to run a custom 32bit utility developed in Lazarus with FreePascal, using Interbase Objects for the Firebird SQL connectivity. (As of August 2014, IBObjects worked 32-bit for Linux but not 64-bit. That has since changed.) This particular utility needed to be depl
Firebird SQL Client Library install on CentOS 5 in 2014
August 2014 This is how I was able to install version 2.1 of the 32bit Firebird client library (libfbclient.so) on a 32bit CentOS 5 server.NB: if you are not running as root, you will need to add 'sudo' before most of these commands.First, this is where you can check for the latest available Firebir
Configure custom Morfik app with IIS6 and Firebird
Here are some notes for configuring a Morfik application (DLL) which was in this case compiled with Embarcadero Delphi and using a Firebird SQL database.IIS6 ConfigurationIIS6 needs a web site for each projectI will assume you know how to make a webiste. Point the home directory to the folder contai
Installing Firebird 2.5 64-bit on CentOS 6.2
Media: burn DVD with disk #1 of CentOS 6.2 installerBootto the DVDDuring installation, from the radio button list, selectDatabase Server(and later turn off the 4 default database choices)Unselect a few things that seem unnecessary, like debugging features and phpSelect all the Desktop options, plus
Paradox export to Firebird SQL Import (without DataPump utility)
Requires:1. Dezign Pro for Databases v4 or later2. Paradox 7 for WindowsSteps:1. Use Dezign to IMPORT the table structure from the Paradox database (which is a folder). You can select all or some tables. Do not have Paradox open against the same folder while you do this, otherwise Dezign will load
Company publishing this blog in 2022: HREF Tools Corp. based in Wilmington, Delaware USA Privacy