How to make a copy a database

How to copy a database from one server to another

How to dump stored programs (stored procedures and functions, triggers, and events)

How to dump definitions and data separately