SQL Transfer

[[UKLans]Khan]

Hello,

I have been working on a major ASP.Net application that runs on a SQL server that is being hosted remotly. I have the application working and it is time to upgrade to the remote servers. They have MS SQL 2000 Server, I have MS SQL7 server, I have a VPN connection to their network so how do I go about upgrading to that server?

Many thanks in advanced,

Khan

 

[[UKLans]Khan]

I managed to do it. For those who could use the info here's what I did.

The first thing was that I had a problem with versions. I had been developing on MS SQL 7 and the web server had 2000. MS SQL server has a thing called DTS (Data Transfer Service) that allows you to connect to a remote sql server and transfer the database.

However beacuse of the version differences it would only allow me to upload the table structure and data. It didn't allow for primary keys/foreign keys and relationships.

Initially when I designed the database I wrote it in Access, I did this becuse of how easy it is to see relationships ect in Access although I do usually use the Manager that comes with MS SQL.

So I had to up-size the Access database to the remote server. Upsizeing is a built in Access faciltiy and was dead easy.

Thats it, the end of my transfer story

Thanks,

Khan