Blackbaud management console where is

Rebuild Indexes: Using the Blackbaud Management Console, you canrebuild database indexes to reorganize the storage of the index data andremove fragmentation. This process optimizes database performanceby recalculating information about the organization of key values inindexes used by the database engine.

Shrink Database: Using the Blackbaud Management Console, you canshrink your database to reclaim vacated space. Check Integrity: Using the Blackbaud Management Console, you can runa validation to check database integrity.

We recommend you run thisutility before you make changes to your system, such as upgradinghardware or software. Manage Deploy Kit. Migrate Database. Using the Blackbaud Management Console, you can stop, start, andpause your server; disconnect from your server; and manage server memoryuse.

When you stop a database,users cannot log in. This connection is established automatically when you run theinstallation or update. Afterward, you can disconnect the BlackbaudManagement Console from a server without affecting user access to thedata.

For informationabout purchasing CrystalReports Professionallicenses, contact youraccount representative orsend an email request tosolutions blackbaud. Using the Blackbaud Management Console,you can take a database offline. This means the database is closed, markedoffline, and cannot be modified.

When you bring the database back online, thedatabase is open and available for use. Online is the default setting. Using the BlackbaudManagement ConsoleIf you have version 7. The Blackbaud Management Console screen appears. The main screen of the Blackbaud Management Console contains two panes. Onthe left, the Installed products pane uses a tree view representation to display theprograms you have installed, database s for each program, and server s runningthe programs.

If you select Servers in the Installed products pane, serverinformation appears. To expand and display all the database and server information in the tree view,click the plus signs in the Installed products pane.

To hide the database andserver information in the tree view, click the minus signs - in the Installedproducts pane. There are multiple ways to access the functionality housed in the BlackbaudManagement Console. You can also use the Tools menuto access the database wizards. To access the various Blackbaud Management Console wizards available, select aproduct in Installed products pane, locate the wizard to run in the right pane, andclick Run Now.

This guide includes detailed instructions on how to work in allwizards available in the Blackbaud Management Console. Additional database utilities are housed in the Tools or right-click menu. The utilities appear in the right pane. Additional server utilities are housed in the Tools menu or right-click menu. You use these menucommands on the toolbar to access Blackbaud Management Consolefunctionality. The Tools menu is active only for certain functionality. From the Action menu, you exit the Blackbaud Management Console atany time.

From the Tools menu, you access a number of database tools andmaintenance functionality, as well as database user information. The optionson the Tools menu vary depending on your selection in the Installedproducts pane. CData Sync integrates live Blackbaud FE NXT data into your Amazon Redshift instance, allowing you to consolidate all of your data into a single location for archiving, reporting, analytics, machine learning, artificial intelligence and more.

To add a replication destination, navigate to the Connections tab. On the Clusters page, click the name of the cluster. On the Configuration tab, obtain the properties from the Cluster Database Properties section. For each replication you wish to configure, navigate to the Jobs tab and click Add Job. Select the Source and Destination for your replication. To replicate an entire table, click Add Tables in the Tables section, choose the table s you wish to replicate, and click Add Selected Tables.

In the Schedule section, you can schedule a job to run automatically, configuring the job to run after specified intervals ranging from once every 15 minutes to once every month. Once you have configured the replication job, click Save Changes.

CData Software is a leading provider of data access and connectivity solutions. All rights reserved. To repair your deploy kit using files from the installation CD, mark Repair and click Next. To locate the Install CD, click the browse button.

Changing the default workstation install path 1. To change the default workstation installation path, mark Modify and click Next. Migrating a Database If you migrate an Accounting for Nonprofits 6. If you migrate an Accounting for Nonprofits 6. The pre-convert utility GLPreconvert. To ensure you have the most recent pre-conversion utility, make sure you are running the latest version of Accounting for Nonprofits 6.

If this is necessary, you are prompted during the migration process to install the engine and restart the Blackbaud Management Console. You must also call Blackbaud Support and obtain a password, which you must enter during the engine installation to verify your ASA license. The Migrate Database Wizard, which guides you through the process step by step, differs slightly based on the Blackbaud product you use.

For instructions about how to migrate a Raisers Edge database, see Migrating a Raisers Edge database on page In the Migrate Database frame, click Run Now. The welcome screen for the Migrate Database Wizard appears. In the Select ASA database to migrate field, enter the location of the database to migrate.

