Peter J. Boettcher — Tue, 05 Dec 2000 13:50:04 +0000

Andy,

The connection EM uses to connect to SQL databases goes over port 1433 (by default) and can use many different network libraries but it's best to stick with TCP/IP.

Just setup the firewall to let requests from your computer go through port 1433 and everything should be fine.

Thanks mate

andy4444 — Mon, 04 Dec 2000 23:12:27 +0000

Thanks for that - is it difficult to make the connection between the DB's - I don't have the EM in front of me - it should be installed within the week.

Do you know if this connection it makes it using FTP (port 21)to transfer the db over the net, or will I run into problems with my companies strict firewall?

Thanks again mate

Peter J. Boettcher — Mon, 04 Dec 2000 17:03:18 +0000

Andrew,

It's pretty simple to copy data from one SQL Server to another using Enterprise Manager (EM). Simply do a right-click on the database name in EM, you'll get a sub-menu, select All-tasks and then export data. Then simply follow the directions, it pretty self explanatory. I'm using SQL 2000 so the menu's in SQL 7 might be a little different, just look for "export data".

As for updating the database, why don't you update it on the Website? You would save yourself a lot of time, unless you have a test/production setup.