Compare and Sync Tools for SQL Server 2005

Hello,

I need atool that can synctable structures and data between the production database (on DASP) and the local development machine. I know there are lots out there and I've tried a few but some simply refuse toconnect to the DASP database so I'm looking to the voice of experience for help!

Thanks in advance for any help.

Chris

 

Thanks for the advice Bruce. I'll take it for a spin.


Chris

 

I've nowinstalled a trial of the SQL Compare v5 & Data Compare tools. Any traps for new players that I should be aware of?


I can connect to the local database just fine, but get the dreaded "server not found or access denied" error when I attempt to connect to the DASP SQL2005server (sql2k305.discountasp.net) using the main SQL serverlogin and username. Do I need to know the IP address of the server?


I've looked at the Red-Gate site without success. Any ideas gratefully received.


Chris

 

Hi Bruce,


Thanks for the quick reply.


I don't get an error with the telnet command - a really, really brief message about connecting (too short for any detail), then a blinking cursor for a minute or so, then back to the command prompt.


Is this good or bad?


Cheers


Chris

 

Hi Bruce,


I'm an idiot! Imistyped the server name ... should have beensql2k503 not sql2k305 !!
Works fine now!

Cheers,

Chris