It depends on your database administrative tool, but usually they have an "backup database" option or "export as SQL", which are basically the same thing.
That will create a script that you can run on your other database to recreate tables and usually has a wizard to allow you to map particular columns. This is a feature of the database administrative tool, so there is no one right way.