Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Execute .sql file
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Execute .sql file

 Post Reply Post Reply
Author
azqh View Drop Down
Newbie
Newbie


Joined: 13 December 2010
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote azqh Quote  Post ReplyReply Direct Link To This Post Topic: Execute .sql file
    Posted: 14 December 2010 at 9:35am

"Execute the admin.sql script in order to create the tables and stored procedures in the database".

I'm a new completely newbie to web wiz hosting and its format of style to complete tasks. I need someone to help me upload my file to execute the .sql file to my SQL Server 2008. the only option I can find to upload a file is only asv file but??


Edited by azqh - 14 December 2010 at 12:05pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2010 at 11:03am
There are a number of ways this can be achieved, it maybe worth asking the developers how they intend the file to be run.

You could install SQL Server Management Studio on your own PC then connect remotely to your database and use the Tools in  SQL Server Management Studio  to execute the SQL file.

Another alternative is to use the Tools available in your Control Panel. Next to the name of your SQL Server database you will find a 'Browse Database' link this will take you to the myLittleAdmin Tool, from where under the 'Tools' menu you will find a 'New Query' tool. you can then copy and paste the code from your admin.sql file to the 'New Query' form and hit the submit button to execute the code.

If you are still stuck create a support ticket from your Client Area account and attach your admin.sql file and we can look at executing it for you.
Back to Top
azqh View Drop Down
Newbie
Newbie


Joined: 13 December 2010
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote azqh Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2010 at 12:05pm

Okay I copied and pasted the contents to it and it did create tables now I am uploading all the files and we will see if it works!Thumbs Up! I've tried to access with express studio says I do not have access to anything with my assigned database...

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2010 at 12:49pm
Could you please create a support ticket on this so can have a look at your database to make sure that the tables have been created correctly?
Back to Top
azqh View Drop Down
Newbie
Newbie


Joined: 13 December 2010
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote azqh Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2010 at 8:19pm

yes I can but I did get up and working now everything is okay. when I did create the tables it worked and put them in but in the messages it said a few errors.

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2010 at 9:00pm
Good to hear that it is working
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.