Support Center

How do I move a database from one server to another?

Last Updated: Jul 16, 2015 09:57AM EDT
If the version of e-SPECS you are installing on your new server is newer than the one on your existing server, upgrade your existing server, as well as your clients.

Then install the server side of the new version of e-SPECS to the new machine.

Ensure that all client (e-SPECS) applications are closed, and that no one will try to use them while you are performing this process.


PLEASE NOTE WHICH DATABASE(S) YOU NEED TO COPY FROM THE OLD SERVER BEFORE CONTINUING:

1. ESPECS (ESPECS_DATA.mdf)
2. especs_system (especs_system.mdf)
3. ANY CUSTOM OFFICE MASTER (ANY_CUSTOM_OFFICE_MASTER.mdf)


For newer operating systems the default file location is: C:\Program Data\InterSpec\Data40.  The default location for the database files on an XP machine is: C:\Documents and Settings\All Users\Application Data\InterSpec\Data40.


SECTION 1 (To be performed on the machine with the old server)
 
  1. Ensure that no one is using e-SPECS and then search for "Services" or "Local Services" depending on your system (c:\Control Panel\System and Security\Administrative Tools).
  2.  Click on the service named "SQL Server (INTERSPEC40)"
  3.  On the right-hand side click "Stop" the service.

Open Windows Explorer. (Right click on Start > Explore)
 
  1. Navigate to and open the data folder located at C:\Program Data\InterSpec\Data40. (The default location for the database files on an XP machine is C:\Documents and Settings\All Users\Application Data\InterSpec\Data40.) If you still can't locate the data folder you can search the computer for ESPECS_Data.mdf.
  2. Copy each data file (ESPECS_DATA.mdf, especs_system.mdf, ANY_CUSTOM_OFFICE_MASTER.mdf) and save to a different location.  Ideally you want a file location that is shared between this server machine and the new server machine.

SECTION 2 (To be performed on the machine with the new server)
 
  1. Install a fresh e-SPECS server installation on the new server machine.
  2. Search for "Services" or "Local Services" depending on your system (c:\Control Panel\System and Security\Administrative Tools).
  3.  Click on the service named "SQL Server (INTERSPEC40)"
  4.  On the right-hand side click "Stop" the service.

Open Windows Explorer. (Right click on Start > Explore)
 
  1. Navigate to and open the data folder located at C:\Program Data\InterSpec\Data40. (The default location for the database files on an XP machine is C:\Documents and Settings\All Users\Application Data\InterSpec\Data40.) If you still can't locate the data folder you can search the computer for ESPECS_Data.mdf.
  2. With the Data folder still open, create two new folders; one named Out of the Box Databases, and the other named Production Databases.
  3. With the Data folder still open, cut the databases named ESPECS_DATA.mdf and especs_system.mdf and paste them in the folder you named Out of the Box Databases.
  4. With the Data folder still open, copy the databases you saved from the old server machine (ESPECS_DATA.mdf, especs_system.mdf, ANY_CUSTOM_OFFICE_MASTER.mdf) and paste them in the folder you named Production Databases.  This will act as a copy or backup if you will.
  5. With the Data folder still open, paste these same databases from the old server machine (ESPECS_DATA.mdf, especs_system.mdf, ANY_CUSTOM_OFFICE_MASTER.mdf) into the Data folder itself.  There should be no databases here by these names as you have already cut and pasted the out of the box databases into the folder named Out of the Box Databases.
  6. Restart the service:
  • Search for "Services" or "Local Services" depending on your system (c:\Control Panel\System and Security\Administrative Tools).
  •  Click on the service named "SQL Server (INTERSPEC40)"
  •  On the right-hand side click "Start" the service.

NOTE: Custom Office Masters will need to be attached manually. To manually attach a database using SQL Server Management Studio follow the directions listed by Microsoft:

https://msdn.microsoft.com/en-us/library/ms190209%28v=sql.105%29.aspx



SECTION 3 (To be performed on a machine that has the client application installed it)

On a 32 bit machine:

 
  1. Open the Control Panel.
  2. Go to Administrative Tools > Data Sources (ODBC)
  3. Click the System DSN tab.
  4. With ESPECS highlighted, click the Configure button on the right.
  5. The name field should have ESPECS in it.
  6. The server field should have the name of the new server, backslash, INTERSPEC40. (It should Look something like this: NEWSERVER\INTERSPEC40)
  7. Click Next.
  8. Choose Windows NT or SQL Server authentication.
  9. Click Next.
  10. If you do not make it to the next screen, click the Back button and change your authentication method.
  11. Click Next.
  12. Click Finish.
  13. Click Test Data Source.
  14. If the test completed successfully, click OK on all of the ODBC Configuration and Control Panel windows.

On a 64 bit machine:
 
  1. Open Windows Explorer. (Right click on Start > Explore)
  2. Scroll down to the Windows folder and open it.
  3. Find and open the SysWOW64 folder.
  4. Find a file named odbcad32.exe and double click it.
  5. Click the System DSN tab.
  6. With ESPECS highlighted, click the Configure button on the right.
  7. The name field should have ESPECS in it.
  8. The server field should have the name of the new server, backslash, INTERSPEC40. (It should look something like this: NEWSERVER\INTERSPEC40)
  9. Click Next.
  10. Choose Windows NT or SQL Server authentication.
  11. Click Next.
  12. If you do not make it to the next screen, click the Back button and change your authentication method.
  13. Click Next.
  14. Click Finish.
  15. Click Test Data Source.
  16. If the test completed successfully, click OK on all of the ODBC Configuration windows and then close Windows Explorer.

Open the client application.
 
  1. Click File > Open Project.
  2. Ensure that all your projects are listed.

If all your projects are in place on the new server, you can uninstall e-SPECS Administrator, the e-SPECS Database, and the INTERSPEC40 instance on the old server. You can also delete the .mdf and .ldf files you saved on your desktop.

 
544e596190704297fbf7a532558cd6cc@interspecinc.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete