Login  Register
How to set up the Database for your Perkulator Portal

We recommend using Microsoft SQL Server 2005, or use SQL Server 2005 Express


Download the Perkulator Portal from www.perkulator.com. Included within the download is 2 sql script files:

  • Database_Structure.sql
  • Database_Data.sql

  • Load your database management software, such as “SQL Server Management Studio” if you are using SQL 2005.

  • If you are using SQL 2000, use "Enterprise Manager" as your database management software.


    Create a new database. To create a new database, right click on "databases" and select "new database". For this example, we will assume you have named your database "PerkDB".

  •  


    Open the Database_Structure.sql file with your database management software.
    Select "PerkDB" as the active database.

    Click the "Execute" or "Run" button in your management software to initiate the sql script to run against the PerkDB. You can access this feature by right-clicking within the sql script editor window.

    Once the software has finished, it should have successfully created new database objects based on the script you opened.

    Open the Database_Data.sql file with your database management software.
    Select "PerkDB" as the active database.

    Click the "Execute" or "Run" button in your management software to initiate the sql script to run against the PerkDB. You can access this feature by right-clicking within the sql script editor window.

    Finished!

  • Your database should now be ready to be used with the Perkulator portal files

     

    Remember to set up the portal's "~/web_database.config" file!

  • Refund Policy  |  Privacy  |  Terms of Use  |  Contact
    Hits: 54293  
    Powered by Perkulator Portal
    © 2004-2008, All Rights Reserved