>Chris,
>>I have a SQL Server 7.0 database that I have converted from VFP on my laptop. What is the best way to copy it from my laptop to the client's SQL Server?
>>
>>I have used DTS to copy the DB from my laptop to another server here in the office without any trouble (Win2K to Win2k). But I am pretty weak when it comes to networks *g*. Will it be as easy as connecting my laptop to their network and running DTS from my laptop?
>
>It depends. With NT, (and I assume Win2K) changing IP address information is easy because you don't have to go through the hassle of rebooting (unless you have multiple NICs). So configuring your machine to get on their network is relatively painless.
>
>The following assumes you use TCPIP (which I recommend) to connect to SQL Server and not Named Pipes.
>
>Next you have to reset the information for SQL Server. I think that's under Server Configuration. Change the address from what it was to the new address. Then you need to configure the Client utilities to add the client's server so it will be available in the drop downs for DTS. Now you should be able to connect to both servers with the appropriate user account and password.
>
>Another option is to make a backup (DMP) of the database to a file device and then restore it to the other server. All users, roles, SPs will go with it. As long as both servers were installed using the same Sort Attributes and Code Page, this will work.
>
>>
>>Also, what are my options for accessing SQL Server at the client from my office? I would hate to have to go there everytime something goes wrong. And since this is my first SQL project, I think it is goint to happen a lot *vbg*.
>
>If the client is not behind a firewall, you should be able to access SQL Server using any of the utilities (Query Analyzer, SEM). If they are, then they have to open the appropriate ports. The default is 1433 but I would recommend changing it if they do open the server to the internet (then you have to change your client configuration to match it).
>
>Another option is to use something like PCAnywhere to dial in and access the utilities from that PC. I wouldn't recommend using RAS because of the speed of the connection and the amount of information that is transferred when using SEM.
>
>HTH.

It does, and thank you very much.