How To Install perl-SQL-Translator on Rocky Linux 8

In this tutorial we learn how to install perl-SQL-Translator on Rocky Linux 8. perl-SQL-Translator is Manipulate structured data definitions (SQL and more)

Introduction

In this tutorial we learn how to install perl-SQL-Translator on Rocky Linux 8.

What is `perl-SQL-Translator`

SQL SQL table definitions into other formats, such as other vendor-specific SQL, ER diagrams, documentation (POD and HTML), XML, and Class classes. The main focus of SQL for other structured data formats, including Excel spreadsheets and arbitrarily delimited text files. Through the separation of the code into parsers and producers with an object model in between, it’s possible to combine any parser with any producer, to plug in custom parsers or producers, or to manipulate the parsed data via the built-in object model. Presently only the definition parts of SQL are handled (CREATE, ALTER), not the manipulation of data (INSERT, UPDATE, DELETE).

We can use yum or dnf to install perl-SQL-Translator on Rocky Linux 8. In this tutorial we discuss both methods but you only need to choose one of method to install perl-SQL-Translator.

Install perl-SQL-Translator on Rocky Linux 8 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

After updating yum database, We can install perl-SQL-Translator using dnf by running the following command:

sudo dnf -y install perl-SQL-Translator

Install perl-SQL-Translator on Rocky Linux 8 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

After updating yum database, We can install perl-SQL-Translator using yum by running the following command:

sudo yum -y install perl-SQL-Translator

How To Uninstall perl-SQL-Translator on Rocky Linux 8

To uninstall only the perl-SQL-Translator package we can use the following command:

sudo dnf remove perl-SQL-Translator

perl-SQL-Translator Package Contents on Rocky Linux 8

