Link to home
Start Free TrialLog in
Avatar of Jacque Scott
Jacque ScottFlag for United States of America

asked on

Creating scripts to copy db schema only, no data, to another server. MSSQL

I need to copy the database structure of one db onto another server.  I don't need the data, just the schema. I went to tasks and generated scripts.

Here is a portion of the script I have a question on.  Why did it create the .mdf file on the F:\\ drive?  Since I am running the script on a different server I get an error.  
Directory lookup for the file "F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ProLaw.mdf" failed with the operating system error 3(The system cannot find the path specified.).
CREATE DATABASE [ProLaw] ON  PRIMARY 
( NAME = N'ProLaw_Data', FILENAME = N'F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ProLaw.mdf' , SIZE = 19710784KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
 LOG ON 
( NAME = N'ProLaw_Log', FILENAME = N'F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ProLaw_log.ldf' , SIZE = 7616KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
ALTER DATABASE [ProLaw] SET COMPATIBILITY_LEVEL = 90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [ProLaw].[dbo].[sp_fulltext_database] @action = 'disable'
end

Open in new window

SOLUTION
Avatar of HainKurt
HainKurt
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial