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.
| Author |
Topic |
|
ilimax
Posting Yak Master
164 Posts |
 Posted - 2008-12-30 : 08:00:33
|
| I have table full of data and for transfer that table to another server I want make sql script for create table and insert all of that data into table. Is there any way on sql server 2005 that I generate script automatically for inserting my data from table? |
|
|
ghemant
Starting Member
22 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-12-30 : 10:24:42
|
| you can also use the ssms tools pack from my signature for this. look below.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 11:43:50
|
| or you could simply use import export wizard for this without using any script |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-31 : 22:02:36
|
quote:
Originally posted by ghemant
Suggest you to refer http://vyaskn.tripod.com/code.htm#insertshthRegardsHemantgiri S. Goswamihttp://hemantgirisgoswami.blogspot.com/
Why need to take headache?Just use Visakh's approach. |
|
|
|
ghemant
Starting Member
22 Posts |
Posted - 2009-01-06 : 12:31:33
|
quote:
Originally posted by sodeep
quote:
Originally posted by ghemant
Suggest you to refer http://vyaskn.tripod.com/code.htm#insertshthRegardsHemantgiri S. Goswamihttp://hemantgirisgoswami.blogspot.com/ quote:
Why need to take headache?Just use Visakh's approach.
Certainly!!! it's upto question initiator!!!
RegardsHemantgiri S. Goswamihttp://hemantgirisgoswami.blogspot.com/ |
|
|
|
|
|
|
Insert records into table sql script