Jump to content
tucny

Name the database by the repository

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...