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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-29 : 08:15:09
|
| rajesh kumar writes "Hi,i have sqlserver databases which are local and they r not connected to web all the time.ie, direct updation is not done.i am inserting the records to a local sqlserver(this is happening at different places).end of the day i want to upload the data to a central server..pls tell me how its donethanking youRajesh Kumar" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-29 : 11:43:52
|
| There are a few methods once you find out all the option you'll be able to ask more specific questions.http://www.microsoft.com/sql/evaluation/features/reliable.asphttp://www.microsoft.com/sql/evaluation/features/replication.asphttp://www.microsoft.com/sql/evaluation/features/datatran.asphttp://www.microsoft.com/sql/techinfo/tips/development/bulkcopy.aspyou're best bet is probably ftp for transfer of data.Then you can use replication, logshipping or bcp depending on whether there have been datastructure changes or not.you'll have to read more about these and figure out which one you'll want to implement. |
 |
|
|
|
|
|
sqlserver Uploading through FTP