Database
Basics
- What are the Acctivate Data Views and their Definitions?
- How do I link Power BI to an Acctivate database
- Using the Acctivate Database Maintenance program.
- Migrating Data from One Acctivate Company File to another Company File.
- Viewing the size of the Acctivate Database.
- Finding out which server Acctivate is using.
- What are the different database codes that Acctivate uses?
- Why does Acctivate use Microsoft SQL Server?
- Creating an Acctivate test company.
- Adding database objects to an Acctivate Database.
- What to consider about the size of your Acctivate Database.
- Where are emails saved in the database?
- Configuring an existing ODBC connection.
- List of Acctivate Database Maintenance commands
- Connecting Acctivate with Microsoft Access.
- Setting up a Sandbox server for testing
- Upgrading the Acctivate database from a command line.
- Setting up an ODBC connection to access data.
- Does Acctivate offer an API?
- Setting up Pervasive ODBC Driver DSNs for 64bit SQL Server
- Can Acctivate data be archived or condensed?
Backup & Restore
- Creating a Database backup routine.
- How to back up/restore the Acctivate Database.
- Creating a disaster recovery plan
- Speeding up your backups.
- Acctivate Database Backup Prompt
- How to create an automated Database backup task for Acctivate.
- Appending a date at the end of a backup file using Task Scheduler.
- Trimming the size of your Acctivate Database Backup file.
- Resolving a backup failure after moving Acctivate to a new server.
- Changing the Acctivate backup directory.
- How to create a database backup for Right Networks migrations
- Locating Acctivate database backups
Microsoft SQL Server
- Restoring the Acctivate Database in SQL Server Management Studio.
- What version of SQL Server do I need?
- Changing the location of Acctivate SQL Server Database Files.
- Connecting the Acctivate database to Microsoft SQL Management Studio
- What version of SQL Server does Acctivate install?
- Using Named Pipes for Microsoft SQL Server.
- Creating custom views using SSMS Query Designer.
- Updating the SQL sa password.
- Upgrading to Microsoft SQL Standard from a 64-bit instance of SQL Express.
- Locating what version of SQL Server Acctivate is using.
- How to Restart Microsoft SQL Server.
- What is Microsoft SQL Server Browser Service?
- Creating a read-only SQL Server user Account.
- What are the limitations of Microsoft SQL Server Express Editions?
- What is Microsoft SQL Server Management Studio?
Imports
- Importing in Customer information
- Configuring the Advanced Import Options.
- Importing data into Acctivate
- Importing in Customer Product IDs
- Importing in Alternate Product ID's
- Importing in Products.
- Importing in Balance Adjustments.
- Importing in Product Types
- Importing in Inventory Receipts
- Importing in Product Prices
- Importing in Product Components
- Importing in Product Classes
- Importing in Sales Orders
- Importing in Shipments
- Importing in Warehouse Locations
- Importing Custom Fields on Sales Orders.
- Importing in Inventory transfers
- Importing in Lot/Serial Numbers
- Import Sales Orders Using Existing Template.
- Creating a Sales Order Import template.
- What permission is required for importing products using the Import Data utility
- Sales order import matching sequence.