How can we help you today? How can we help you today?

SNIPPETS MIGRATOR TOOL

Hello,

Here it is...the snippet migrator for all those who have been waiting to port your very own snippets from v3 to v4!

PLEASE READ THE FOLLOWING NOTES BEFORE TRYING TO RUN THE SNIPPET MIGRATOR TOOL:

Use the tool only if you have any user-defined snippets created in v3 that you want to migrate to v4.
Before you can use the Snippet Migrator, you need to make sure that SQL Prompt is installed and the SQL Prompt snippet directory has been created.

To do this:
1) On the SQL Prompt 4 menu of your SQL editor (SSMS/VS/QA) select Snippet Manager
The Snippet Manager dialog box is displayed.
2) Close the Snippet Manager dialog box.
The Snippets folder is created in your Red Gate directory.
3) Exit your SQL editor, and ensure the SQL Prompt tray application is not running.
You can now use the Snippet Migrator.

Kindly note SQL Prompt 4 does not allow special characters or numbers in snippet names, so any snippets you have with these characters in the name will not be migrated.

Download link:
http://downloads.red-gate.com/extras/SQ ... porter.exe

Disclaimer: The Snippet Migrator is a standalone tool that is not supported by Red-Gate Software Ltd.

Thanks,
Tanya
Project Manager
Red Gate Software Ltd
tanya
0

Comments

2 comments

Sort by
  • fatherjack2
    Tanya,

    Thanks for the application but what are the special characters that arent allowed in the snippet names?

    The reason that I ask is this:
    I have one that was called b_r
    I have run the import and it returned a 'successful' message
    when I start typing 'b_' the snippet popup show the full snippet but when I hit enter only 20 lines of it are placed on the SSMS script editor.

    I havent restarted the PC totally yet but have closed SSMS and SQL Prompt4 several times with no change in behaviour.

    EDIT:
    OK, rebooted PC and problem still exists.
    Further investigation seems to be that the snippet is streamed to the editor as far as the $ symbol in a UNC reference. The line references a backup location "...-- N'\\Backup1\backups$\sql\..." but after typing the snippet shortcut I only get "...-- N'\\Backup1\backups" on the editor document.

    I have changed the snippet name from "b_r" to "backupr" and this hasnt made any difference. Changing the $ to "...-- N'\\Backup1\backups**\sql\..." results in the whole snippet being pasted onto the editor.

    Oddly, a few lines previous to the line with the $ in the network location there is a "$CURSOR$" which works fine.

    I realise this application is unsupported but wonder if this is important for the import process for SQL Prompt4 release?
    END EDIT:

    2ndEDIT!
    The snippet tool seems to have had issues with the $CURSOR$ too - it put it out in plain text rather than locating the cursor there. Hadnt noticed this at time of first edit.
    ENDEDIT!

    Jonathan
    fatherjack2
    0
  • tanya
    Hello Jon,

    Thank you for bringing this issue to our notice.
    This is actually a bug in snippets wherein we fail to insert any code followed by the $ sign:(
    But don't worry, we will have it fixed by the final release and I will update the forum posting.

    Thanks again and excuse us for any inconvenience caused!

    Regards,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.