SQL Server 7 Database question, Please! 1

[ValHart]

Hi All,

I hope someone can help me. We had a ISP that hosted our pages and SQL Server 7 database. We needed to move it in house due to costs. They provided us with the login and password to access all our page content via FTP, but, they have not answered us on how to get all our database content (tables etc.). Id there any tutorials or do any of you know how we might be able to transfer the tables and data from that server to our SQL server?

Thank you!

 

[CFDude]

Do you have access to the SQL Server? The easiest and best way would be to use DTS, but you have to get access to the server SQL server is on.

 

[ValHart]

I dug into the files that were on the FTP, and the .dns was there and it had the connection info I needed. Thanks for the DTS sugestion!.