defaultvalues.restoresettings

来自「sqlserver异地备份原代码,经测试可用,sqlserver异地备份原代码,」· RESTORESETTINGS 代码 · 共 516 行 · 第 1/2 页

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <DefaultValues>
    <Server>SHABDAR\SQLEXPRESS</Server>
    <Database>SMSNew</Database>
    <UserName>safdar</UserName>
    <Password>ghata</Password>
    <chkData>true</chkData>
    <chkStructure>true</chkStructure>
    <chkCreateDB>false</chkCreateDB>
    <chkDropDB>false</chkDropDB>
  </DefaultValues>
  <table>
    <TableName>Activities</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Activities]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Activities]
GO


CREATE TABLE [Activities] (
	[ActivityID] [int] NOT NULL ,
	[StartDateTime] [datetime] NULL ,
	[EndDateTime] [datetime] NULL ,
	[ActivityDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Activities] PRIMARY KEY  CLUSTERED 
	(
		[ActivityID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Attendence</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Attendence]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Attendence]
GO


CREATE TABLE [Attendence] (
	[StudentID] [int] NOT NULL ,
	[LectureID] [int] NOT NULL ,
	CONSTRAINT [PK_Attendence] PRIMARY KEY  CLUSTERED 
	(
		[StudentID],
		[LectureID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Countries</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Countries]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Countries]
GO


CREATE TABLE [Countries] (
	[CountryName] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[OrderID] [smallint] NOT NULL 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Donations</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Donations]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Donations]
GO


CREATE TABLE [Donations] (
	[DonationID] [int] NOT NULL ,
	[DonationDate] [datetime] NULL ,
	[DonationGivenBy] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DonationAmount] [float] NULL ,
	[Remarks] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Donations] PRIMARY KEY  CLUSTERED 
	(
		[DonationID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>ExamAttendance</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[ExamAttendance]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [ExamAttendance]
GO


CREATE TABLE [ExamAttendance] (
	[ExamID] [int] NOT NULL ,
	[StudentID] [int] NOT NULL ,
	CONSTRAINT [PK_ExamAttendance] PRIMARY KEY  CLUSTERED 
	(
		[ExamID],
		[StudentID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Exams</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Exams]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Exams]
GO


CREATE TABLE [Exams] (
	[ExamID] [int] NOT NULL ,
	[ExamStartDate] [datetime] NULL ,
	[ExamEndDate] [datetime] NULL ,
	[SubjectID] [int] NULL ,
	[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TeacherID] [int] NULL ,
	CONSTRAINT [PK_Exams] PRIMARY KEY  CLUSTERED 
	(
		[ExamID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Fees</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Fees]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Fees]
GO


CREATE TABLE [Fees] (
	[FeeID] [int] NOT NULL ,
	[FeeDate] [datetime] NOT NULL ,
	[FeeReceiptNo] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[StudentID] [int] NOT NULL ,
	[FeeReceivedBy] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[FeeTotalAmount] [float] NOT NULL ,
	[FeeGST] [float] NULL ,
	[FeePST] [float] NULL ,
	[FeeNetAmount] [float] NULL ,
	[Remarks] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Fees] PRIMARY KEY  CLUSTERED 
	(
		[FeeID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>FeesDetails</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[FeesDetails]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [FeesDetails]
GO


CREATE TABLE [FeesDetails] (
	[FeeID] [int] NOT NULL ,
	[SrNo] [int] NOT NULL ,
	[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Amount] [float] NOT NULL ,
	CONSTRAINT [PK_FeesDetails] PRIMARY KEY  CLUSTERED 
	(
		[FeeID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Grades</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Grades]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Grades]
GO


CREATE TABLE [Grades] (
	[GradeID] [int] NOT NULL ,
	[GradeName] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[GradeDescription] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Grades] PRIMARY KEY  CLUSTERED 
	(
		[GradeID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>GradesDetails</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[GradesDetails]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [GradesDetails]
GO


CREATE TABLE [GradesDetails] (
	[GradeID] [int] NOT NULL ,
	[StudentID] [int] NOT NULL ,
	[TermID] [int] NOT NULL 
) ON [PRIMARY]
GO


</ScriptSQL>
  </table>
  <table>
    <TableName>Holidays</TableName>
    <Select>true</Select>
    <ScriptSQL>if exists (select * from dbo.sysobjects where id = object_id(N'[Holidays]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [Holidays]
GO


CREATE TABLE [Holidays] (
	[HolidayID] [int] NOT NULL ,
	[HolidayStartDate] [datetime] NULL ,
	[HolidayEndDate] [datetime] NULL ,
	[HolidayDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Holidays] PRIMARY KEY  CLUSTERED 
	(
		[HolidayID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO