Knowledgebase
HORTICOPIA Support > Online Support > Knowledgebase

Ask a question:


Updating to use the SQL Server LOCALDB

Solution

Assumptions

  • The computer is running under Windows 7, 8, or 10
  • Your HORTICOPIA® Professional is a standalone (not a network server) version
  • Your HORTICOPIA® Professional is not the Refresh system

Support Note

We will no longer support new installations that use the full Microsoft SQL Server (Express or other editions). The currentHORTICOPIA® Professional Version V utilizes the Microsoft SQL Local database implementation which greatly simplifies both installation and configuration of the HORTICOPIA® Professional Version V software. 

The Horticopia Data folder

If you have added any of the following data to HORTICOPIA® Professional:

  • Authored plants
  • Pictures added to existing HORTICOPIA® Professional plants
  • User notes added to the My Information tab for any plants
  • Garden Studio® templates that you have created or modified
  • Garden Studio® plant specific data that you have added to any plants under the Garden Studio® tab

and wish to continue to use that data, you will need to save the existing Horticopia Data folder.

If you do not have any of the data described above that needs to be transferred, keep it simple by not attempting to transfer the Horticopia Data folder.

Next, delete the exisiting Horticopia Data folder  

Normally, you can:

  1. Open the Horticopia Control Panel (Start, All Programs, Horticopia Pro V, Horticopia Control Panel).
  2. Click on the Setup tab
  3. Click on Delete the Horticopia Data folder
  4. Let the software delete the Horticopia Data folder. 

If this doesn't work, search the system disk (C:) for Horticopia Data. Be sure to include hidden folders and files in the search. The Horticopia Data folder is typically in the Program Data folder or in the Public Documents folder. Once you locate it, delete it. (Be sure it's not your copy of the Horticopia Data folder that you've saved/backed up.)

Occasionally you won't be able to delete the Horticopia Data folder because the SQL Server has not released the database. The simplest way to resolve this, is to open the Windows Task Manager, select the Services tab, locate the SQL Server, and then right-click on it and select Stop Service. Alternatively, you can reboot the computer.

Install the current version of HORTICOPIA® Professional

You can update yout existing installation by downloading and installing the update that includes the LOCALDB from:

http://www.horticopia.com/updates/UpdateHortProV5.shtml

An alternate option is to use the latest software disk image that replaces your software CD. To do so, see http://www.horticopia.com/hesk/knowledgebase.php?article=98

  • You will be prompted for Update or New Install. You should choose Update.
  • If an existing installation is not detected, you will be prompted for a Standalone or Server installation.   SelectStandalone.
  • In the unusual situation where you have inadvertently selected Server in a previous installation, you should first uninstallHORTICOPIA® Professional and then select New Install instead of Update if prompted.

Run the Program

  • The first time your run the program, you must Run as Administrator by right-clicking on the HORTICOPIA®Professional icon.
  • Even if you will be transferring the Horticopia Data folder that you saved earlier, you need to run the program in order for initialization to be completed.

Import Horticopia Data Folder

1.    Do one of the following:: 

  • If you are already in HORTICOPIA® Professional, from the Tools menu select Launch Control Panel and click on Yeswhen prompted to quit HORTICOPIA® Professional.
  • If you haven't started HORTICOPIA® Professional, go to Start, All Programs, Horticopia Pro V, Horticopia Control Panel.

2.    Click on the Setup tab, then click on Import HORTICOPIA Data from a different location.

3.    Locate the Horticopia Data folder that you saved/backed up earlier and let the data import complete. All of your data will now be successfully transferred and usable.

All Done

It's a good idea to periodically back up your Horticopia Data. This is easily accomplished using the Setup tab in the Horticopia Control Panel. 

 

 
Was this article helpful? yes / no
Article details
Article ID: 131
Category: Backup, Restore, and Moving
Date added: 2016-03-03 10:14:00
Views: 194
Rating (Votes): Article not rated yet (0)

 
« Go back

 
Powered by Help Desk Software HESK - brought to you by Help Desk Software SysAid