/usr/bin/sqlt
/usr/bin/sqlt-diagram
/usr/bin/sqlt-diff
/usr/bin/sqlt-diff-old
/usr/bin/sqlt-dumper
/usr/bin/sqlt-graph
/usr/share/doc/perl-SQL-Translator
/usr/share/doc/perl-SQL-Translator/Changes
/usr/share/doc/perl-SQL-Translator/README
/usr/share/man/man1/sqlt-diagram.1.gz
/usr/share/man/man1/sqlt-diff-old.1.gz
/usr/share/man/man1/sqlt-diff.1.gz
/usr/share/man/man1/sqlt-dumper.1.gz
/usr/share/man/man1/sqlt-graph.1.gz
/usr/share/man/man1/sqlt.1.gz
/usr/share/man/man3/SQL::Translator.3pm.gz
/usr/share/man/man3/SQL::Translator::Diff.3pm.gz
/usr/share/man/man3/SQL::Translator::Filter::DefaultExtra.3pm.gz
/usr/share/man/man3/SQL::Translator::Filter::Globals.3pm.gz
/usr/share/man/man3/SQL::Translator::Filter::Names.3pm.gz
/usr/share/man/man3/SQL::Translator::Generator::DDL::MySQL.3pm.gz
/usr/share/man/man3/SQL::Translator::Generator::DDL::PostgreSQL.3pm.gz
/usr/share/man/man3/SQL::Translator::Generator::DDL::SQLServer.3pm.gz
/usr/share/man/man3/SQL::Translator::Generator::DDL::SQLite.3pm.gz
/usr/share/man/man3/SQL::Translator::Generator::Role::DDL.3pm.gz
/usr/share/man/man3/SQL::Translator::Generator::Role::Quote.3pm.gz
/usr/share/man/man3/SQL::Translator::Manual.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::Access.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DB2.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DBI.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DBI::DB2.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DBI::MySQL.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DBI::Oracle.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DBI::PostgreSQL.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DBI::SQLServer.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DBI::SQLite.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::DBI::Sybase.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::Excel.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::JSON.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::MySQL.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::Oracle.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::PostgreSQL.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::SQLServer.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::SQLite.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::Storable.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::Sybase.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::XML.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::XML::SQLFairy.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::YAML.3pm.gz
/usr/share/man/man3/SQL::Translator::Parser::xSV.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::ClassDBI.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::DB2.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::DiaUml.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::Dumper.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::GraphViz.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::HTML.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::JSON.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::Latex.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::MySQL.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::Oracle.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::POD.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::PostgreSQL.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::SQLServer.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::SQLite.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::Storable.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::Sybase.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::TT::Base.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::TT::Table.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::TTSchema.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::XML.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::XML::SQLFairy.3pm.gz
/usr/share/man/man3/SQL::Translator::Producer::YAML.3pm.gz
/usr/share/man/man3/SQL::Translator::Role::BuildArgs.3pm.gz
/usr/share/man/man3/SQL::Translator::Role::Error.3pm.gz
/usr/share/man/man3/SQL::Translator::Role::ListAttr.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Constants.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Constraint.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Field.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Index.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Object.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Procedure.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Role::Compare.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Role::Extra.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Table.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::Trigger.3pm.gz
/usr/share/man/man3/SQL::Translator::Schema::View.3pm.gz
/usr/share/man/man3/SQL::Translator::Types.3pm.gz
/usr/share/man/man3/SQL::Translator::Utils.3pm.gz
/usr/share/man/man3/Test::SQL::Translator.3pm.gz
/usr/share/perl5/vendor_perl/SQL
/usr/share/perl5/vendor_perl/SQL/Translator
/usr/share/perl5/vendor_perl/SQL/Translator.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Diff.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Filter
/usr/share/perl5/vendor_perl/SQL/Translator/Filter/DefaultExtra.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Filter/Globals.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Filter/Names.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Generator
/usr/share/perl5/vendor_perl/SQL/Translator/Generator/DDL
/usr/share/perl5/vendor_perl/SQL/Translator/Generator/DDL/MySQL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Generator/DDL/PostgreSQL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Generator/DDL/SQLServer.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Generator/DDL/SQLite.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Generator/Role
/usr/share/perl5/vendor_perl/SQL/Translator/Generator/Role/DDL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Generator/Role/Quote.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Manual.pod
/usr/share/perl5/vendor_perl/SQL/Translator/Parser
/usr/share/perl5/vendor_perl/SQL/Translator/Parser.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/Access.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DB2
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DB2.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DB2/Grammar.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI/DB2.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI/MySQL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI/Oracle.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI/PostgreSQL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI/SQLServer.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI/SQLite.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/DBI/Sybase.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/Excel.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/JSON.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/MySQL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/Oracle.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/PostgreSQL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/SQLServer.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/SQLite.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/Storable.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/Sybase.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/XML
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/XML.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/XML/SQLFairy.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/YAML.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Parser/xSV.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer
/usr/share/perl5/vendor_perl/SQL/Translator/Producer.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/ClassDBI.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/DB2.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/DiaUml.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/Dumper.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/GraphViz.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/HTML.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/JSON.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/Latex.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/MySQL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/Oracle.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/POD.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/PostgreSQL.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/SQLServer.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/SQLite.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/Storable.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/Sybase.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/TT
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/TT/Base.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/TT/Table.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/TTSchema.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/XML
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/XML.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/XML/SQLFairy.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Producer/YAML.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Role
/usr/share/perl5/vendor_perl/SQL/Translator/Role/BuildArgs.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Role/Debug.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Role/Error.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Role/ListAttr.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema
/usr/share/perl5/vendor_perl/SQL/Translator/Schema.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Constants.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Constraint.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Field.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Index.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Object.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Procedure.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Role
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Role/Compare.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Role/Extra.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Table.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/Trigger.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Schema/View.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Types.pm
/usr/share/perl5/vendor_perl/SQL/Translator/Utils.pm
/usr/share/perl5/vendor_perl/Test
/usr/share/perl5/vendor_perl/Test/SQL
/usr/share/perl5/vendor_perl/Test/SQL/Translator.pm
/usr/share/perl5/vendor_perl/auto
/usr/share/perl5/vendor_perl/auto/share
/usr/share/perl5/vendor_perl/auto/share/dist
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml/diagram.tt2
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml/layer.tt2
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml/schema.tt2
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml/uml-attribute.tt2
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml/uml-class-all.tt2
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml/uml-class-end.tt2
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml/uml-class-start.tt2
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/DiaUml/uml-class.tt2
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/PrecompiledParsers
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/PrecompiledParsers/Parse
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/PrecompiledParsers/Parse/RecDescent
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/PrecompiledParsers/Parse/RecDescent/DDL
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/PrecompiledParsers/Parse/RecDescent/DDL/SQLT
/usr/share/perl5/vendor_perl/auto/share/dist/SQL-Translator/PrecompiledParsers/Parse/RecDescent/DDL/SQLT/README

References

perl-SQL-Translator website

Summary

In this tutorial we learn how to install perl-SQL-Translator on Rocky Linux 8 using yum and dnf.