How to copy a SportApp database from one machine to another

Note: For software updates and creative content subscriptions, please log in to your AJT service portal

Question

  •    How do I copy or attach a database from one machine to another

Environment

  • Product Family: Software and Controllers
  • Product: Live Book GFX®, SportApp
  • Component:  
  • Control System: AJT Systems a Division of Daktronics

Answer/Steps

  1. Zip or copy the existing database from the filesystems default file path. The file path is C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA. Make sure to get the correct .mdf and .ldf file
    copy1.png
  2. Unpack and paste those 2 files into the same directory on the target computer
    C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA
  3. Attach the newly copied database using SQL management studio. Click on the database plus icon to expand it. Right click on databases and choose attach.
    copy2.png
  4. Click the Add button
    copy3.jpg
  5. Select the file and press ok
    copy4.jpg
  6. Press ok to close out the attach database dialog
    copy5.jpg
  7. The database list should contain the added database
    copy6.png

Related Resources

How to copy a team, league or show between two SportApp machines

KB ID: DD4566881


Fill out my online form.
DISCLAIMER: Use of this content may void the equipment warranty, please read this DISCLAIMER prior to performing any service of the equipment.