asked
sql server 2005 create blank database with master table,Creating script for blank db with master table
I want to create script to create Blank database which contains master table for which I want to maintain data and transaction table which should be blank. I am using SQL Server 2005.,
I probably don't completely understand the question, but from the sounds of it, you don't want a blank database, but rather a database with two tables, one of which has data. Why don't you simply create a script that does exactly what you need? CREATE DATABASE x...; CREATE TABLE [Master]...; CREATE TABLE [Transaction]...; INSERT INTO [Master]...; Another option would be to add these tables to your model database. This would then make them automatically appear in any database you create on that server. PS: I assumed the table names, but it's a very bad habit to use reserved words as table names. It can lead to all sorts of problems.
Hey Grant thanks for the prompt reply, I can do it in a way as you suggested. The problem is that the table contains lots of data in my master tables for which I want auto script for insertion which should take care of foreign key relation ship, identity etc.
You might then want to look to a 3rd party tool to help out. Red Gate SQL Compare & SQL Data Compare can do exactly this sort of thing. DISCLAIMER: I work for Red Gate
16 People are following this question.
