Re: transfer database between two servers which don't want to talk
- From: Helmut Woess <user22@xxxxxxxx>
- Date: Mon, 5 Jun 2006 19:31:17 +0200
Am Mon, 5 Jun 2006 11:35:32 -0400 schrieb Alan Baljeu:
All I want is to trasfer the data in one SQL server 2000 installation to
another. Unfortunately, I can't get them to talk due to these computers
existing in different domains, and assorted related obstacles. I can
however transfer files between the computers.
I need to copy tables, and views. I would like to copy roles and stored
procedures, but I can rebuild those if absolutely necessary. Can anyone
help?
Data, stored procs, views, trigger, all this you have in a backup. Make a
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.
bye, Helmut
.
- Follow-Ups:
- Re: 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
- References:
- 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: Calculating required space for making object partitioned
- Next by Date: Re: 50 and more servers, 200 and more datyabases, HOW TO list USER
- Previous by thread: transfer database between two servers which don't want to talk
- Next by thread: Re: transfer database between two servers which don't want to talk
- Index(es):
Relevant Pages
|
