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

ALIASES - Port from v3.9 to v4?

I have a MASSIVE list of Aliases - do tell how one can port them into v4...

Thanks!

Follow-up:

Looked at the v3 EngineOptions.xml and the list is in "correct XML" as in: 
<UserDefinedAliases>
    <Count>160</Count>
    <UserDefinedAlias>
      <ObjectName>AddressBook</ObjectName>
      <Alias>ab</Alias>
    </UserDefinedAlias>
</UserDefinedAliases>
But the same options in the v4 file, RedGate_SqlPrompt_Engine_EngineOptions.xml are screwy, as in: 
<UserDefinedAliases><UserDefinedAliases>
  <Count>1</Count>
  <UserDefinedAlias>
    <ObjectName>Orders</ObjectName>
    <Alias>o</Alias>
  </UserDefinedAlias>
</UserDefinedAliases></UserDefinedAliases>
so I can't simply copy-paste from v3 to v4.

Until a working means of porting the Aliases is made known, v4 will be uninstalled and remain that way - a very sorry situation :cry:
PDinCA
0

Comments

7 comments

Sort by
  • simon.jackson
    Oops, looks like we double encoded. If you still wish to try out the v4 EA then you should be able to copy the section from the v3 options file and run it through an html encoder. [ e.g. http://www.barelyfitz.com/projects/encoder/ and select the "HTML entities" option ]

    Thanks for the feedback, we'll look at putting an automated alias upgrade alongside the snippet upgrade in the final version.

    Hope the rest of the EA is better for you!
    simon.jackson
    0
  • bfox
    FYI, I imported my aliases by replicating the exact structure (including the double encoding) using search/replace in a text editor from the 3.9 correctly formatted XML.

    You can see how to do this by adding one alias in v4, then edit the file.
    bfox
    0
  • fatherjack2
    Oops, looks like we double encoded. If you still wish to try out the v4 EA then you should be able to copy the section from the v3 options file and run it through an html encoder. [ e.g. http://www.barelyfitz.com/projects/encoder/ and select the "HTML entities" option ]

    Thanks for the feedback, we'll look at putting an automated alias upgrade alongside the snippet upgrade in the final version.

    Hope the rest of the EA is better for you!

    Does this mean that while we run v4 we wont have the snippet importer?

    If so then I may well uninstall too. The snippets are vital to a smooth experience. Is there no way we could have a standalone exe to import/convert the v3 snippets to v4? This is like testing a new car with only three wheels fitted ...
    fatherjack2
    0
  • tanya
    Hello,

    We will support snippet migration from v3 to v4. Hopefully we should be able to give out a standalone exe to get this done sometime soon.

    I will update the forum to keep you all posted.

    Thank you for your patience.

    Regards,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0
  • PDinCA
    And can you slip in an ALIAS Importer, too, for the Release Candidate PLEASE?

    Confidence level with the two proposed workarounds is LOW - perhaps when the next beta is made available I'll see if hand-crafted porting will work...
    PDinCA
    0
  • tanya
    Hello,

    Snippets Migrator and Alias Importer are both available now :)

    Snippet Migrator:
    http://www.red-gate.com/messageboard/vi ... php?t=9145

    Alias Importer:
    http://www.red-gate.com/messageboard/vi ... php?t=9146

    I hope that makes it easy!

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0
  • PDinCA
    THANKS IN SPADES...

    Reinstalled 4.0 and migrated both snippets and aliases SUCCESSFULLY! :D
    PDinCA
    0

Add comment

Please sign in to leave a comment.