I have a problem when I need to generate sql-scripts for moving databases, this is for situations where I can't use the backup-system and I don't have data-compare functionality in my VS.

The key issue here, is that generating scripts isn't a problem but rather when executing them on the other sql-server. I always get various referential integrity errors, it still works but I am afraid there will be some nasty surprises down the road.

So the question to the experts is this:

What options should remain on/off when generating a sql-script from the Management Studio? What else can I do to avoid the "red lines" when executing scripts?

Thanks in advance,

Marcus