Questions tagged [razorsql]

RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, Mac OS X, Linux, and Solaris.

RazorSQL provides both easy to use visual tools and advanced features to allow users to do database browsing, editing, management, administration, and programming.

Features:

  • A Database Navigator for browsing database objects;
  • An SQL Editor for creating SQL queries;
  • Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences;
  • Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers;
  • A robust programming editor that embeds the powerful EditRocket code editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more;
  • Export Tool - Export data in various formats;
  • Import Tool - Import data from delimited files, Excel files, or fixed width files into tables;
  • Ships with a built-in relational database engine (HSQLDB) that is up and running out of the box and requires no end-user administration;
  • A Generate DDL Tool for generating table, view, and index DDL;
  • Table / SQL Query Compare tool for comparing tables or queries across multiple connections;
  • Database Data Search tool for searching single or multiple database table and view data;
  • Database Object Search tool for searching for database objects;
  • Backup tools such as the Database Backup Tool and Table Backup Tool;
  • Database conversion tools for many popular databases;
  • Auto column and auto table lookup;
  • SQL Formatter;
  • SQL Query builder tool;
  • SQL Query Scheduler tool;
  • Command Line Interface;
  • PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers;
  • An ASP bridge for connecting to MS SQL Server databases remotely via ASP enabled web servers;
  • SQL GUI Tools for generating SQL for various operations;
  • Edit, delete, and insert database data with the Database Editor;
  • Works with all major operating systems including Windows, Mac OS X, Linux, Solaris, and any other Java enabled OS;
  • Tested with Apache Derby / JavaDB, Daffodil DB, DB2, DBASE, Firebird, FrontBase, H2, HSQLDB / HyperSQL, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, and Teradata.

The official web-site is: http://www.razorsql.com/

48 questions
79
votes
2 answers

PostgreSQL via SSH Tunnel

I'd like to use RazorSQL to connect to my database which is running on a remote server. I create a SSH tunnel on my localhost with the following command: ssh -L 1111:remote.server.com:5432 myuser@remote.server.com I configure my connection via…
kozooh
  • 2,035
  • 1
  • 21
  • 31
12
votes
4 answers

Google Big Query: alternatives to browser SQL editor?

I'm currently working a lot with Google Big Query and I absolutely hate querying in-browser. I'm used to connect to regular DB's through editors like Toad, Microsoft SQL Studio, Teradata Studio Express or Databeaver. I'm look for a similar tool that…
romanoww
  • 121
  • 1
  • 1
  • 6
11
votes
2 answers

How is MongoDb installed by Meteor?

I'm new to both Meteor.js and MongoDB and after installing Meteor in the official way described I wonder how to connect to my MongoDB. MongoDB was installed by Meteor during the installation and everything works fine but now I would like to have a…
Marc
  • 6,749
  • 9
  • 47
  • 78
3
votes
1 answer

What is the easiest way to open/view a Firebird database?

I have a .FDB Firebird file from an commercial Application we don't use anymore. It contains my customer data an I want to export or access it in some manner. I have seen many procedures that require Firebird server installation, JDBC, ODBC drivers,…
Juliomac
  • 447
  • 7
  • 15
3
votes
1 answer

Opening Firebird database (8.15)

I'm close to the end of my tether with this so any help would be gratefully received! Trying to connect with Interbase "IBConsole" and I get the following message: "Unsupported on-disk structure for file C:\TEMP\SYSTEM.GDB; found 8, support…
fritterfatboy
  • 327
  • 2
  • 10
2
votes
2 answers

Cassandra database import issue for timeuuid

I have installed Cassandra 2.2.12 on my window machine locally. I have exported database from live server in a '.sql' file using 'razorsql' GUI tool. I don't have server access for live, only have database access. When i am trying ti import '.sql'…
M.Bains
  • 395
  • 1
  • 2
  • 14
2
votes
1 answer

Dynamodb connection: strange behaviour

I have created an Amazon DynamoDB database in a Docker container using this request: curl -X POST http://192.168.99.100:8000/ -H 'accept-encoding: identity' -H 'authorization: AWS4-HMAC-SHA256…
Victor
  • 385
  • 2
  • 12
  • 26
2
votes
1 answer

redshift convert_timezone does not work

When running Redshift queries using Razor SQL, UTC dates appear to be treated as being in the local timezone, complete with daylight saving times. For example, running SELECT 'first',CONVERT_TIMEZONE('UTC', 'America/New_York', '2016-03-27 …
Tom
  • 172
  • 6
2
votes
1 answer

How to query UCCX stored procedures from informix database using razorsql?

I am new to stored procedures, informix, and UCCX. I am working on a project to consolidate reporting into on BI tool, and it appears there are several UCCX stored procedures that could be great time savers for bringing the UCCX historical reporting…
2
votes
0 answers

Can't get Blob info from derby DB

I have Derby DB V 10.12.1.1 with one table: CREATE TABLE APP.JACKRABBIT_X0020_CORE_NODE ( NODE_ID CHAR(36) NOT NULL, NODE_DATA BLOB(2147483647) NOT NULL ); There are some rows which I can read without any problem but there is one row…
Taras
  • 21
  • 2
2
votes
2 answers

Open h2 database file on Mac OSX

I'm having trouble opening a h2 database file on Mac OS X. I tried 'DbVisualizer' and 'RazorSQL', but h2 file doesn't open up properly. They show weird characters. I'm I doing something wrong or is there a better program to open up a h2 database…
wag0325
  • 1,008
  • 5
  • 18
  • 34
1
vote
1 answer

Created .db file using SQL Anywhere - now query it using RazorSQL

I created a .db file using Sybase SQL Anywhere, with loads of tables and information in it. Now, I dont have access to this Software anymore. So I got RazorSQL, which states on its homepage it can query SQL Anywhere. But how can I connect to my .db…
Ray Ban
  • 67
  • 8
1
vote
0 answers

Derby SQL commands to export to CSV file

I am very new to Apache Derby, and I have a need to export all of the rows from a table into a csv file. I am using RazorSQL to connect to the database. What I need to know is if there is an equivalent Derby SQL command to what MySQL does to export…
Net Admin
  • 181
  • 1
  • 2
  • 9
1
vote
1 answer

RazorSQL profiles, command line calls & windows task user mixup

They might be quite obscure: i enjoy RazorSQL for all it can do, and it is the only tool i found that talks properly is Clarions's ODBC driver. It also allows for awesome command line calls to export data. Trouble is: RazorSQL stores profile…
drew..
  • 3,234
  • 3
  • 16
  • 19
1
vote
1 answer

DB2 query in RazorSQL for getting the next val from a sequence

I am trying to run a DB2 query in RazorSQL for getting the next val from a sequence but getting the following error. Can anybody plz help me out. VALUES NEXT VALUE FOR SEQ_UPLOAD_MASTER; ERROR: An undefined object or constraint name was…
1
2 3 4