Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to copy database automatically from local server to Remote(qlikview) server


Hi,

I have access database in localserver. And I used to copy that access database daily from Local server to Remote server. I was doing this manually since months. Now I am looking to automate this i,e without manually copying I need to copy the access database daily morning 9am automatically. I don't know whether it is right to ask this question in qlik community or not. But Please could anyone help me in this so that would be really appreciable. Please any solution.

Thanks.

13 Replies
Not applicable
Author

Hi,

When I am trying to move database from source folder to backup folder in the command prompt it is displaying

overwrite the file <Yes/No?All>?

How to write this in the batch file itself so that I don't need to pass Yes daily in the command prompt as I am running this task even when the user is logged off also. Please let me know this.

jerrysvensson
Partner - Specialist II
Partner - Specialist II

Have a look at the link swuehl provided. You will find that you can add the switch /y.

"/y - don't prompt before overwriting existing files."

nicktodd
Creator
Creator

Do you need to copy the file in the first place? Can't you load the Access database directly over the network?

Not applicable
Author

Hi,

Thanks and can you explain please waht is first place means?