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 |
|
GMKK
Starting Member
1 Post |
 Posted - 2008-03-15 : 07:50:41
|
| Hai Friends, I wants to copy the data from one database to another,is it possible to achieve this using SQLs. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-15 : 09:15:18
|
| Yes , you have a few options : 1)if the dbs are on the same server and the permissions are valid to the process you require , then just do the whole thing as t-sql statements 2)If the dbs are on different servers , use Linked Servers to create a way to access the dbs3)Also, there is DTSJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
Transfer data from one database to another