Hi, I downloaded the SQL scripts version 6 following an email I received this morning. I would like to know how I can ad a folder as thos folders that shows by default in left right down corner as you can notice in the snapshot I need to create a new folder called SQL Server scipts version 6, when I click on it I get all scripts displayed in the above panel like all other folders thanks in advance
You can create a new QuickClick library using these steps:
Add -> New Solution Set (right-click bottom pane of QuickClick Library tool windows
Construct a Folder structure ( that matches the v6 scripts directory structure (right-click top pane and select Add-Folder).
Add scripts (right-click top pane and select Add -> Script from File
These will add "linked scripts". If you want the scripts embedded into the XML QuickClick library for portability, you will need to embed the scripts (right-click each script and select Embed in Library).
When I do the 1st step "Add New Solution Set", I get prompted to point to an xml file. In the Textbox, I typed a nme for the folder "SQL-V6", right away a dialog box forces me to search for sql-v6.xml which is not provided in the download
The option "Add a New Solution Set" is not "add to a solution set". This step creates a "new" solution set in the form of an XML file that you designation. If you already have a solution set that you want to add new scripts to, this step can be skipped.
Let me repeat what I said earlier with more explanation:
Step 1 - creates a new Solution Set represented as an XML file. That file has a schema that stores metadata that identifies a folder structure and scripts within that folder structure. Scripts can either be "Embedded" or "Linked" (a pointer to a physical file location). "Embedded" scripts make the XML file more portable, meaning you can give it to someone else or move it from one computer to another more easily.
Step 2 - requires you to construct folders to place the scripts in by using "Add-Folder" context menu option. There is no function in the product that allows you to point to a file folder and add the scripts from that and preserve the physical file folder structure.
Step 3 - is a process to add scripts to a new or existing Solution Set by selecting a folder to place them in. You can't add multiple scripts to a solution set. Only one at a time.
I am completely confused. when I right-click bottom pane of QuickClick, 2 options are there
So how can I have something similar to the above picture ? just beneath the Tab SQL, another one with a nme SQLV6 in which I would like to add the scripts from the V6 of sql scripts I downloaded from Idera.
Another question, I noticed the 3rd menu item "Solution Set from PowerShell.com" but it faults as follows
Right-click anywhere on the bottom half of the QuickClick Library tool pane.Click Add -> New Solution Set...
Name it "SQLv6" and then Save it on the Save As dialog (This creates an empty solution set).
At that point you can select the Solution Set from the list of Solution Sets or hover over folder icons at the bottom of the QuickClick Library pane to select a Solution Set whose name is not showing to select it and work with it.
Note: The panel only displays so many Solution Sets.
You may need to select "Navigation Pane Options.." to select/unselect Solutions Sets to show or reorder them using this dialog:
At that point, you need to replicate the Folder structure by right-clicking inside the white space or selecting the folder icon in the QuickClick menu.
After that, add each script to the Solution Set by right-clicking the folder and selecting Add -> Script from File...