Publish script - Remove default "_Primary" suffix added to Default File Prefix

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  October 4, 2018 at 4:41 am

  #415763

  Hello,

  A stupid question, there's a variable $(DefaultFilePrefix) defined by system, when I create publish script in my project it always adds a suffix "_Primary" to mdf and ndf files, what is the best way to prevent it?
  It generates such part of database script
  
CREATE DATABASE [$(DatabaseName)] 
ON  
 PRIMARY(NAME = [$(DatabaseName)], FILENAME = N'$(DefaultDataPath)$(DefaultFilePrefix)_Primary.mdf') 
LOG ON (NAME = [$(DatabaseName)_log], FILENAME = N'$(DefaultLogPath)$(DefaultFilePrefix)_Primary.ldf')
GO

  Below, what I want to achieve:
  
CREATE DATABASE [$(DatabaseName)]  
ON   
 PRIMARY(NAME = [$(DatabaseName)], FILENAME = N'$(DefaultDataPath)$(DefaultFilePrefix).mdf')  
 LOG ON (NAME = [$(DatabaseName)_log], FILENAME = N'$(DefaultLogPath)$(DefaultFilePrefix)_log.ldf')
GO

  Any idea how to get it without manual updating generated script?