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 |
|
satya068
Posting Yak Master
233 Posts |
 Posted - 2011-07-19 : 10:12:01
|
| Hello,i would like to copy 3 lookup tables from sql server2008 (database:TRI_SQL_EMP) into sql2005 (databse:SMT_SQL_REG),in past i have tried copying from one database to another databse in a same server,but now the requirment is different.any idea about this would be much helpfull.ThanxSatya |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-19 : 10:23:02
|
| Can create a linked server and SELECT * INTO FROM...Can use Data Import/Export wizard.Can use SSIS.Can BCP the data out, Bulk Insert it in...Basically, all the ways that you did it on one server are still available. |
 |
|
|
satya068
Posting Yak Master
233 Posts |
Posted - 2011-07-19 : 10:34:02
|
| Thanx for ur prompt reply russel,can you please give me an idea how to do using linked server!Satya |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-19 : 10:44:31
|
| See here |
|
|
|
satya068
Posting Yak Master
233 Posts |
Posted - 2011-07-19 : 10:54:35
|
| Thanx russel.Satya |
|
|
|
|
|
|
Copy tables from sql server2008 into 2005