نوشته شده توسط
corona
sara.f شما میتونی اسکریپت دیتابیست رو برا دوستمون بزاری می تونه تو 2005 برگردونه دیتابیس شما رو . من خودم این کار پیش اومده برام انجام دادم ، مگه اینکه از امکانات خاصی که فقط Sql 2008 داره استفاده کرده باشی که تو این برنامه بعید میدونم . موفق باشی
سلام
اینم script جدول و db
table-script
کد HTML:
USE [project2]
GO
/****** Object: Table [dbo].[employee] Script Date: 09/25/2009 14:02:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[employee](
[code] [int] IDENTITY(1000,1) NOT NULL,
[fname] [nvarchar](50) NULL,
[lname] [nvarchar](50) NULL,
[position] [nvarchar](50) NULL,
[office] [nvarchar](50) NULL,
[pic] [varbinary](max) NULL,
CONSTRAINT [PK_employee] PRIMARY KEY CLUSTERED
(
[code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
data base-script
USE [master]
GO
/****** Object: Database [project2] Script Date: 09/25/2009 13:59:39 ******/
CREATEDATABASE [project2] ONPRIMARY
( NAME =N'p2',FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\project2.mdf ', SIZE = 4096KB , MAXSIZE =UNLIMITED, FILEGROWTH = 1024KB )
LOGON
( NAME =N'p2_log',FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\project2_1.l df', SIZE = 3840KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTERDATABASE [project2] SETCOMPATIBILITY_LEVEL= 100
GO
IF (1 =FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [project2].[dbo].[sp_fulltext_database]@action ='enable'
end
GO
ALTERDATABASE [project2] SETANSI_NULL_DEFAULTOFF
GO
ALTERDATABASE [project2] SETANSI_NULLSOFF
GO
ALTERDATABASE [project2] SETANSI_PADDINGOFF
GO
ALTERDATABASE [project2] SETANSI_WARNINGSOFF
GO
ALTERDATABASE [project2] SETARITHABORTOFF
GO
ALTERDATABASE [project2] SETAUTO_CLOSEOFF
GO
ALTERDATABASE [project2] SETAUTO_CREATE_STATISTICSON
GO
ALTERDATABASE [project2] SETAUTO_SHRINKOFF
GO
ALTERDATABASE [project2] SETAUTO_UPDATE_STATISTICSON
GO
ALTERDATABASE [project2] SETCURSOR_CLOSE_ON_COMMITOFF
GO
ALTERDATABASE [project2] SETCURSOR_DEFAULTGLOBAL
GO
ALTERDATABASE [project2] SETCONCAT_NULL_YIELDS_NULLOFF
GO
ALTERDATABASE [project2] SETNUMERIC_ROUNDABORTOFF
GO
ALTERDATABASE [project2] SETQUOTED_IDENTIFIEROFF
GO
ALTERDATABASE [project2] SETRECURSIVE_TRIGGERSOFF
GO
ALTERDATABASE [project2] SETDISABLE_BROKER
GO
ALTERDATABASE [project2] SETAUTO_UPDATE_STATISTICS_ASYNCOFF
GO
ALTERDATABASE [project2] SETDATE_CORRELATION_OPTIMIZATIONOFF
GO
ALTERDATABASE [project2] SETTRUSTWORTHYOFF
GO
ALTERDATABASE [project2] SETALLOW_SNAPSHOT_ISOLATIONOFF
GO
ALTERDATABASE [project2] SETPARAMETERIZATIONSIMPLE
GO
ALTERDATABASE [project2] SETREAD_COMMITTED_SNAPSHOTOFF
GO
ALTERDATABASE [project2] SET HONOR_BROKER_PRIORITY OFF
GO
ALTERDATABASE [project2] SETREAD_WRITE
GO
ALTERDATABASE [project2] SETRECOVERYFULL
GO
ALTERDATABASE [project2] SETMULTI_USER
GO
ALTERDATABASE [project2] SETPAGE_VERIFYCHECKSUM
GO
ALTERDATABASE [project2] SETDB_CHAININGOFF
GO
اگه سوالی بود بپرسید.
پیروز باشید.
نقل قول: برنامه ای برای استفاده / نظر دهی دوستان
پاسخ با نقل قول
(تمام افرادی که برنامه را download کردند)
