support

Question

pls i want help in this script i try my best but there is somthing wrong if anybody can help me !
thank you
database name onlineapplicationform
this database table Hc_Insu_Patient

Sys_Key AutoNumber
Insu_Employeeno int
Insu_Name1 Varchar(50)
Insu_Name2 Varchar(50)
Insu_Name3 Varchar(50)
Insu_Gender int
Insu_DOB DateTime
Insu_Relationship int
Insu_Dependent int
Insu_CivilID Char(10)
Insu_Mobile char(10)
Insu_Nationality int
Insu_PatientID char(30)
insu_EmailID Varchar(50)

Attachment: finally.rar

walid lamarti · Answer

i have created all tables in sql server 2008 with help from datbase admin and it's like that HC_Insu_Employee (Data will Upload by IT) Employee_no INT Employee_Name Varchar(100) Employee_DOB Datetime Hc_Insu_Nationality (Data will Upload by IT) Nationality_Code Int Nationality_name Varchar(100) Hc_Insu_Relationship (Data will Upload by IT) Rel_Key Int Relationship Varchar(100) this it will be table which data from form it will save here Hc_Insu_Patient Sys_Key AutoNumber Insu_Employeeno int Insu_Name1 Varchar(50) Insu_Name2 Varchar(50) Insu_Name3 Varchar(50) Insu_Gender int Insu_DOB DateTime Insu_Relationship int Insu_Dependent int Insu_CivilID Char(10) Insu_Mobile char(10) Insu_Nationality int Insu_PatientID char(30) insu_EmailID Varchar(50) but it's stoping here when i run the script throw new Exception (msg);

Dinkar Chavhan · Answer

I really enjoyed writing about SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure Functions Triggers Tables Views Constraints and All Other Database Objects . Since then I have received questions about how to copy data as well along with schema. The answer to this is Database Publishing Wizard. This wizard is very flexible and works with modes like schema only data only or both. It generates a single SQL script file which can be used to re create the contents of a database by manually executing the script on a target server . The pre-requisite for Database Publishing Wizard is .NET 2.0 Framework SQL Server 2005 Management Objects SMO. The Database Publishing Wizard will script all objects that the supplied User has permissions to see in the source database. Any objects create d  WITH ENCRYPTION  cannot be script ed. If such objects exist in the source database the tool will not produce a script . First of all install Database Publishing Wizard: Download Database Publishing Wizard . It will be installed at the following location: C:\Program Files\Microsoft SQL Server \90\Tools\Publishing\ . Now login using Command prompt and run the following command on any desired database. It will create the script at your specified location. The script will have schema as well as data which can be used to create the same information on the new server . Command to run which will create schema and database: C:\Program Files\Microsoft SQL Server \90\Tools\Publishing\ sql pubwiz script -d AdventureWorks C:\AdventureWorks. sql  Command to run which will create schema: C:\Program Files\Microsoft SQL Server \90\Tools\Publishing\ sql pubwiz script -d AdventureWorks C:\AdventureWorks. sql  -schemaonly Command to run which will create data: C:\Program Files\Microsoft SQL Server \90\Tools\Publishing\ sql pubwiz script -d AdventureWorks C:\AdventureWorks. sql  -dataonly