How to copy database using trigger in qvw?

[#1]

Hi,

Is there any way to create a trigger in qvw to copy database from one folder to another folder?

I have a access database in D folder. I need to copy the database from D folder to E folder daily. I am doing this manually . Is there any way to automate this using qvw with trigger.

can anyone suggest me please.

Thanks.

[its_anandrjs]

You can use BAT files for copy database from one folder to another folder.

[#3]

Thanks. can you post any example path of batch file

suppose I need to copy database from D:\Access\Employee.accdb   to E:\newAccess\Employee.accdb

In this case how can I create batch file?

[#4]

Hi,

I'm using supporting tasks with a powershell script.

QMC -> System -> Supporting Tasks -> External Programs

Regards

Michael

Update:

Script check a folder recursive and copy all qvd from source (chnage at script) to destination (chnage at script). The structure of sub folders will created at destination by the script.

You can define some env vars to use the script for more than one source and destination folders.

example command line

powershell QVD_copy.ps1 \\QlikViewServer\QVData\ DailyBackup

[sudeepkm]

you can create a bat file with one command like below. Save this file as FileCopy.bat

move D:\Access\Employee.accdb E:\newAccess\Employee.accdb

Then use this bat in your QlikView Script

EXECUTE FileCopy.bat;

[#6]

Thanks. Can you help me with sample script please.

[#7]

Thanks. when I am using EXECUTE in qvw it is showing a message like attached. Where I need to give this?

[its_anandrjs]

Write a BAT file like

Copy D:\Access\Employee.accdb   E:\newAccess\Employee.accdb

and save the Bat file as Copy.Bat

and in windows double click on the Copy.Bat or you can write Run Copy.Bat

On command prompt you have to write this.

[#9]

Thanks. How can I change the above path if I want to copy and replace the existing database?

[jerrysvensson]

Maybe you should ask someone from IT to help you?