I have prepared a site with a MS SQL database that I would like to transfer to the MS SQL account in my hosting environment at UnoEuro. I tried to script my current database and run it in the hosted database, but it didn't by far transfer all the data.
When I tried to pick up a backup copy I didn't have the right permission to access my local machine through SQL Server Management Studio. Is there a way to actually script the COMPLETE database for simular situations? I have asked UnoEuro if there is a possibility to restore a backup and I hope for a positive reply.
MS SQL Server - script doesn't transfer all data?
Hi!
I have prepared a site with a MS SQL database that I would like to transfer to the MS SQL account in my hosting environment at UnoEuro. I tried to script my current database and run it in the hosted database, but it didn't by far transfer all the data.
When I tried to pick up a backup copy I didn't have the right permission to access my local machine through SQL Server Management Studio.
Is there a way to actually script the COMPLETE database for simular situations? I have asked UnoEuro if there is a possibility to restore a backup and I hope for a positive reply.
Thanx in advance.
/Patrik
is working on a reply...