SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 Generate SQL Script with table data
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shaileshk
Starting Member

India
6 Posts

Posted - 08/24/2005 :  11:27:04  Show Profile  Visit shaileshk's Homepage  Send shaileshk a Yahoo! Message  Reply with Quote
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/

Edited by - shaileshk on 04/04/2008 01:53:37

TG
Flowing Fount of Yak Knowledge

USA
5932 Posts

Posted - 08/24/2005 :  11:41:50  Show Profile  Reply with Quote
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
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 08/24/2005 :  11:53:48  Show Profile  Reply with Quote
Vyas has a very good stored procedure on his site that will script out INSERT statements.

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


-ec
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22713 Posts

Posted - 04/04/2008 :  02:53:03  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
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
Go to Top of Page

weitzhandler
Yak Posting Veteran

64 Posts

Posted - 04/11/2009 :  20:24:47  Show Profile  Visit weitzhandler's Homepage  Send weitzhandler an ICQ Message  Reply with Quote
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:
http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx

Shimmy
Go to Top of Page

cshah1
Constraint Violating Yak Guru

347 Posts

Posted - 04/12/2009 :  08:11:12  Show Profile  Reply with Quote
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.
Go to Top of Page

shannamarie
Starting Member

Philippines
1 Posts

Posted - 05/07/2009 :  18:36:55  Show Profile  Send shannamarie an AOL message  Send shannamarie a Yahoo! Message  Reply with Quote
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
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22713 Posts

Posted - 05/08/2009 :  01:27:32  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
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
Go to Top of Page

alexylee
Starting Member

USA
14 Posts

Posted - 11/09/2011 :  12:39:06  Show Profile  Reply with Quote
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...

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

(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
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
5932 Posts

Posted - 11/09/2011 :  13:52:51  Show Profile  Reply with Quote
Tune in to this topic in 2014 for the next exiting installment...

Be One with the Optimizer
TG
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000