Generate SQL Script with table data

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Script Library

Generate SQL Script with table data

Author

Topic

shaileshk
Starting Member

6 Posts

Posted - 2005-08-24 : 11:27:04

Hi

i have one problem in database to creating SQL script

i want to copy table strucure with table data

Pls help

Shailesh Kavathiya
http://www.codegroups.com/blog/

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2005-08-24 : 11:41:50

Have you considered the following options?

if the target table is on the same server as the source table:
INSERT INTO or SELECT INTO
(see details in Books Online)

if the target table is on a different server:
DTS the table
(Follow the wizard from Enterprise Manager menu item: Tools | Data Transformation Services)

Be One with the Optimizer
TG

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-08-24 : 11:53:48

Vyas has a very good stored procedure on his site that will script out INSERT statements.

http://vyaskn.tripod.com/code.htm#inserts

-ec

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-04-04 : 02:53:03

quote:
Originally posted by shaileshk

Hi

i have one problem in database to creating SQL script

i want to copy table strucure with table data

Pls help

Shailesh Kavathiya
http://www.codegroups.com/blog/

What did you change in this old thread?

Madhivanan

Failing to plan is Planning to fail

weitzhandler
Yak Posting Veteran

64 Posts

Posted - 2009-04-11 : 20:24:47

If you use SQL 2008 you will find this article really helpful:

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard:
[url]http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx[/url]

Shimmy

cshah1
Constraint Violating Yak Guru

347 Posts

Posted - 2009-04-12 : 08:11:12

Oh...use SQL Server publishing wizard

download it at
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

it will copy table data along with its structure. Perfect for users who have their website database at a web hosting company.

shannamarie
Starting Member

1 Post

Posted - 2009-05-07 : 18:36:55

hi to all i don't know where forum should i go with this problem of mine.. im using dream weaver for my website and i want to use list/menu for searching engine i dont know how to provide this code to run my website.. example(
<select name="date_issued" id="date_issued">
<option value="-">- </option>
<option value="December">December </option>
<option value="January">january</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
</select>
<select name="acct_name" id="acct_name">
<option value="-">- </option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
</select> )
if someone select December and 2008 and then press the button search it will automatically link to the another form and see the data in the month and year by the user search.. how it will works? please help

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-05-08 : 01:27:32

quote:
Originally posted by shannamarie

hi to all i don't know where forum should i go with this problem of mine.. im using dream weaver for my website and i want to use list/menu for searching engine i dont know how to provide this code to run my website.. example(
<select name="date_issued" id="date_issued">
<option value="-">- </option>
<option value="December">December </option>
<option value="January">january</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
</select>
<select name="acct_name" id="acct_name">
<option value="-">- </option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
</select> )
if someone select December and 2008 and then press the button search it will automatically link to the another form and see the data in the month and year by the user search.. how it will works? please help

This is not at all related to Original topic
Post your question as a new topic

Madhivanan

Failing to plan is Planning to fail

alexylee
Starting Member

14 Posts

Posted - 2011-11-09 : 12:39:06

If you want to script a table with its data for shared web hosting SQL Server or large # of DB objects,
this tool will be very useful. Fast and handy...

[url]http://www.sqlmgmt.com/sql/SQL-Table-Scripter[/url]

(Desc: This tool generates a SQL script file for a table and/or its data. This tool is especially useful when you want to create a SQL table script against Web Hosting SQL Server or slow remote SQL Server (Generate Script Wizard in SQL Server Management Studio or Database Publish Wizard in Visual Studio tends to be very slow for those servers))

http://www.sqlmgmt.com

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-11-09 : 13:52:51

Tune in to this topic in 2014 for the next exiting installment...

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources