Welcome to our knowledge base. To find what you're after, use the search box below or choose a category to view listed questions.

Search the Knowledgebase

Browse by Category

[Advanced Search]

-- Select Category -- Genesis R&D Genesis R&D SQL Nutrition     - Nutrition: General Database     - Nutrition: General Software     - Nutrition: International     - Nutrition: Labeling     - Nutrition: Nutrients & Nutrient Components     - Nutrition: Recipe Analysis     - Nutrition: Specific Foods The Food Processor The Food Processor SQL Utility Programs     - Database Utility     - ESHA Port SQL     - ESHA Security SQL

Knowledgebase Home > The Food Processor SQL Knowledgebase Home > Genesis R&D SQL

Move the SQL database and/or program to a new computer (or Server)

Would you like to... Print this page Email this page Post a comment Subscribe me Add to favorites User Opinions 100% 0% (10 votes) How would you rate this answer? Helpful Not helpful Help us improve. Why was this unhelpful? Thank you for rating this answer. To move the data to a new computer: Install the same version of Genesis (or The Food Processor) on the new machine. On old machine, Backup the database. Move the physical file (*.bak) to the new machine. On new machine, Restore the database.   -->the steps on this document describe backup and restore. After the above, the new computer will have the same database as the old. On the new computer, you will need to re-add any users of the program.  Even though each user is already in the list, whenever a database changes servers, the users should be re-added to the database.  This document should guide you through this.  This scenario may also apply to a singular, local installation on a new machine -- particularly under Windows Vista or Windows 7. If this is a setup such that the database will be shared and accessed by other computers, you may need to configure the Windows Firewall (if enabled). Also, for a network setup, if you have the program installed locally on each client, there is a change necessary to those client computers.  It is a change to a configuration setting.  Specifically, on the client, there is a Genesissql.ini (or Foodprosql.ini) file. This file is found in    c:\program files\esha research\Genesissql\ (or c:\...\Foodprosql\) In Windows Vista and/or Windows 7, this file may also be found in:    c:\Users\[UserProfile]\AppData\Local\VirtualStore\Program Files\Esha Research\genesissql (or foodprosql) Open this file in a text editor. Change the ServerName= line to point to the appropriate SQL Server (new computer). Save and exit the .ini file. Open Genesis (or The Food Processor).  If no errors, check the Server Name in Help/Information.

Attachments

No attachments were found.

Related Questions

When launching Help, I am met with a Navigation Canceled message. Why is that? Attaching the ESHA Database to SQL Server (using Database Utility) How to Backup and/or Restore the Database An error oppears when searching. (Internal SQL Server error.ADO Errors: 1 -2147217900) How do I configure Windows Firewall to allow clients to connect to SQL Server?

Powered by ActiveKB Knowledgebase Software