SQL Anywhere remote migration

[former_member1148180]

Hi all,

I'm working on migrating from SqlAnywhere 16 to 17 and I need my application to migrate automatically, with little or no user interference. In most cases the migration will occur on a client computer side, so I will need to change some things on the server remotely.

Situation 1: I need to create a service on a computer (server) from another computer on the local network (client) to initialize the dbsrv. For this I am using a Windows Services Controller command to create services remotely - example: sc my_server create MyService binPath="$pathsybasedbsrv17.exe" start= auto DisplayName= "Remote Server 17"

Question 1: Can I replace the sc command with some command using DBSVC or some other SqlAnywhere utility to manipulate services on other computers on the network?

Situation 2: On a local network client I run Python scripts to create ODBC data sources on the server remotely.

Question 2: Can I do this using DBDSN or some other SqlAnywhere utility?

Any help would be very much appreciated!

Regards, Mailson.

[chris_keating]

The dbsvc and dbdsn are designed to be run locally only. PsExec and/or Powershell remoting are options to execute processes remotely such as dbsvc or dbdsn.