How to Replace xPortalNet Database with Database Data Files (MDF and LDF File Types)

Owned by Tan Rong Wei (Unlicensed)
Last updated: Dec 30, 2020
2 min read

Problem (Issue) Statement:

How to replace xPortalNet database with database data files (MDF and LDF file types)

Description:

A guide to restore xPortalNet database using database data files (MDF and LDF file types) to new Server's PC.

Related Software:

Related Hardware:

NA

System Application:

xPortalNet Standard Software

Symptom and Finding:

After copying and replacing existing physical database data to new Server PC using MDF and LDF file types at C: ProgramData\MicroEngine\xPortalNetv1 folder; when xPortalNet Server is launched, software prompted "Error Adding Transaction" message.

Cause:

The steps to replace existing physical database to new Server PC are done incorrectly, without properly detaching fresh database (empty) from SQL Server and attaching existing database (old database) to SQL.

Solution:

Warning!

  • Users are not recommended to run any xPortal software in Windows XP operating system as the system is unstable

  • Users are also advised to stop the xPortal Services before shutting down the Server PC to prevent any missing transaction issues.

.

.

Summary


Step by Step:

  • To install SQL Server and xPortalNet software and initialize a fresh xPortalNet database:


Knowledge Base Link

.
.

  • To detach fresh xPortalNet database from SQL Server:


Knowledge Base Link

Users can refer to How to Detach xPortalNet database from SQL Server for the complete steps.

.
.
.

  • To replace existing xPortalNet database to new server PC after initializing a fresh database in new Server PC:

Step 1: Ensure that xPortalNet Service, Server and Client are not running. Stop xPortalNet Service if the service is still running. Close all software instances if any of the software instances are still running.


Step 2: Now, users can go to C:\ProgramData\MicroEngine\xPortalNet v1 and paste the existing xPortalNet database data copied earlier:
Pasting the Existing Database Data
Figure 1: Pasting the Existing Database Data


Knowledge Base Link

If users cannot see the Program Data folder, users can refer to How to Gain Access to Program Data Folder in Server PC for the complete steps to gain access to Program Data folder.

.
.
.

  • To attach existing xPortalNet database to SQL Server:

Step 1: After pasting the copied xPortalNet database data, users have to re-attach the existing database to SQL Server.


Knowledge Base Link

Users may refer to How to Attach xPortalNet Database to SQL Server for the complete steps.

.
.
Step 8: After re-attaching the database data to SQL Server, users can now start up xPortalNet Services and open xPortalNet Server software to verify that the existing xPortalNet database is successfully copied to the new Server PC.


Note

If the installed software version in new Server PC is newer than software version where the existing database is copied from, xPortalNet Service may require additional steps to migrate the database. Database migration is run automatically.

Date Documentation:

9/4/2018 (Rev 1.0)

PROOF-READ

.

Related Articles.

Containing the label "sql-database"

.

.

© MicroEngine Technology Sdn Bhd (535550-U). All rights reserved.