Test your skills
I m using SQL 2005. I want to copy the store procedure from one database to another. What is the procedure for this?
If you are copying one database, then all you have to do is make a backup of it and then try to regain your back up from the second database. This is applicable if your purpose is to get one table DTS is the procedure that you have to do. Check it if it will work on your problem. If not then try this one if you will want to copy many tables the you better use BCP command line utility. Try this command bcp db_name.schema_name.table_name out table_name.dat -c -t, -S source_server -T bcp db_name.schema_name.table_name in table_name.dat -c -t, -S destination_server –T. you better change the -T to U as your username P as your password. Check this out and it will help you to transfer data from one database to another thanks.