2SQL lets you easily import several data files that are instantly available as SQL tables. You can then write queries using the tables.
While my day job revolves around creating and managing AD and Google users (and creating amazing logo’s like above), 2SQL can be used for any scenario where you have CSVs, TSVs or Fixed Width data files.
A Quick Look
In this screen capture below, we’ve taken exports from AD and our SIS to write a Powershell script for creating AD accounts for new students. This script is one of the more complex examples.
(This demo data is included with the 2SQL download)
In the demo, three new students were found. A ready to paste Powershell script was created like this:
For a less complex example, I’ve created a short walkthrough video. In this example, we’re suspending Google accounts for students no longer in our system.
2SQL is written in XOJO Professional 2024. It has SQLite built in, so no other SQL software is required.
This is freeware, and is a public beta.
The software does not have or need an installer. Just unzip it anywhere, and start using it. To get rid of it, just delete it.
Two folders are created on first launch.
‘2SQL Projects’ is created in your Documents folder.
‘2SQL’ is created in your AppData folder.
This page barely scratched the surface. I will be creating several more pages detailing how to get the most out of 2SQ, and linking them from this page soon.
2SQL - In Depth
·
October 10, 2024
Web Design and Product Documentation are not my strong suit, so it is what it is.
Download Here
https://expressshare.com/downloads/2sql.zip
Comments are desired. I’m aware that my web skills and demo’s are rubbish, but what do you think of the program?
No posts
Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.