Power Users Session 6

1
Power UsersSession 6

• MOVING UP
• Mark Setzer, Developer
• John Frazar, Sales Manager
• Stone Edge Technologies, Inc.

2
Converting to SQL Server

• A Brief Overview

3
Hardware Requirements and Concerns

• CPU
• Dual-core / -CPU preferred
• Memory
• As much as possible
• OS
• Server OS is best
• Drives
• Plan for redundancy and performance
• SQL Server
• 2005 or 2008 Editions (no preference)

4
Conversion

• On your server
• Shared files (SharedFileLocation)
• User accounts
• Data/log file location (on disk)
• Within SQL Server Management Studio
• Database creation
• Within Order Manager
• Everyone out during conversion!
• DSN Creation
• Post-conversion cleanup

5
Advanced Configuration

• Enabling remote connections
• Check those firewall settings!
• Assigning Logins and Database Users
• Appropriate permissions for company roles

6
Maintenance

• Extra Maintenance Specific to SQL Server
• Database and Log backups
• Checking database consistency
• Table indexes
• Using Maintenance Plans to automate maintenance
  tasks

7
Questions ?