For first time set up, run as administrator to get the SQL lite privilege's.
SetupDataExtractionToolv3.8.2.exe
1) Program files make a backup copy of the SQL lite database
2) Local disk C -> Program files -> Asamco -> Data Extraction Tool -> Local Databases -> Copy and paste the database
3) In the local disk -> create DET folder -> create two folders in the DET -> Backup -> SQLITEDB
4) Get the server name from the server management -> SAGE-VM\SQL2014
5) Use the server to also backup databases and to find the names of the databases
6) To create a backup task click on the back up tasks button in the DET
7) Next click on the settings tab:
Click on global settings
In general settings:
- Add the location to the SQLITE and Backup folder locations
- In the Mail settings:
Type in the host address: www.asamco.com OR use smtp.sendgrid.net
Host port: 587
In the Mail log in credentials:
-Email address: klanten@asamco.com
-Email username: apikey
-Email passwords: eeHKEjcs or try: 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
-Use SSL
Fill in the default mail template same as before ( Repeat the previous mail step)
8) Click on the Poll settings:
General Polling settings
-Tick the allow tool for polling
-Endpoint: Select the Asamco server in the drop down menu
-Next tick all three options at the bottom -> Insert, Update and delete.
-Next click the save button
You can now test the connections and execute the backup
Check Endpoints:
Right click, click on edit endpoint
At the bottom, select the usage and use the endpoint used for drop down menu.
Use this link to see if the databases are being backed up and restored.
Note: Only use the Microsoft authenticator if you are setting up the databases for that specific user.
Otherwise leave this option unticked if you see an error message.
Note: Task actions always save the backup task to save the databases to the DET.
9) Fill in the settings information:
Name: Database name
Endpoint: Asamco Server
Zip Name: {1}
Sub Folder: Amatheon / Client name
Don't use the password protect option
Click enabled option
Data source: SQL Server Connection
Connection: Right click and add connection
- Server: SAGE-VM\SQL2014
- Database: AA Zambia Ltd
Tick the evolution database option
Fill in the username: sa password: asamco@123
Test the connection, then click save.
Email template information:
- Mail to: support+aazambia@asamco.com
- Subject: [BU-AA] Backup task: %%BaseTask.Name%% - %%BaseTask.ResultText%% - %%BackupTask.DatabaseName%%
Copy and paste this message in the email field:
Hello!
We've backupped your database. Or at least tried. See below for the details.
Errors found (yes/no): %%BaseTask.HadErrorLastRun%%
General info:
Task name: %%BaseTask.Name%%
Database: %%BackupTask.DatabaseName%%
Backup date: %%BaseTask.LastRunDateTime%%
Zipped file name: %%BackupTask.FormattedZipName%%
Upload location: %%BaseTask.WebserviceLocation%%
Detailed log:
%%BackupTask.Logs%%
%%BackupTask.ServerInformation%%
%%BackupTask.RunningTime%%
Have a nice day!
The Asamco Team
Next click on the Task actions button -> Click on save backup
Click ok to sync now, or click sync after you have added in all your databases.
Windows Task Scheduler
10) Setting up the Task Scheduler in windows:
Click create task:
Name: DataExtractionToolTaskPolling
- Run whether user is logged in or not
- Check the server that windows is running on
Triggers: Daily 12:00:00
Actions: Program/script: C:\Program
Add arguments: Files\Asamco\Data Extraction Tool\DataExtractionTool.exe Polling
Name: DET Backup
- Run whether user is logged in or not
- Check the server that windows is running on
- Run with Highest privilege's
Triggers: Daily 19:00:00
Actions: Program/script: "C:\Program Files\Asamco\Data Extraction Tool\DataExtractionTool.exe"
Add arguments: Backup All
Settings: Tick first 5 options
If task fails - set to 15 minutes
Click these two options in settings tab:
- Run task
- If task fails
Check if the DB is read only:
SELECT name, is_read_only
FROM sys.databases
WHERE name = 'MyDBNAme'
GO
--returns 1 in is_read_only when database is set to read-only mode.