I'm a SQL Anywhere newbie. I've created a SQL Anywhere database using 3rd party software (SAP Business Objects). However, the database file is now located some place I don't want it.
Can someone please tell me what steps I need to perform to move the .db and .log file from, let's say 'C:Mydir' to 'D:Mydir'?
asked 29 May '12, 07:31
Simply make sure the database isn't running and then just move the files. You may also want to check that the transaction log file location has not be "hard-coded" into the database file. run
That's all that needs to be done to move the database files themselves. You'll then have to tell the database server where the file is before it can start it.
answered 29 May '12, 07:38