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 |
|
cutepraba
Yak Posting Veteran
53 Posts |
 Posted - 2009-07-05 : 11:51:41
|
| how to copy the entire table(structure and data)one database to another.I am using MSSQL2000____________Praba |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-05 : 12:05:43
|
Are the databases on the same server?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-05 : 12:56:10
|
| You can use export import wizard for this if they are on different serverif on same server useUSE database2SELECT * INTO YourTableName FROM database1.dbo.YourTableName |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-07-06 : 07:12:44
|
| i think u can try as visakh suggestedif there are different servers then create a linked server or generate table script and insert scripts |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-07-06 : 08:12:02
|
| this is what I use to move around data+objects between different serversMicrosoft SQL Server Database Publishing Wizard 1.1http://www.microsoft.com/downloads/details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en |
|
|
|
|
|
|
[Resolved]copy table structure and data