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 |
|
soorajtnpki
Posting Yak Master
231 Posts |
 Posted - 2008-10-31 : 03:12:07
|
| Hi all, can we transfer data from sqlserver2000(in windows authentication) to other server sqlserver2005 (which is in sql authentication mode)ok tanx.. |
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2008-10-31 : 03:17:02
|
| hi my plan is to use insert into server2.dbname.dbo.table select * from server1.dbname.dbo.tableis it possible |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-31 : 03:46:06
|
quote:
Originally posted by soorajtnpki
hi my plan is to use insert into server2.dbname.dbo.table select * from server1.dbname.dbo.tableis it possible
if you want to use like above you should one server as linked server to other. use sp_addlinkedserver to add the other server as linked server.Even without doing this you can use Export-Import wizard or OPENROWSET to achieve the same purpose.look into books online for syntax and usage of OPENROWSET. |
|
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2008-10-31 : 04:37:32
|
| ok thanx |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-31 : 04:38:37
|
quote:
Originally posted by soorajtnpki
ok thanx
welcome  |
|
|
|
|
|
|
data transfer from one server to other