Importing an Access Database from Blackthorne

Overview:

Blackthorne users can use either an Access database or a SQL Server database. SixBit can only import a SQL Server Blackthorne database, so if you are using an Access database in Blackthorne, you will need to upgrade it to a SQL Server database first. The good news is that installing SixBit can make the Blackthorne upgrade process easier and you can follow the steps below to upgrade your Blackthorne database and then import it into SixBit.

Steps:

1. First, you must make sure you are running Blackthorne version 4.01.016 or greater. You can check this in Help|About. If you are not running 4.01.016 or greater, upgrade to the latest version and start the program to apply any database changes.

2. Next, you'll install the latest version of SixBit (v. 1.00.009 or later). By installing SixBit, a copy of SQL Server 2008 R2 will be installed on your computer and you won't have to manually install SQL Server as described in the Blackthorne process. Its actually easier to use SixBit to upgrade your Blackthorne database than to use the Blackthorne process itself.

3. Follow the Blackthorne instructions at http://67.192.117.186/robo/projects/blackthornepro/Database_Management.htm#Creating_an_SQL_Server_Database to create a SQL database in Blackthorne. You should use the Windows Authentication option, and the instance name of SIXBITDBSERVER instead of SQLEXPRESS. Click the Create SQL Server Database button to begin the process.

NOTE: If you are not running Blackthorne Pro, you may not see the option to upgrade to a SQL Server database. If so, please see https://www.sixbitsoftware.com/clients/knowledgebase.php?action=displayarticle&id=54 for instructions on creating a SQL Server database using Blackthorne Basic.

SQL2

After it completes and switches you to the SQL database, you can exit Blackthorne.

SQL4

4. Start SixBit. Un-check "Import my currently running eBay Listings" on the Welcome screen.

SQL6

Click Continue to fill in the License Key and Business Profile information if you haven't already.

SQL7

5. Click the Application button in the upper left (orange guy) to select the Import|Import from Blackthorne Option.

SQL8

Set the Authentication method to Windows Authentication and the instance name to SIXBITDBSERVER, matching the ones used in Step 3.

SQL9

6. Let it run. Depending upon the size of your database, it may take a while. Once finished, SixBit will switch to the newly created SixBit database, SixBit-BT after a restart.

SQL10

7. One more thing... when converting your Blackthorne database to SQL Server, you may have to run a Blackthorne procedure to grant the proper backup permissions. The following topic from the Blackthorne documentation explains how to do this. http://67.192.117.186/robo/projects/blackthornepro/HOWTO_-_Setting_SQL_Server_Backup_Permissions.htm

8. Congratulations, you're done. Welcome to SixBit!

Was this answer helpful?

 Print this Article

Also Read

Creating a SQL Server Database with Blackthorne Basic

Background:To import a Blackthorne database into SixBit, it must be a SQL Server database. ...

Inventory Levels Aren't Accurate After Import from eBay

Symptom:After importing from eBay some items do not have accurate inventory values. Cause:When...

After Import, Sales are Linked to the Wrong Item

Symptom After an import from eBay, some sales are created showing the wrong picture and are...

Setting Database Backup Permissions

  Overview:SixBit interacts with Microsoft SQL Server to store your data. When you make a...

Import from CSV is not Importing Any Items

Symptom:After importing from CSV, the items do not appear anywhere in SixBit. Cause: The most...