Just use the Microsoft SQL Enterprise Manager.
Open the source sql server, find your database, right-click the name, select Export, and then the wizard will appear. You can then export/copy the data to another SQL server, text file, an Access database, or other supported destination.