Name the database by the repository

[tucny]

I'm planning a reinstall of our Plastic server on new OS a SQL versions (I know, I know, Jet… but…). What's annoying me is that the databased in SQL Server (have 100+ of them) are named according to some repository number.

What I'd like to have are database files "repo_boldbrick-framework.mdf", where "boldbrick-framework" is a sample repository name. All our repos are named according to the "<customer>-<project>" pattern. I read in the documentation about the database creation command. However, there's no variable for the repository name.

Can I, somehow, customize database names like above? What can I do about the existing database file names during server migration?

[psantosl]

What if you rename the repo?

 

That's the reason why we used ids instead of names.

Renaming a database is an extra step (and extra permission) you need.

So, at this point, there is no way to replace ids by names, I'm afraid.

[tucny]

Well, that's a good point. However, numbers as names are far less user-friendly for database maintenance tasks than repository names. Plus, when I rename a repository, it creates a handful of issues with all workspaces around, so one more database maintenance task is of a negligible concern in that situation.