Search Results for "sql server xml"

sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). ...

Copyright © 2014 Neil Butterworth. If you have any dealings at all with data and databases, then you almost certainly will have to deal with comma-separated values (CSV) data. Unfortunately, the CSV files you are given, or are required to produce, never seem to be in quite the right format for your particular business application. And because of the structure of CSV records, using standard text processing tools like sed, awk and perl is not as simple as it might...

Windows command line tool for data extraction in CSV format. Supports 14 major databases: DB2 Advanced Enterprise Server DB2 Advanced Workgroup Server DB2 Developer Edition DB2 Enterprise Server DB2 Express DB2 Express C DB2 Workgroup Server Exadata Infobright Informix IDS Informix Innovator C MariaDB MySQL Oracle Oracle XE PostgreSQL SAP Sybase ASE SQL Lite SQL Server Enterprise SQL Server Express Sybase IQ Sybase SQL Anywhere TimesTen

Command line tool, that compares Microsoft SQL Server table data between tables with the same columns in different databases. Original databases are not modified. Results are saved as SQL command file or displayed to the console. Multi threaded, open sourced project, that should fill empty niche for this kind of freeware software. As a command line application it can easily be used in batch processing.

Jisql is a Java based utility to provide a command line interactive session with a SQL server. It can connect to any database with a JDBC driver.

This is a command-line tool, written in perl, that will convert from any database supported by perl DBI that also supports the information_schema standard to a MySQL database. It was written to convert from SQL Server to MySQL.

A simple to use and configurable command line tool which generates effective lines of code (eLoc) summaries for any text based programming language. By default, it currently supports the following file types: java, xml, sql, cs, css, js, and more.

Z-SQL is a package-oriented SQL language designed for Microsoft SQL Server. Full language specification is provided. The compiler translates Z-SQL to SQL Server's native T-SQL. A command line tool, zsql, that superseeds osql is also included.