Post reply

automate the process of database uploading from local system to dbsever

  • July 3, 2009 at 1:25 am

    #211872

    I have a local system and I have a DB server.From local system to DBserver only port 1433 is open.From local system first I have to connect VPN and then I can connect the DB server.

    I want to automate the process of database uploading from local system to dbsever.Can it be possible?if yes please tell..

    URGENT .....

    Thanks

  • July 7, 2009 at 11:58 pm

    #1021482

    You can create a VPN connection through a batch file. At this website you can see how to do that: http://www.aeonity.com/frost/howto-windows-xp-vpn-into-remote-location

    From the batch file you can use the SQLCMD command to execute other queries. Through scheduled tasks you can execut the batch file at a certain time or multiple times.

  • April 30, 2014 at 3:39 am

    #1709747

    You could use this tool on the server to connect to your local DB and retrieve the DB as BAK file: BAK to local

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply