---
title: Grabbing Necessary Database Files (SMS)
description: Clubspeed Customer Knowledge Center
---

[Skip to content](https://help.clubspeed.com/clubspeed-knowledge-center/grabbing-necessary-database-files-sms#main-content)

English

Show submenu for translations

[More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new?hsLang=en)

[![Clubspeed Logo](https://help.clubspeed.com/hs-fs/hubfs/Logo_Grey.png?width=500&height=86&name=Logo_Grey.png)](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new)
- [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6)

[Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Clubspeed Customer Knowledge Center](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en)

December 6, 2024

# Grabbing Necessary Database Files (SMS)

 Search

### Grabbing Necessary Database Files (SMS)

**NOTE: This is to help the customer get the necessary files.** 

If a customer needs guidance on grabbing the tables. 

On the server, load up IB Expert. 

If it is password locked, there is not much more we can do. (See Below)

If not locked, on the left hand side, select the tables below:

Tables that Need to be exported in to CSV files(Excel).

- T\\\_CUSTOMER
- T\\\_CUSTOMER\\\_2\\\_ADDRESS
- T\\\_ADDRESS
- T\\\_PRODUCT
- T\\\_MEMBER\\\_CARD
- T\\\_MEMBERSHIP
- T\\\_CUSTOMER\\\_2\\\_MEMBERSHIP
- O\\\_ASSET\\\_LINE\\\_ACTIVE

Once selected (May need to double click), click on the Data tab. 

Scroll to the bottom, then click file at the top. 

Select Export Data, Choose location and (CSV) format. 

Once receiving the files, forward them to a dev. 

They will create the necessary scripts to import the data to our CS Server. 

Run the scripts they give you. 

 

If the DB is locked.

Their should be an SMS management portal. 

They can grab the customer database here, as well as the memberships.

There is an Asset section that has important info regarding memberships or gift cards.

Getting DB access is far better.  

- <https://www.facebook.com/sharer/sharer.php?u=>
- <https://twitter.com/home?status=>
- <https://plus.google.com/share?url=>
- <https://www.linkedin.com/shareArticle?mini=true&url=&title=&summary=&source=>

### Related Articles

- [FAQs](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#main-content)

    - [Software Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#software-questions)
    - [Payments Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#payments-questions)
- [Getting started](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#main-content)

    - [Clubspeed](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#clubspeed)
    - [Administration](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#administration)
    - [Product Setup](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#product-setup)
    - [Customer Experience](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#customer-experience)
    - [Race Control](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control)
    - [Manager Controls](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#manager-controls)
    - [Point of Sale Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#point-of-sale-operations)
    - [Venue Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#venue-operations)
    - [Race Control Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control-operations)
    - [Event Calendar](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#event-calendar)
    - [Open & Closing Shifts](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#open-closing-shifts)
    - [Activity Setup (FEC Non Karting)](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#activity-setup-fec-non-karting)
    - [Kart Focused](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#kart-focused)
- [Troubleshooting](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#main-content)

    - [networking](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#networking)
- [General](https://help.clubspeed.com/clubspeed-knowledge-center/general?hsLang=en)
- [Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#main-content)

    - [Gift Cards](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#gift-cards)
- [Integrations](https://help.clubspeed.com/clubspeed-knowledge-center/integrations?hsLang=en)
- [Payments](https://help.clubspeed.com/clubspeed-knowledge-center/payments?hsLang=en)
- [Email and Text Messaging](https://help.clubspeed.com/clubspeed-knowledge-center/email-and-text-messaging?hsLang=en)
- [Item Management](https://help.clubspeed.com/clubspeed-knowledge-center/item-management?hsLang=en)
- [Resources](https://help.clubspeed.com/clubspeed-knowledge-center/resources?hsLang=en)
- [Calendar Management](https://help.clubspeed.com/clubspeed-knowledge-center/calendar-management?hsLang=en)
- [Customer Management](https://help.clubspeed.com/clubspeed-knowledge-center/customer-management?hsLang=en)
- [Promotions and Marketing](https://help.clubspeed.com/clubspeed-knowledge-center/promotions-and-marketing?hsLang=en)
- [Updates](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#main-content)

    - [Release Notes](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#release-notes)
- [Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#main-content)

    - [Setting up Your Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#setting-up-your-registration)
    - [iPads](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#ipads)
- [Products](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#main-content)

    - [Business Additions](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#business-additions)
    - [Extra Tips & Tricks](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#extra-tips-tricks)
    - [Setup](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#setup)
    - [Point of Sale](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#point-of-sale)
    - [Barcode](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#barcode)
- [Activities](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#main-content)

    - [Activity Operations](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#activity-operations)
- [Reporting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#main-content)

    - [Sales Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#sales-reports)
    - [Operational Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#operational-reports)
    - [Labor Report](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#labor-report)
    - [Accounting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#accounting)
    - [Race Operations](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#race-operations)
    - [Quickbooks Online](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#quickbooks-online)
- [Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#main-content)

    - [Setup - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#setup-club-booking)
    - [Operations](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#operations)
    - [Booking Manager](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#booking-manager)
    - [Bonus Material - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#bonus-material-club-booking)
- [Operational Flows](https://help.clubspeed.com/clubspeed-knowledge-center/operational-flows?hsLang=en)
- [Food & Beverage](https://help.clubspeed.com/clubspeed-knowledge-center/food-beverage?hsLang=en)
- [Speed Screen Displays](https://help.clubspeed.com/clubspeed-knowledge-center/speed-screen-displays?hsLang=en)
- [Garage](https://help.clubspeed.com/clubspeed-knowledge-center/garage?hsLang=en)
- [Support Task](https://help.clubspeed.com/clubspeed-knowledge-center/support-task?hsLang=en)
- [Webinar](https://help.clubspeed.com/clubspeed-knowledge-center/webinar?hsLang=en)
- [Playbook](https://help.clubspeed.com/clubspeed-knowledge-center/playbook?hsLang=en)

[![2022-clubspeed-newsletter-header-logo](https://help.clubspeed.com/hs-fs/hubfs/2022-clubspeed-newsletter-header-logo.png?width=240&height=42&name=2022-clubspeed-newsletter-header-logo.png "2022-clubspeed-newsletter-header-logo")](https://help.clubspeed.com/?hsLang=en)

Copyright © 2024, Club Speed, LLC