July 11, 2011 at 9:11 pm
How do the rest of you name your databases? Do you have a naming convention or do you allow any name to become apart of a SQL instance?
I generally try and keep it to the name of the product with a DEV/PRD/UAT/TST, etc tagged on the end of it, but just curious what others do and how you approach it.
July 11, 2011 at 11:33 pm
Yes, it's good to follow some standard while naming any database and I guess you are following the right procedure. Your database name should depict the product and the team/purpose for it has been created. I/we follow the same in my organisation.
July 12, 2011 at 4:27 pm
PhilipC (7/11/2011)
I generally try and keep it to the name of the product with a DEV/PRD/UAT/TST, etc tagged on the end of it, but just curious what others do and how you approach it.
It will depend on the environment, and they're all unique just like all the others, but I have seen this practice become very problematic when code is introduced that does cross-database calls or when there are Linked Servers involved. I tend to see better results (in terms of less non-Prod portability issues) when the environment "tag" is included in the instance name rather than in the database name.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 13, 2011 at 1:16 am
here is a small document which i found very useful for naming convention.
http://www.cms.gov/DBAdmin/downloads/SQLServerStandardsandGuildelines.pdf
July 13, 2011 at 6:53 am
ghanshyam.kundu (7/13/2011)
http://www.cms.gov/DBAdmin/downloads/SQLServerStandardsandGuildelines.pdf%5B/quote%5D
This are nice standards, but where do they talk about standards for naming the database itself, or an instance, in non-prod environments?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 20, 2011 at 6:14 am
I try to keep things as simpler as possible, while being descriptive, but generic. What I mean is instead of HRSelfServiceDev, I'd use HRSelfService, because it carries across environments with no changes.
HRSource = 'Source' app for HR
HRSelfService = Self Service App for HR.
HRReports = Reporting DB for HR.
SalesDMart = Datamart for sales.
SalesPOS = Point of sale DB for Sales.
That naming carries across environments and servers while being simple yet descriptive.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply