User home
Store
System help
Ask a question
Search help
Login
   Help system Content Search
Article content
Run SQL script

With Doka control panel you can run simple SQL scripts or T-SQL batches on your database. You can also run T-SQL batches stored in files.

To run a script, in "User menu" navigate to "User -> Managed products -> MS SQL -> Databases -> (Database name) -> New SQL query"

Type in or paste the SQL batch in the textbox. If you want to see a query result (such as SELECT queries) you'll need to click on "Run single query" button. If you need to run T-SQL batch, click on "Run T-SQL batch" button.

 

You may also run T-SQL scripts stored in files. Navigate to "User -> Managed products -> MS SQL -> Databases -> (Database name) -> New SQL query from file"

There you'll have two options. You'll be able to runs script stored in your "backup location" or you'll be able to upload the new script and run it.

 

© Copyright 2017 Doka management panel