Generating INSERT statement from SELECT using SQuirreL SQL

There are often time during development where you would want to test your application with various type of sample data, and you would want those data to be share with other team member as well.

The scenario that I ran into recently is we have some sample data that was enter to a system through a web interface, and for reports developments purposes we need those data to be shared among the team members, so we start to look into exporting those data out using SQL SELECT statements (with the correct WHERE clause) then converting them to equivalent INSERT statement; there are of cause several ways to do this, but I prefer the easy way, using SQuirreL SQL. The insert script can them be shared among the team members.

Following is the steps for completing this

  1. Install SQuirreL SQL
    • Make sure you have JRE7 installed on your machine
  2. Create connection to you database
    • Depending on your database type you need to use different drivers
    • Create the Alias to your database and enter the right connection strings (this can be tricky sometime)
  3. Start the connection session to you database
    • Select your alias and hit the Connect icon 
  4. Write you select statement and run it (CTRL+ENTER)
  5. Bring up the Tools dialog box (CTRL+T)
  6. Look for sql2ins and hit Enter
  7. Done. You will see INSERT statement will be generated right after your SELECT statements.
You can customize what columns you want on the generated INSERT statement by only specifying them in the SELECT statements, and don't forget you can also limit the records by specifying the where clause in your SELECT statements.

There you go, another magic trick.

Comments

Post a Comment

Popular posts from this blog

OneNote: We need the password to sync this notebook (Error code: 0xE4010643)

Image
It happen to me once and it happen to me twice, and it happen again this morning. When I saw this message, I knew no mater how many times I hit the "Sync All" it will never goes through (but I did it anyway). I found these happen to me if I leave OneNote open, and put the computer to hibernate / sleep mode. Somehow when the computer awake from sleep, OneNote will failed to sync due to the credentials is out of sync.  To avoid this I always close OneNote before putting the computer to sleep and often I simple shutdown the computer. The fix to this is simply delete the cached credential used by OneNote to connect to server for synchronization, and re-login. To do this, follow the following steps ( Make sure you close OneNote before you proceed) : Go to "Control Panel" > "User Accounts and Family Safety" Click "Credential Manager" Click "Manage Windows Credentials" Look for "MicrosoftOffice15_Data:live:c...
Read more

Built-in UITableViewCell's Styles (UITableViewCellStyle)

Image
UITableView has some built-in styles which can be use with in most scenario. You might want to look into these styles before starting to built a customize TableViewCell. There are 4 types of styles for the UITableViewCell , enum representation of this is UITableViewCellStyle . The details is as follow:   UITableViewCellStyleDefault , Default style with label on the left.    UITableViewCellStyleValue1 , Label on the left, and a blue label on the right.    UITableViewCellStyleValue2 , Blue label on the left side (right aligned text), label on the right side (left aligned text).    UITableViewCellStyleSubtitle , This is almost same with the Default style except that it has a grey smaller text under the label. It functions as the description / subtitles. To change the default style of a  UITableViewCell , replace the styles enum in initWithStyle with any of the enum mentioned above, simple as that. Example: // Obj...
Read more