script file for creating database with some required data in sqlserver 2005

Question

4.00/5 (1 vote)

See more:

SQL-Server-2005

Hi,

I am new to sqlserver and i am trying to generate a script file for creating a database with data, but when i generate script file am not getting data from the tables.

i don't want all the data from all the tables.

i want the data from specific tables.

how to do that.

Regards,
Nagaraju

Posted 4-Aug-11 20:19pm

nm.nagaraju

Add a Solution

Comments

walterhevedeich 5-Aug-11 2:21am

Show us the script.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-08-04T21:31:00

The easiest way is to look at an existing example, or use that yourself.

Open the SQL Management Studio, and right click on your database. Under "Tasks", select "Generate Scripts..." In the dialog that follows, press "Next" until you get to the part asking where to save it. Select somewhere sensible, and click the "Advanced" button. Look for the "Types of data to script" option (it should be at the bottom of the "General" category). Select "Schema and data". Press "OK" and "Next" until the file has been generated.
If you look at the file, it will be a complete script to regenerate your database, complete with data.

Herman<T>.Instance · Answer 2 · 2011-08-04T21:12:00

Solution 1

if you use sql server management studio it is very simple to create these scripts for you.
Right click on the databasename, choose tasks and then generate scripts

Posted 4-Aug-11 21:12pm

Herman<T>.Instance

Comments

nm.nagaraju 5-Aug-11 3:19am

I am not getting the data from the tables and i am getting only structure of the database.

Herman<T>.Instance 5-Aug-11 3:23am

Right click on the databasename, choose tasks and then Export Data