SQL Server

From ARGUS TV Wiki
Revision as of 16:06, 6 December 2012 by AndrewNZ (Talk | contribs)

Jump to: navigation, search

Contents

About

Before you install ARGUS TV Scheduler, you will need to install database server software. Your options are, Microsoft SQL, or MySQL. We recommend Microsoft SQL Express.

If you have previously installed MediaPortal TV Server it will have installed MySQL. In this case there is no need to install other database server software.
Nevertheless keep in mind, that if you may encounter response speed issues, especially opening or performing complex Recording or Suggestion Plans in ARGUS TV, you may speed up the whole system by deciding to move to MS-SQL. Users of MediaPortal TV Server then have to re-setup their TV Server configuration (re-install using MS-SQL).
Mainly, for the use with ARGUS TV, the usage of MS-SQL is recommended.

ICN INFO.PNG MediaPortal installs MySQL with the following user name and password.
User: sa
Password: MediaPortal (case sensitive)

Installing Microsoft SQL Express

Installation is a fairly straight forward process. First download the installer that suits your needs, See ICN WEB INLINE.PNG here for available versions.

This guide uses SQL Express 2008 (because that's what the author had).

Run the installer, once it has started you will see this window.

MSSQL001.png

Select "New installation or add features to an existing installation"

Accept the terms and conditions (The second check box is optional) then click Next.

MSSQL002.png

Wait for the installer to do it's thing.

MSSQL004.png

Click Next.

MSSQL005.png

Click Next.

MSSQL006.png

Click Next.

MSSQL007.png

Click Next.

MSSQL008.png

Click Next again to begin the install.

MSSQL009.png

Wait for the installer to finish installing.

MSSQL010.png

Click Close.

MSSQL011.png

And you're done. It's that easy!

Installing MySQL

ICN EDIT GREEN.PNG This article would greatly benefit from your contribution. Please help us to extend this ARGUS TV Wiki article.
You may want to refer to "Contribute to our Wiki".


Removing databases

In the unlikely event that you need to remove your databases, these are the options to do it.

  • SQL Management Studio.
  • MySQL Workbench.
  • Drop database command.
ICN WARN.PNG Caution
Removing the database is not a necessary step for reinstall or upgrade, it will permanently remove all data, schedules and settings from ARGUS TV Recorder. If you are unsure if you need to delete your database, don't.

Removing the database while ARGUS TV is installed will distroy the install, your only option will be to reinstall ARGUS TV all of your data, schedules and settings will be lost.

You have been warned

SQL Management Studio / MySQL Workbench

"SQL Management Studio" and "MySQL Workbench" allow you to manage your databases through a GUI rather than by command line. You will probably need to download these separately, they are not typically included with a standard SQL install.

As there should be plenty of guides to using these applications available, we will only provide a link. ICN WEB INLINE.PNG Google

MS SQL Drop Database

This is actually far easier than it first appears to a newbie. This assumes you have a default install of MS SQL Express, and will delete the ARGUS TV Database. These commands are not unique to ARGUS TV and will work for any MS-SQL database, just replace "ArgusTV" with the name of the target database.
Open a command prompt (windows key + R, type cmd), and type the command on each line and press enter. (the commands are shown in bold, do not begin the command with a space).

Start here

C:\Users\Andrew> sqlcmd -S .\sqlexpress -E
1> drop database ArgusTV
2> go
1> exit


ICN INFO.PNG Information:

The command above assumes you have a standard install of MS SQL Express, if not, you may have to alter the first line.
.\sqlexpress is the name of the SQL server running on your machine. You will need to change it to .\<your server name here>
You may be able to find it by pressing Ctrl + Shift + Esc, clicking the services tab, and scrolling down to the SQL Services. You should find a line that looks a little like this:

SQLAgent$SQLEXPRESS  |   |  SQL Server Agent (SQLEXPRESS)

MySQL Drop Database

ICN EDIT GREEN.PNG This article would greatly benefit from your contribution. Please help us to extend this ARGUS TV Wiki article.
You may want to refer to "Contribute to our Wiki".
Namespaces

Variants
Actions
Navigation
Toolbox