cancel
Showing results for 
Search instead for 
Did you mean: 

Move .db file

Former Member
4,458

Hello,

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'?

Kind regards

VolkerBarth
Contributor
0 Kudos

Just a note: "D:" should be a local drive (which it is, I suppose), not a network share - running SQL Anywhere databases on a network share is not recommended...

Accepted Solutions (0)

Answers (1)

Answers (1)

graeme_perrow
Advisor
Advisor

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 dblog mydatabase.db and it will tell you what it's using for the transaction log file. If it's just the filename (eg. "mydatabase.db" is using log file "mydatabase.log") then you're good to go. If it's a full path, you'll need to use the dblog -t switch to change it.

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.