February 8, 2006 at 11:08 am
I want to append data each night from my live DB box to my test DB box. Can I use DTS for this or should I be using replication?
I have tried using the DTS wizard, it runs without errors but no data is sent. checked the SQL log it shows nothing. It seems like I sould be able to use either method?
THANKS
February 9, 2006 at 4:27 am
It is true that either method should work. I would check that their is not a block due to constraints or relationships and that the security used within your DTS has sufficient rights on both servers.
February 9, 2006 at 6:52 am
I know this may sound like something stupid to check, but I know I have done this before.
Is your source correct? I had an incident when I first put a package together where I was pointing the source at the destination, so of course, nothing was copied. I guess that's what happens when you work alot of hours and are rushing to finish something =)
February 9, 2006 at 6:53 am
I use DTS on a legacy SS7 system to populate a roll up server. This has been in place virtually untouched for years. Although it is not fool proof, it has operated well.
I use replication to keep a primary and warm standby server synched up.
I think that James is right in that your security is preventing the data transfer from occurring.
Scott
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply