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 |
|
paulprakash1
Starting Member
4 Posts |
 Posted - 2009-03-02 : 05:47:42
|
Hi,My web site is hosting by a company (third party) and they provide us sql server 2005.Now in my local server I am using sql server 2000. My basic requirement is exchanged data from both sides means any new data from remote server (2005) to local server (2000) and vise versa.Please help me is there any readymade solution is available like Linked server or Remote Server? Or I need to write some DTS?  Regards,Prakash Paul |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-03-02 : 06:55:59
|
| Depends what access you have to the database. Can you connect to it from your local machine or do you just get ftp access.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
paulprakash1
Starting Member
4 Posts |
Posted - 2009-03-02 : 09:15:33
|
| well I have both way access ftp and Management Studio even I am able to connect web server through my Intranet but problem is speed "data access speed is very slow but when I used through Internet speed is far far batter then the intranet connectivity" plz suggest any solution.Regards,Prakash Paul |
|
|
|
lawanggina@gmail.com
Starting Member
1 Post |
Posted - 2009-03-02 : 12:20:58
|
| Go to the below link and explore the options available for moving data between servers. Hopefully it will lead you to the conclusion.http://www.mssqltips.com/tip.asp?tip=1207 |
|
|
|
|
|
|
DTS or Linked server or Remote Server? Please sugg