Using the Copy Database Wizard
-
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/usingthecopydatabasewizard.asp>http://www.sqlservercentral.com/columnists/awarren/usingthecopydatabasewizard.asp
-
It is a nice wizard, but keep in mind it DETACHes the original db for a litle while, and hereby generates unavailability of your originating db.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
No any information about coping master, msdb, and model databases between MS SQL Servers with different versions.
Is it possible to move this databases from v.7 to v.2000?
-
You cant move system databases using the wizard. You can detach/copy/move both model and msdb if you want to.
Andy
-
The code behind this wizard is very poorly written.
Try using it on a system that has 200 or more databases... it would take a Cray to make it all the way through the wizard. It uses a cursor to step through each database and calculate the size only it takes forever. I bet the cursor is setup wrong.
-
Have to admit I didnt test it on 200 dbs. I wouldnt use it for 200 anyway, easier to write a little code to detach and reattach, do it all at once. I'll look again to see what it's running behind the scenes.
Andy
-
Do you get anything in the details? Does it manage to detach to start with and fail later, or not even get that far?
Andy
-
Tell me what new thing you told us in this article. This whole article can be replaced by one line - right click on the database and choose Copy database.
-
No matter what I've tried, it doesn't work with SQL Authentication. Yes, I do have Admin righs on both machines, but if they are not on the same network, you're out of luck.
Did it work for anyone? I used it to transfer SQL 7 SP2 to 2000 SP1.Thanks
-
Rad,
I use it a lot with SQL2K SP2, dont have SQL 7 running on anything at the moment but it "should" work with NT authentication. Profile both servers to see what is happening.
Rsarosh,
Im sorry you didnt find the article useful, dont you think its the nature of things that depending on where you are on the learning curve you're not always going to learn something from every article you read? On the other hand, there IS a difference between using the wizard and just copying the database - something I believe I did cover in the article. In any case I'll hope you'll visit often and post often, even if not in favor of the article. Good for other readers to see both sides.
Eamon,
Send me the screen shot. One per step in the wizard up to where it fails if you can. Only caveat is if its really interesting they might become part of an article!
Andy
-
I know that it works with Windows Authentication, but what if I can't use win authentication? I just wanted to ask if it works for anyone with SQL Authentication.
-
Sorry, mis-read it. Just tried again to be sure, works fine with a sql login. Are you getting past the point where you pick the source and destination servers?
Andy
-
When I use the wizard to copy between a sql server (via OLE DB) and oracle (via ODBC) db, the table copy stops upon encountering a non-ansi character. Not sure where the problem lies. Anyone run into this problem?
-
I gather you're using the DTS Import/Export wizard, not just the Copy DB Wizard? There is a difference since you can't attach a sql db to Oracle, you'd have to copy the data. Might be the difference between the collations used. Recommend you post this question in our general forums where there is more chance someone familiar with Oracle will be able to offer a suggestion.
Andy
Did it work for anyone? I used it to transfer SQL 7 SP2 to 2000 SP1.Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply