使用脚本在默认路径创建数据库? [英] Create database using script at the default path?
问题描述
我在SQL Server 2008中生成了一个数据库的脚本。生成的脚本具有创建数据库的硬编码路径。我不想这个路径被硬编码,我想这个路径默认数据库引擎脚本运行或一些像这样。
I've generated a script of a database in SQL Server 2008. The generated script has the hardcoded path of where the database would be created. I don't this path to be hardcoded, I want this path to default of the database engine the script is running on or some like that.
这里是小部分
CREATE DATABASE [POS] ON PRIMARY
( NAME = N'POS', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\POS.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'POS_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\POS_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
路径 C: \Program Files \Microsoft SQL Server \MSSQL10_50.SQLEXPRESS\MSSQL\DATA\POS.mdf
可能不存在于所有计算机上,这就是为什么我想要由数据库引擎选择
The path C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\POS.mdf
might not exist on all computers that's why I want it to be chosen by database engine
推荐答案
只需创建数据库,然后直接在文件中调整所有需要的属性。
Simply create the database and then adjust all the needed properties directly in files
CREATE DATABASE [POS]
GO
ALTER DATABASE POS MODIFY FILE
( NAME = N'POS' , SIZE = 3048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
GO
ALTER DATABASE POS MODIFY FILE
( NAME = N'POS_log' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
这篇关于使用脚本在默认路径创建数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!