How to copy all objects from one server to another server?
-
How to copy all objects from one server to another server?
(different database name)
-
the best, most foolproof way is to backup the database, and restore it on the other server, with whatever name you would like. That is the standard recommendation.
everything other than that is a process which could fail or migrate only partial results.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
If you want the objects without data, use the right-click -> Generate Scripts option on the database.
Jared
CE - Microsoft -
Lowell (8/15/2012)
the best, most foolproof way is to backup the database, and restore it on the other server, with whatever name you would like. That is the standard recommendation.everything other than that is a process which could fail or migrate only partial results.
+1
The best and the simplest way. Believe me its hassle free.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
Thank you. I backup and then restore. Everything is ok.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply