Follow

How do I move the database to another server/PC?

  • Start up Lime Easy as usual, against the old computer / server.
  • Go up to the Help menu and select System Information
  • In the system information, you can see the path to the database, documents, templates, and mail merge .

 

  • Usually they are in the same subfolder. In my case above is the database, documents and templates in the H: \ Lundalogik \ Lime Easy
  • Close Lime Easy on all PCs. No one may be working in the database when it is moved.
  • Open Windows Explorer and navigate to the folder (in my case H: \ Lundalogik \ Lime Easy)
  • Select and copy the folders Database, Documents, Templates and Mail merge
  • If you have access to the new server over the network, you can click your way in explorer to a suitable place. Create a new folder called Lime Easy and paste what you copied. The copying may take a very long time depending on the size of the document folder.
  • If you don't have the network to the new server (or computer), you can temporarily store information in eg a USB memory stick.
  • When the copy is finished, you should do the old database is inaccessible to users. It can be done by a network administrator, shut down the old server, or rename the folder to something else. Eg H: \ Lundalogik \ Lime Easyold \. This is done to avoid that users happen to work in the old database.
  • What remains now is to ask about the paths on users' computers. This is done in the database.
  • Windows start button → Applications → → Lime Easy Lime Easy Database Manager. Mark your database, click Properties, and set where your new paths. Do not forget the advanced tab!


This can be effected when you move the database


ODBC

ODBC field uses data sources, which in turn contains paths. These points are probably wrong and needs to be corrected. This is done as follows:

  1. Starting Lime Easy
  2. Go up in the Help menu and select System Information
  3. Double-click the line "Database path". It opens the explorer
  4. In Windows Explorer, open the file ODBC.INI. Possibly you do not see the file extension. It is the file that is of the "Configuration settings".
  5. You should now bring up a text window that looks something like this:


The red row is the interesting one, Connect =. Note that there may be several lines. It creates a connect = per ODBC field theat is used by Lime Easy.

  1. Change the path to point to the new server. Memorize even the file name. In my case the above-named file nummersnurra.dsn
  2. Save your changes and close the window
  3. Now open the DSN file is usually located in the same folder in Windows Explorer. In my case I open the file nummersnurra.dsn
  4. Choose to open the file with Notepad (Notepad), Windows asks which program should open with.


Now you see something that looks like this:

At the bottom of the text you have two paths. These also need to be changed so they are correct.

 
Nomad
If you use the nomads you don't have to do anything special. Nomad installation and settings are located in the database folder. When you moved the database you have also moved nomad.

 
Change the path to the database with many users
There is no easy way to change the path to all users simultaneously. Database setting is saved in the file c: \ windows \ kontakt8.ini. If you have 100's of users can push out a new kontakt8.ini file to users. Otherwise there is nothing faster than manually help the 20 users to point to the new database in the database.

 
Accessing the new server
The person responsible for the server is also responsible for users to have access to the database. Users need full rights to the database, documents, templates, and bulk mail folders.


Check out feature

It does not matter that the users are checked-out when you carry out the move. They must first point on his path in the database, then they can check in as usual.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.