A Blackbaud accounting database is named AFN7. An Education Administration database is named SA. If this is necessary, a message appears during the migration process to prompt you to install the engine and restart the Blackbaud Management Console. You must also call Blackbaud Support and obtain a password. In the Select Server frame, select the server to which to migrate a database. When you display the available servers, click Registered to display the registered servers available to you.

In the Path for migrated database field, enter a location for the database to migrate. To located the database, click the browse button. In the Name for migrated database field, enter a database name. In the Description for migrated database field, enter a description of the database. Once the migration is complete, click Next. The final screen of the Migrate Database Wizard appears.

Migrating a Raisers Edge database 1. From the Installed products tree view, select The Raisers Edge. In the Migrate database frame, click Run Now. The Select Destination Database screen appears. To use the Raisers Edge database installed with the program, mark Use local RE database server and proceed to step If the server you want does not appear in the Select Server box, click Available.

In the Select Server frame, select the server to which to migrate your database. In the Path for migrated database field, enter a location for the database. Click Migrate. As the database migrates, the Migration in Progress screen displays its progress.

Once the migration is complete, the final screen of the Migrate Database Wizard displays. To complete the Migrate Database Wizard, click Finish. You return to the Blackbaud Management Console screen. Using database tools, you can take a database offline or detach the database. When you select a database in the Installed products tree view, you can select these database utilities from the Tools menu and view database properties.

Viewing Database Properties To view which users are connected to the database, you can also use the Database Connection Viewer located on the Plug-Ins page of the program. Using the Blackbaud Management Console, you can view database properties such as size, file path, server, and number of users.

To access the database properties screen, select a database in the Installed products tree view or click Database Detail on the Databases screen. Viewing database properties The screens depicted in this procedure appear for users of The Raisers Edge. From the main screen of the Blackbaud Management Console, select a database in the Installed products tree view.

In the Properties frame in the right pane, information about the selected database appears. As necessary, in the Description field, you can change the name of your database as it appears when you log into the program. When you take a database offline, the database is closed and marked offline.

While the database is offline, you cannot modify it. You may take a database offline to make a copy of the data or to keep users out of a database without shutting down the entire server. Before you take the database offline, all users must be out of the system. The default setting is Online. Taking a database offline The screens depicted in this procedure appear for users of The Raisers Edge. From the main screen of the Blackbaud Management Console, select the database to take offline.

In the pane on the right of the screen, information about the selected database appears. A message appears. Bring a Database Online After you take a database offline, you may need to bring it back online at a later date.

The Blackbaud Management Console enables you to do this easily. Bring a database online The screens depicted in this procedure appear for users of The Raisers Edge. From the Blackbaud Management Console screen, in the Installed products tree view on the left side of the screen, select the database to bring online. The selected database is brought online. Detaching a Database Using the Blackbaud Management Console, you can detach a database and attach it to another server or reattach it to the same server.

Detaching a database removes the database from SQL Server but leaves the database intact within the data and transaction log files that compose the database. You can use these data and transaction log files to attach the database to any instance of SQL Server, including the server from which the database was detached.

This makes the database available in exactly the same state it was in when it was detached. Detaching and attaching databases is useful if you want to move a database: From one computer to another without having to re-create the database and restore the database backup manually. To a different physical disk, for example, when the disk containing the database file runs out of disk space and you want to expand the existing file rather than add a new file to the database on the other disk.

Detaching a database The screens depicted in this procedure appear for users of The Raisers Edge. From the main screen of the Blackbaud Management Console, select the database to detach. To detach the database, click Yes.

To reattach this database, use the Attach Database Wizard. Active Users To view active users, select Active users in the Installed products tree view on the main screen of the Blackbaud Management Console.

When you select Active users, the user information and utilities appear in the pane on the right. The user information corresponds to the database to which the user is logged in. You can run the utilities from the Tools menu or the Active User page. User utilities include sending a message to a user and disconnecting a user from the database. To refresh the information on the Active user page, click Refresh.

Sending Messages to Users Using the Blackbaud Management Console, you can send messages to one user or multiple users. Sending a message to a user The screens depicted in this procedure appear for users of The Raisers Edge. From the main screen of the Blackbaud Management Console, select Active users in the Installed products tree view.

The Active Users screen appears on the right. In the text box, enter the message to send. In the Send to field, enter the user name to whom to send the message. To send messages to multiple users, separate each name with a semicolon. Disconnecting a User Using the Blackbaud Management Console, you can disconnect a user from a database.

