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 |
|
associates
Starting Member
31 Posts |
 Posted - 2006-09-20 : 02:24:47
|
| Hi,I've got a quick question here. I'm still quite new to SQL Server. My question is how to transfer file between SQL Servers. For example, i have been working on the database - updating or editing some tables in the SQL Server 2000 at my end. Then, i need to pass whichever tables got updated on to my client who also uses the SQL Server 2000. So we have two separate SQL Servers 2000. i wonder how to transfer data like tables between the two SQL Servers.Thank you in advance |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-20 : 02:28:33
|
| Backup on one machine and restore on the other |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-20 : 02:40:48
|
If you only required to "transfer" the structure and not data, you can script out the table changes as t-sql scripts and save as files and run the script over at the client server.
KH |
|
|
|
|
|
|
transfer data between SQL Servers