| Author |
Topic |
|
mchampse
Starting Member
4 Posts |
 Posted - 2008-03-28 : 00:27:39
|
| I am working with a company that uses an ASP. They have found their ASP to be lacking in terms of reports, so would like a copy of their database locally. We could do a backup and restore, but I'd rather not so that we can have some stored procedures locally that don't constantly get overwritten. Is there a means of SQL Server essentially creating a sequential log of every insert/update/delete that could then be ftp'ed and loaded in the local database? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-28 : 09:27:47
|
| Yes with transaction replication. You can ftp only the snapshot to the subscribers. I don't think they have FTP task in DTS in 2000. But SSIS packages do have. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-28 : 22:45:00
|
| Dts has ftp task. You may bcp data out, ftp to another server then bcp them in. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-29 : 12:03:21
|
| But how can you force transaction replication to use FTP for insert/delete stataments to go subscribers. It uses TCP/IP . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-29 : 22:30:38
|
| I only said dts. By the way, it's possible to replicate via ftp. Take look at knowledge base article 'Configuring Proxy Server for SQL Server Replication over the Internet'. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-29 : 22:39:57
|
| It says SQL server 7.0. Do you think it will work for SQL 2005? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-29 : 22:46:47
|
| Yes, concept is same. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-29 : 22:55:03
|
| But only first snapshot goes through FTP and not the incremental changes in transactional rep. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-29 : 23:27:38
|
| Why? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-29 : 23:36:58
|
| WHAT??????? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-30 : 00:08:25
|
| The article never say it's for snapshot only, and there are several other kb articles on same topic. Read them. |
|
|
|
|
replication when servers cant see each other