May 20, 2015 01:25 AM|oguh|LINK
I have a SQL Server 2008 database setup with some data on my local machine which is now ready to be moved across to a live server. (Database is used for an asp.net website)
I'm having some problems moving it across.
I've tried creating a backup locally and then running restore on the live server but as the server is shared I am not admin and therefore recieve an error stating I cannot create a new datebase.
Is there a way I can create a script out of my local SQL which I can use to reganerate all the tables, configuration and data in the live server?