How to transfer / copy a database from one server to another
Posted on 2016-08-29
I need to copy or transfer a database (tables, views, stored procedures, functions, etc.) from one database server to another. I tried using the wizard and the wizard did not copy over any of the tables, views, stored procedures, functions. I tried import / export function and only the tables were copied over from the old database to the new one. I also tried to use generate scripts for views and stored procedures and I have the script to my desktop or another location but I don't know how to import the views or stored procedures from the scripts to the database.
Is the a SQL script or any other way that I can copy the entire database from one server to another server. Time is of the issue. So your help is greatly appreciated.