> I'm having to transfer an SQL server to a client's ISP - this
> is the first time I have had to do this. I have a book on SQL
> server which doesn't cover this exactly, but it seems I should
> be using DTS Transfer Manager?
You could use Transfer Manager, which would require you to be able to
connect via SQL Enterprise Manager to both the source and target databases.
In my experience, the ISP will generally open a hole in their firewall to
allow this as needed, and give you the TCP/IP connection information you'll
need (and in some cases, they'll be able to walk you through the process if
needed).
Alternatively, you could just send the database as a file. There are a
couple of ways you can do this. You can back it up to file on the source
machine, then send that file off to the target machine, where the
administrator of that machine could then restore it from the file. This
obviously doesn't require that you have access to the target machine. In
this vein, you could send the actual database files themselves - without
even doing a backup - and they could be attached on the target server using
sp_attach_db (which I believe is new to SQL Server 7).
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
