Last post May 20, 2015 01:39 AM by Ajay2707
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?
May 20, 2015 01:39 AM|Ajay2707|LINK
No, without proper access rights to your role or user in sqlserver, you can't run the script of create or via UI in sqlserver. Better to contact admin for this.