Lost Settings

I just upgraded to 4.1.7 (from 4.0.34) and I lost all my saved settings, snippets, etc. Is there anything I can do to get them back?

I'd like to assure you that you haven't lost old settings. The new settings are stored in a different folder which is
C:\Documents and Settings\%USER%\Application Data\SQL Assistant\4.1

Your old settings are in
C:\Documents and Settings\%USER%\Application Data\SQL Assistant\4.0

To migrate old settings to the new version, close SQL Assistant (all instances, all editors), copy SQLAssist.sas file from the old folder to the new folder as SqlAssist.sas.old then restart SQL Assistant. This will make it load old settings into the new version.

OK, that saved the day, thank you. I did find one other issue though. I'm guessing the "Copy SQL Code As" default values are stored in the .sas file. When I copied the v4.0 file over to the v4.1, the values in there seemed to have gone away.

You misread my instructions. I asked to copy that file with .OLD extension, not to overwrite new file. Configuration file structure and data are subject to change between versions. Please never override .SAS file from an older version. You now have outdated configuration file which is not guaranteed to work.

Here is what I suggest to do now to restore and merge the settings:
1. Use Restore Default button in SQL Assistant options to revert to default configuration.
2. Shutdown SQL Assistant and all editors.
3. Copy your previous .SAS file with .OLD extension (repeat what you didn't before, just don't override the default .SAS file.
4. Restart SQL Assistant

I still do have the old file and yes I clearly misread your instructions. My bad. Fixing now. Apologies for my inability to follow directions...

Sorry, but I did as you said, BUT it seems I lost my snipplets.
Don't you think that there should be an AUTOMATIC feature that, when you upgrade the software, preserve ALL user settings?

Thanks

Andrea

Yes, there is. If the setup is run with default settings it should automatically load whatever is possible into the new version.

In theory, not everything is always possible to automatically migrate forward without sacrificing new changes in the functionality and ability to make significant improvements in configuration settings and structure.

You can also copy your old file and overwrite the new one, the new version will use it and convert automatically, but then you would lose a couple of the new things.

Is it possible that the reason the settings didn't get updated automatically because of the new "Check for Updates" mechanism? That's how I performed my update.

I'm will need to check this possibility, especially if the setup is not run in this mode with admin privileges.

FYI, I just updated to 4.6 using the "Check For Updates" option and the settings were not carried over. I had to manually use the method above to pull them in.

Would you please email your SQLAssist.sas file from previous version to the support so we can check why the old settings are not picked up automatically.

May I suggest you to automatically apply existing setting if any so that no developers face this challenge when they upgrade their version? It is really a time consuming task to set each option manually again and again when new ver is released. I would be happy to have a checked checkbox control on sql assistance installation setup steps. It may be something like (Do you want to restore your previous settings?).

With Regards
Hitesh

Old settings are supposed to be automatically carried over and merged with new configuration file format. Yet some users have reported that it doesn't work for them. We are looking into this issue and hope to have a fix for it soon.

Old settings are supposed to be automatically carried over and merged with new configuration file format. I have 1st unistall my exisitng ver 4.6 and then installed new ver 4.8 but my old setting are not coming back even after I carried out steps corrtly as given in this forum. This is one area you need to work it out for sure.

Have you had 4.7 installed at any time? If yes, the installation program for 4.8 copied your 4.7 settings, not 4.6 and that's why you don't see them in the new version.

Here is what you can do to copy them. In SQL Assistant Options dialog, click Import/Export button, uncheck Load Default Options checkbox, brows to your %APPDATA%\SQL Assistant\4.6 folder. If you are not sure where this folder is, from DOS prompt run SET command, see value of APPDATA environment variable. Select your previously used 4.6 .SAS file, choose settings you want to copy. Click Import.