Change Database File Name?

SmokeScreen · 2006-12-11

I have been asked to change name of our database as the current database.fdb is no longer acceptable

Can this be done using the Service Parameters to change the database path once renamed? Has anyone done this before?

kriki · 2006-12-11

First and for all:
If the database exists of more databasefiles, it is best to take a backup and restore it in a new DB.

This works for 1 databasefile:
-stop the service
-rename the databasefile.
-open the service-properties of the service in services.msc
-in the "start parameters", put >DATABASE="C:\subdir\newdbname.fdb"< (without the < and >)
-start the service from this property-screen. The service will use the new parameter from now on.

Captain_DX4 · 2006-12-11

I've also modified the database path/name directly from within REGEDIT, but again, only will work on single-file databases. Just search on your service name.

David_Singleton · 2006-12-12

try using the paramater:

database=h:\DBpart1.fdb+i:\DBpart2.fdb+DBpart3.fdb+ ...

SmokeScreen · 2006-12-12

We are only running one .fdb file. I just wanted to confirm that the Service Parameter would ACTUALLY work. I thank you all for the responses, I feel more confident that this will be a quick and smooth change.

kriki · 2006-12-13

SmokeScreen wrote:

We are only running one .fdb file. I just wanted to confirm that the Service Parameter would ACTUALLY work. I thank you all for the responses, I feel more confident that this will be a quick and smooth change.

Can you put [SOLVED] in the title?

SmokeScreen · 2006-12-20

When I actually attempted this, it did not work. Internal Error 1

I had my doubts and reality proved me correct.

So, for future reference, this does not work.

Savatage · 2006-12-20

When I actually attempted this, it did not work. Internal Error 1

did it give a module or something?

did you try Kriki's first post suggestions?

SmokeScreen · 2006-12-20

Kriki's procedure is the one I tried. I do not remember the exact error besides it being "Internal Error 1". Somewhere the service is remembering the old db's path.

I had to re-name the file back to what it was and then the service started right back up.

Savatage · 2006-12-20

I did this along time ago. I remember uninstalling the Nav Server using add/remove from the server and reinstalling it. & when it asked me to the database name - i gave it the new name and all was well.

We are using Native tho & I used this
http://www.mibuso.com/dlinfo.asp?FileID=304

thanks Emiel!

PS: Why does it matter the database name? if it's just database.fdb?

Change Database File Name?

Comments

Categories