SQL Offline supports most popular relational data files and database servers (complete list in the readme which includes installation instructions for client drivers). Create, test, and share connection strings (UDL files).Adaptive SQL Language (DML and DDL adjusts for different servers).For the latest version of Mac OS, use the Software Update feature) Download the file for OS X on the Downloads page. (For 64-bit Intel Macs, download Java for Mac OS X 10.5, Update 1. Formulas and Macros (vbscript with document access) Ensure you have a JDK installed, if not, download here.Spreadsheet Data tools (merge, sort, combine).Create and run SQL script (sync just a few cells, or recreate an entire table).Offline table admin (add columns and constraints).Supports Access (ACCDB, MDB) and Excel (XLSX, XLS) files if Microsoft Office 2008 or later is Installed. Supports SQL Server, Windows Azure SQL Database, SQL Server CE (3.5 and 4.0), MySQL, Oracle, Postgre, SQLite(SQLITE), dBase (DBF, DBC), and others with a connection string (UDL). You can also create and test connection strings (UDL), perform common admin tasks (DDL), and difference check (Synch preview). While offline you can make simple edits, add columns, or (re)create a table. sqldeveloper.sh (run sqldeveloper.sh file) You will be prompted to enter a jdk path. You can later sync when you are ready (by creating SQL script or connecting through a client driver). To install and run Ensure you have a JDK installed, if not, download here rpm -Uhv sqldeveloper- ( build number )-1.noarch.rpm (install the package) cd sqldeveloper (go to sqldeveloper folder). Use SQL Offline to read and edit your tables and queries offline in a spreadsheet.
0 kommentar(er)
