Transcript Day 1 4 CMS Database

Scientific support for the management of Coastal and Oceanic Fisheries
in the Pacific Islands region (SciCOFish)
Funded by European Union
(10th EDF)
Creel & Market Surveys Database
Introduction and installation
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014
SPC Coastal Fisheries databases
•
•
•
•
RFID
SEMCoS
Creel & Market surveys
Exports
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014
Network installation (preferred)
Data entry & query
application
Data entry & query
application
SQL Server database
on a server
Microsoft .NET 4.0
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014
Local standalone installation
SQL Server Express,
Compact, or LocalDB
Data entry & query
application
Microsoft .NET 4.0
Prefer the network installation to a local installation:
• The database engine can be tricky to install on a desktop (requirements)
• Upgrades will be harder
• If your desktop hard drive crashes, the data is lost
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014
SciCOFish servers
These servers are designed to minimize the risk of losing data
(mirrored system hard drives, spare disk and backups)
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014
SCICOFISH18 server
Scicofish18: http://192.168.150.2
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014
Login: atlantis_admin Password: training
SciCOFish
Funded by European Union
Creel & Market Surveys Database Training Workshop - October/November 2014