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 |
|
DannyModelity
Starting Member
1 Post |
 Posted - 2011-01-03 : 09:25:20
|
| is it possible to copy table from db to db on another server? |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-01-03 : 09:29:32
|
| yesJimEveryday I learn something that somebody else already knew |
 |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-01-04 : 00:51:43
|
| and Yes Too :)Cheers!MIK |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-04 : 02:15:50
|
| Thats probably very helpful. You can do it in several ways depending on your requirements. If it's a one time deal and you're not too familiar with the ways of sql server then the easiest would probably be to use the export/import data wizard. Right-click the database of your source in Management Studio, choose Tasks -> Import Data / Export Data (it doesn't matter which) and follow the wizard. Should be pretty simple.If you need to do this on a regular basis, like synchronization, or have other requirements you need to elaborate a bit more what you want.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-01-04 : 04:35:10
|
Yeah ... the issue here is that there are lots of way. Come back and expand the description of your problem and then you will get better advice (that part I am certain about  ) |
|
|
|
MageshkumarM
Yak Posting Veteran
61 Posts |
Posted - 2011-01-04 : 04:39:58
|
| ya possible...!MAG |
|
|
|
|
|
|
copy table from db to db on another server?