Re: transfer database between two servers which don't want to talk
- From: Hank Arnold <rasilon@xxxxxxx>
- Date: Tue, 06 Jun 2006 04:29:39 -0400
There are two advantages to using the backup/restore process. The first is that the backup process (using SQL Server Agent) does not require taking the source database off line. You *will* have to take the target database off line....
The second is that it's a smaller file and will transfer quicker.... Plus you have a good backup of the db.
Regards,
Hank Arnold
Alan Baljeu wrote:
.I need to copy tables, and views. I would like to copy roles and storedData, stored procs, views, trigger, all this you have in a backup. Make a
procedures, but I can rebuild those if absolutely necessary. Can anyone
help?
full backup and send this file per FTP, mail whatever you want to the other
computer. On the target computer create a new empty database and make a
restore, using this backup. What you have to do by hand is the security
part (login, grants, ..). Easiest way is doing all with Enterprise Manager.
Thanks for the suggestion. After investigating this, I found an even easier approach: I took the database offline, copied the database files, and then brought the copies online at the new computer. This works perfectly.
- References:
- transfer database between two servers which don't want to talk
- From: Alan Baljeu
- Re: transfer database between two servers which don't want to talk
- From: Helmut Woess
- Re: transfer database between two servers which don't want to talk
- From: Alan Baljeu
- transfer database between two servers which don't want to talk
- Prev by Date: Re: transfer database between two servers which don't want to talk
- Next by Date: Maintenance Plan error
- Previous by thread: Re: transfer database between two servers which don't want to talk
- Next by thread: Re: 50 and more servers, 200 and more datyabases, HOW TO list USERS ?
- Index(es):
Relevant Pages
|
