Last Day

السلام عليكم

ارجو المساعدة

فى كيفىة تحويل ملف من امتداد SQL الى MDF

لدى ملف باسم    testDB.sql

وهو يمثل قاعدة بيانات مكتوب كالاتى :

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'test')
	DROP DATABASE [test]
GO

CREATE DATABASE [test]  ON (NAME = N'test_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\test_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'test_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\test_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
 COLLATE Arabic_CI_AS
GO

exec sp_dboption N'test', N'autoclose', N'true'
GO

exec sp_dboption N'test', N'bulkcopy', N'false'
GO

exec sp_dboption N'test', N'trunc. log', N'true'
GO

exec sp_dboption N'test', N'torn page detection', N'true'
GO

exec sp_dboption N'test', N'read only', N'false'
GO

exec sp_dboption N'test', N'dbo use', N'false'
GO

exec sp_dboption N'test', N'single', N'false'
GO

exec sp_dboption N'test', N'autoshrink', N'true'
GO

exec sp_dboption N'test', N'ANSI null default', N'false'
GO

exec sp_dboption N'test', N'recursive triggers', N'false'
GO

exec sp_dboption N'test', N'ANSI nulls', N'false'
GO

exec sp_dboption N'test', N'concat null yields null', N'false'
GO

exec sp_dboption N'test', N'cursor close on commit', N'false'
GO

exec sp_dboption N'test', N'default to local cursor', N'false'
GO

exec sp_dboption N'test', N'quoted identifier', N'false'
GO

exec sp_dboption N'test', N'ANSI warnings', N'false'
GO

exec sp_dboption N'test', N'auto create statistics', N'true'
GO

exec sp_dboption N'test', N'auto update statistics', N'true'
GO

use [test]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetCities]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetCities]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetCountries]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetCountries]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Cities]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Cities]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Countries]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Countries]
GO

CREATE TABLE [dbo].[Cities] (
	[city_id] [int] IDENTITY (1, 1) NOT NULL ,
	[City] [varchar] (50) COLLATE Arabic_CI_AS NOT NULL ,
	[country_id] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Countries] (
	[country_id] [int] IDENTITY (1, 1) NOT NULL ,
	[country] [varchar] (50) COLLATE Arabic_CI_AS NOT NULL 
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

create proc GetCities @country_id int
as
select city_id,city
from cities
where country_id=@country_id
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

create proc GetCountries
as
select country_id , country 
from countries
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

اريد تحويله الى    testDB.mdf

شكرآ