Homework
There's no homework portion for this project.
Personal Database Project
Port your database from Access/Jet to SQL Server (on one of the lab machines). For safety's sake, keep a copy of your original mdb file on your network drive.
Now, in order to access your new SQL Server database from any of the machines in the lab, you should load it onto the SQL Server instance running on one of the machines, preferably stallman (the instructor's station). Do this by logging into stallman as a database administrator (I'll tell you how to do this or do it for you myself), and importing the database using stallman's SQL Server enterprise manager. Do the import as we did it for the movies database in lab #6, except that this time you must import from a SQL Server database stored on another lab machine (rather than from an mdb file on the local machine), and give your database a name that will be unique.
What to turn in
Use Knightvision to submit a notification (in the comments sections of the submission) that you've finished your export by next lab period, telling me what you called your database. I'll check that your databases are loaded properly on stallman.
Back to the top