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 |
|
Zath
Constraint Violating Yak Guru
298 Posts |
 Posted - 2010-10-19 : 22:56:47
|
| I have a local copy of a DB.This DB is also on a server on the net.I have access to both of course.Now, I need to copy rows from one table to another. Same name, same keys, same everything. From the server to local. The tables are created.It is SQL Express 2005 and even tried to open SQL Server 2008 to import but no luck - no option. (That worked with another 2005 DB but not this one.)So, I need some sql to do this.Point me in the right direction?Thanks,Zath |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-20 : 12:40:08
|
| have you installed express toolkit? if yes, did you try using export/import wizard?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Zath
Constraint Violating Yak Guru
298 Posts |
Posted - 2010-10-20 : 20:42:48
|
| I didn't know that was available. NICE!THANKS!!! |
|
|
|
|
|
|
Copy Rows table to table from seperate Connections