Importing database from one db to other db
-
-
hi all , i'm trying to import db from one db to other , here i'm getting only tables and views only . in that db i'm having stored procedures also but im not getting stored procedures . can any body explain me how to get the whole db . Thanks , csn
Redgate[^] has excellent tools for working with databases.
Giorgi Dalakishvili #region signature my articles My blog[^] #endregion
-
hi all , i'm trying to import db from one db to other , here i'm getting only tables and views only . in that db i'm having stored procedures also but im not getting stored procedures . can any body explain me how to get the whole db . Thanks , csn
For Procs you will have to generate script in old DB and then execute it in new db after imporying tables and views. By the way whats exact nature of requirement that is forcing you to import DB?
Razov If you think this answer helps you please rate it, it helps me. :)
-
For Procs you will have to generate script in old DB and then execute it in new db after imporying tables and views. By the way whats exact nature of requirement that is forcing you to import DB?
Razov If you think this answer helps you please rate it, it helps me. :)
Hi, you have 2 choose option "copy objects and data between sql server databases" in export wizard. Then click Next, check all the options provided, then click Next, then Finish. If this solution solves your problem, please rate this. Be a good professional who shares programming secrets with others.