T006_DatFile_BackUpToDatFile_RestoreFromDatFile_UpdateDatabase
T006_DatFile_BackUpToDatFile_RestoreFromDatFile_UpdateDatabase ================================
【ArmPos Hospitality Tutorial】 課程編號: 92f3f51d-78fb-4f87-b770-3839a40e98d2 ----------- 此講義目錄 : https://aclasarmpos.blogspot.com/p/armpos-internal-tutorial.html 此講義YouTube PlayList : ArmPos Hospitality Tutorial(All) https://youtube.com/playlist?list=PLGa5Tzn6r8qHGqXwzy0_i4JAi21sl37u_ ArmPos Hospitality Tutorial(Internal) https://youtube.com/playlist?list=PLGa5Tzn6r8qHhvRh9-tuS3xpQgwMcz9Kp ArmPos Hospitality Tutorial(Customer) https://youtube.com/playlist?list=PLGa5Tzn6r8qFIcfl2r0Jd2lpnYw_5_ve5 SampleFile : https://drive.google.com/drive/folders/1FQKoWkFSMrNrEMN4Gdv6ECMygtHsgg54?usp=sharing ----------- 講義部落格 : https://aclasarmpos.blogspot.com/ Youtube PlayList : https://www.youtube.com/channel/UCyvy6XeA1tS73JpJtjlaRTQ/playlists ================================ ---------------------------- Internal Training : All Customer Training : None ---------------------------- T006_DatFile_BackUpToDatFile_RestoreFromDatFile https://aclasarmpos.blogspot.com/2022/03/t006datfilebackuptodatfilerestorefromda.html T006_01_Summary (1.) T006_02_BackUpToADatFile (2.) T006_03_RestoreFromTheDatFile (3.) T006_04_UpgradeDatabase (4.)
================================ 1. Summary 2. Back up To a DatFile 3. Restore From The DatFile 4. Upgrade Database ================================
1. Summary
-------------------------------------------------------------------------------------------------------------------------------------------------
Summary
-------------------------------------------------------------------------------------------------------------------------------------------------
1.
"DatFile" is one kind of "SQLServer" back up file for whole database which including your sales data, menu data, and more.
I would suggest you to create a "DatFile" to backup your data daily or weekly.
I also suggest you to back up your "DatFile" to "Dropbox, GoogleDrive" or to your portable external hard drive.
------------------------------------------------------------------------------------------------------------------------------------
2.
By default, All the "DatFile" was in the following "Directory"
C:\Program Files (x86)\CYEcrPC\DBBackup\
The "FileName" of "DatFile" should be "yyyymmdd_StoreName_Reason".
------------------------------------------------------------------------------------------------------------------------------------
3.
Dat File
-------------------------------------------------------------------------------------------------------------------------
3.1.
DBBackup\20211207_BlankMenu.dat
"DatFile" is one kind of "SQLServer" back up file for whole database which including your sales data, menu data, and more.
"DBBackup\20211207_BlankMenu.dat" is the "BlankDatabase" for "Armpos Hospitality"
which means there is no "Category", no "Item", and no "SalesRecord".
----------------------------------------------
"DatFile"是一種"SQLServer"備份檔案，可以備份整個資料庫，包括你的銷售紀錄，菜單，和其他。
"DBBackup\20211207_BlankMenu.dat"是"Armpos Hospitality"的"BlankDatabase"(空白資料庫)
這意思是其沒有"Category"(菜單種類)、沒有"Item"(菜單物件)、沒有"SalesRecord"(銷售紀錄)。
-------------------------------------------------------------------------------------------------------------------------------------------------
2. Back up To a DatFile
-------------------------------------------------------------------------------------------------------------------------------------------------
Back up To a DatFile
-------------------------------------------------------------------------------------------------------------------------------------------------
1.
Backup Database
In my case, I would back up to "20220325_CoffeeShop_UpdateMenu.dat".
-----------
Run
C:\Program Files (x86)\CYEcrPC\DBMaintenance.exe
Enter "UserName, Password"
-----------
----------------------------------------------
Select "Backup" Tab,
By default, the "Direction" of your "dat file folder" is the following folder.
C:\Program Files (x86)\CYEcrPC\DBBackup
-----------
Check the "Custom file Name"
Enter the file name as the following.
20220325_CoffeeShop_UpdateMenu
-----------
Click "Backup"
-----------
Database backup complete.
OK
-----------
-------------------------------------------------------------------------------------------------------------------------------------------------
3. Restore From The DatFile
-------------------------------------------------------------------------------------------------------------------------------------------------
Restore From The DatFile
-------------------------------------------------------------------------------------------------------------------------------------------------
1.
Restore "BlankMenu".
In my case, I would restore "20211207_BlankMenu.dat".
-----------
Copy the file "20211207_BlankMenu.dat" to
C:\Program Files (x86)\CYEcrPC\DBBackup\
-----------
Run
C:\Program Files (x86)\CYEcrPC\DBMaintenance.exe
Enter "UserName, Password"
-----------
----------------------------------------------
Select "Restore" Tab,
In "Choose a backup:", enter the path of your "dat file".
In my case,
C:\Program Files (x86)\CYEcrPC\DBBackup\20211207_BlankMenu.dat
-----------
Tick "Force Restore", Click "Restore"
-----------
Do you want to start the program now?
No
-----------
------------------------------------------------------------------------------------------------------------------------------------
2.
Restore from your backup.
In my case, I would restore "20220325_CoffeeShop_UpdateMenu.dat".
-----------
Run
C:\Program Files (x86)\CYEcrPC\DBMaintenance.exe
Enter "UserName, Password"
-----------
----------------------------------------------
Select "Restore" Tab,
In "Choose a backup:", enter the path of your "dat file".
In my case,
C:\Program Files (x86)\CYEcrPC\DBBackup\20220325_CoffeeShop_UpdateMenu.dat
-----------
Tick "Force Restore", Click "Restore"
-----------
Do you want to start the program now?
No
-----------
-------------------------------------------------------------------------------------------------------------------------------------------------
4. Upgrade Database
-------------------------------------------------------------------------------------------------------------------------------------------------
Upgrade Database
-------------------------------------------------------------------------------------------------------------------------------------------------
1.
When you try to make an payment, if you saw the error message like "Invalid column name XXX".
It means you might have to upgrade your Database.
----------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------
2.
Why do you have to upgrade the Database?
"ArmPosHospitality" is a very comprehensive software,
so our software engineer always release the new version of the "ArmPosHospitality" in order to fix bugs or add new features.
In this case, our software engineer might modify the database of the "ArmPosHospitality".
Thus, when our customer upgrade the new version of the "ArmPosHospitality",
our customer might have to upgrade the database.
No worries, it's super easy. Let me demonstrate how to upgrade your database.
------------------------------------------------------------------------------------------------------------------------------------
3.
Update Database
----------------------------------------------
C:\Program Files (x86)\CYEcrPC\UpdateDB\UpGradeCfg.ini
-----------
[set]
ServerName=127.0.0.1
tmpDBName=tmpUpdata
UserName=SA
Password=
SoftFlag=0
DataDir=C:\Program Files (x86)\CYEcrPC\UpdateDB
flag=1
DataBaseName=CYEcrDB
-----------
----------------------------------------------
Execute
C:\Program Files (x86)\CYEcrPC\UpdateDB\UpGrade.exe
-----------
Click "Test Connection"
If the connection is successful, then click "Auto Upgrade"
-----------
-------------------------------------------------------------------------------------------------------------------------------------------------
Comments
Post a Comment