I like SQL Data Compare from RedGate, think maybe ApexSQL has a tool that does it too (I know it compares schema, not sure about data). It scripts it over, nice because you can see what needs to be added, changed, deleted.