This feature is useful if the program ends abnormally, leaving the user connected to the database but unable to log in. You should also disconnect a user before you take a database offline. On the Active Users screen of the Blackbaud Management Console, you can view active users of a particular database. Disconnecting a user The screens depicted in this procedure appear for users of The Raisers Edge. Select the user you want to disconnect and then click Disconnect.

A message appears to verify you want to disconnect the user. To disconnect the user, click Yes. You return to the main screen of the Blackbaud Management Console. Database Backups To access backup information, select Backup in the Installed products tree view on the main screen of the Blackbaud Management Console. When you select Backup, the Backup utilities appear in the pane on the right. You can run the utilities from the Tools menu or the Backup page. A database backup creates a copy of the full database.

Not all pages are copied to the backup set, only those actually containing data. Both data pages and transaction log pages are copied to the backup set. Backup utilities include scheduling a backup, running a backup on demand, and restoring from a backup. Scheduling a Backup Using the Blackbaud Management Console, you can set database backup options, such as scheduling a time and frequency for the backup.

You can run a scheduled backup with users in the system, although the users might experience performance issues. Scheduling database backup The screens depicted in this procedure appear for users of The Raisers Edge. For scheduled backups to run, the SQLAgent service must be running. From the main screen of the Blackbaud Management Console, select Backup in the Installed products tree view.

The Backup screen appears on the right. In the Schedule Backup frame, click Schedule. The Schedule Backup Wizard appears. To schedule the time and frequency for creating a backup, mark Enabled and specify the Frequency and time of the backups. The Set Backup Path screen appears. In the Select a path for the backup files field, enter a location to store your backup files.

To map to the location, click the browse button. To have the files zipped after the backup, mark Compress files after backup. To remove files over a specified age in the backup process, mark Remove files older than [ ] days and enter the maximum age of files to keep. To send a notification to a specified workstation or user when the backup is complete, mark Net Send notification when backup is finished and, if it differs from the default, enter the name of the workstation or user to notify.

Running a Database Backup The backup through the Blackbaud Management Console copies your database to the hard drive of the server running the database. To have a secure backup strategy, we recommend you also make proper backups to removable media.

You can run a full or compressed backup of your database while users continue working in the program. The compressed backup option copies your data files, compresses the copies into a single WinZip file, and deletes the copies. However, if your database contains a single file larger than 4GB, you cannot run the compressed backup. When you prepare your backup schedule, coordinate the database backup with your system backup so the system backup comes after the database backup. Also, in MSDE, you must run a back up for each database in your system.

Running a database backup The screens depicted in this procedure appear for users of The Raisers Edge. In the Backup path field, select a location for the backup. Using the Blackbaud Management Console, you can schedule the time and frequency for creating a backup. If you select this option, the Send data to Blackbaud checkbox is enabled. Unless you have been directed to by Blackbaud Technical Support, do not mark this checkbox.

To send a notification to a specified workstation or user, mark Net Send notification when backup is finished and, if it differs from the default, enter the name of the workstation or user to notify. To generate a text file that details the backup process, mark Output File and click the browse button to map to the location to generate the output file. To start the backup, click Backup. Restoring from a Backup Using the Blackbaud Management Console, you can restore your database from a backup.

This process works with full and compressed backup files. Once the database is restored, all data entered since creating the backup will be lost.

To make sure you fully understand the process, we recommend you test the restoring-from-backup procedure. Familiarizing yourself with the process before you actually need to use it may avoid delays and extended down time when you actually need to restore your database from a backup. To restore from a backup, users must be out of the database. Restoring from a database backup The screens depicted in this procedure appear for users of The Raisers Edge.

In the Restore From Backup frame, click Restore. The Restore Database screen appears. To run the backup utilities, you can also click the icons that appear in the backup frames or use the Tools menu. In the Backup file to restore field, enter the location of your backup database. To locate the backup database, click the browse button.

Enough free disk space exists where the Raiser s Edge 7. Updating from The Raiser s Edge 7. For information about how to attach a database, see Attach Database Wizard on page If your system does not satisfy these conditions, you receive two options.

Select the type of update to perform. On a Getting Started screen with three options:. We recommend this option for most installations of The Raiser s Edge. The Database Migration Wizard appears. For detailed information about this wizard, go to Update from The Raiser s Edge 7.

For detailed information about this wizard, go to the Attach Database Wizard on page For detailed instructions about this wizard, go to Attach Database Wizard on page However, if you use Blackbaud s accounting software, The Financial Edge, or education software, The Education Edge, a new management console shortcut does not appear.

