How to move database from local to server?

Hi,

I have a web application on local, now i want to move to server. My MS SQL database is not small (running on local). How can i move my database from local to server with full local data? I usually back up and restore on local but on server i can not do it. I tried to use import tool but not successful many times. What can i do?

Thanks.

 

I suggest you to issue a help desk ticket @ your control panel to resolve the problem or you could consult DASP KB first.

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>

 

I'm going to jump in on this issue.

I have attempted this and failed. The first four items in the progress window succeed and then it failed on "Configure the TransferProvider with files and Source/Destination connection info." The error I get is:



TITLE: Operation stopped...
------------------------------


The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.



------------------------------
ADDITIONAL INFORMATION:


The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.



------------------------------
BUTTONS:


OK
------------------------------