Moving SQL files from old servers

[nightfall]

Hi folks.

I just joined the Vortech community recently and I hope I will be able to contribute.

I need some help with a SQL problem.

I am trying to move this site from its old server.

It has an external SQL database which I have access to, but how do I move all the data over to the new SQL server on Hsphere on Vortech network?

I can access this remote SQL via ASP Enterprise Manager.

Any help would be great!

Regards

Patrick

[mresell]

Check this out. I assume you are talking MSSQL. There is stuff in the forum here. There are limitations on permissions that have to be considered.
http://forum.vortechhosting.com/show...&highlight=SQL

[Brangwyn]

http://forum.vortechhosting.com/showthread.php?p=67950 If you could stick to just one thread when asking questions please too

[mresell]

Yeah, I thought I was having deja vu.