Select Migrate a Database and click Begin. The Welcome to the Migrate Database Wizard screen appears. Note: Before you migrate a database, we recommend you run a database validation and check your database for problems.

For information about how to validate a database, see the Database Administration Guide. The Select Source Database screen appears.

To locate the database, click the ellipsis. The Select Destination Database screen appears. A list of all SQL Server instances available on your network appears, and the button changes to Registered. In the Select Server box, select the server in which to migrate your database.

In the Path for migrated database field, enter a location for the database. In the Name for migrated database field, enter a name to identify the database in the Blackbaud Management Console. In the Description for migrated database field, enter a description of the database. This description appears on your workstations database selection screens to help users identify the database.

As the database migrates, a processing screen appears. Once the migration is complete, the Completing the Migrate Database Wizard screen appears. Before you move the data, you must shut down the ASA database engine. Copy all the database files and add them to your new server. To add the database files to the new server, you can use the Edit, Copy and Edit, Paste menu options in Windows Explorer.

You can practice with the program before you migrate your database. We recommend you use the sample data as a training tool. It contains examples of the many features available in the program. If you use The Raiser s Edge on a server, all workstations share the sample data, and all users can see all changes. When you update to The Raiser s Edge 7. You cannot update from The Raiser s Edge 7. To use a standalone system, perform these requirements.

We strongly recommend you use a proper backup system. If you do not have such a system in place, use the Blackbaud Management Console. If you use an MSDE database, you receive a warning during installation. Before you update The Raiser s Edge, back up your database. Exit all Windows applications. Close any virus scan programs. Close the Microsoft Office toolbar, when present.

It may interfere with the installation of some files. Due to the integration between The Raiser s Edge and Microsoft Outlook, if your workstation users use Outlook, they must exit and log out of Outlook before you update The Raiser s Edge on their computers. If they fail to exit and log out of Outlook, the update may not install properly. Visit Microsoft s website at to download the latest version. To securely store sensitive credit card and merchant account information, the program uses the Blackbaud Payment Service web service.

Before you can download the update utility for The Raiser s Edge, your organization must have an account with the Blackbaud Payment Service or select to truncate all credit card numbers in your database. If you attempt to download the utility before your organization has done either, the Blackbaud Payment Service web page appears.

If your organization uses ICVerify to process credit card transactions through the program, you also enter the security token to identify your organization when ICVerify requests credit card information from the Blackbaud Payment Service. After you enter these credentials, you can log in to the program.

To use the Blackbaud Payment Service to store your credit card information, you must have an Internet connection. If you cannot access the Internet to connect to the web service, you cannot update to The Raiser s Edge You must either remove the credit card information from your database or cancel the upgrade process. This version of SQL Server works for databases smaller than 3. The patch keeps your system current with Microsoft s security recommendations.

If Service Pack 2 is not installed, visit Microsoft s website at to download it. We recommend that you monitor patches to keep your system current with Microsoft s security recommendations. If the required service pack is not installed, visit to download the latest version. Workstations can also run Windows Vista bit or bit or Windows 7 bit or bit. For more information, see the Installation Guide. Before you update The Raiser s Edge, you do not have to uninstall previous versions of the program.

Installation Requirements for a Server A network installation configures the software for multiple users who work on multiple workstations.

To use a network system, perform these requirements. Make sure clients of The Raiser s Edge are logged out of the system. The update process copies all update files and integrates the settings configured when the Blackbaud Management Console was originally set up to facilitate a deploy package. The deploy package updates a workstation when a user with local administrative rights and rights to the deploy package logs into the workstation.

After you install The Raiser s Edge, you must enter a user name and password for the web service. Close any virus scan programs on the server and workstations. Close the Microsoft Office toolbar, if present. For the deployment package to update The Raiser s Edge on a workstation, a user must have local administrative rights to add software to that computer.

After you complete the upgrade, perform the backups and maintenance items outlined in the Database Administration Guide. Installation Requirements for Oracle To use an Oracle database, perform these requirements. When you update The Raiser s Edge, you can skip builds. You do not have to update builds consecutively. Check the Blackbaud website at for any updates. Select Support, Downloads from the menu bar. With this file, you can revoke database administration rights from all connections to the database made through The Raiser s Edge.

You must run this script file while connected as SysDba. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including photocopying,. Conversion Guide Blackbaud, Inc. Database Administration Guide Blackbaud, Inc. Point of Sale Guide Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic,.

This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means,. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical,. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including.