Jump to content


Photo

Transferring an AccuTrack Database to SQL Server


  • This topic is locked This topic is locked
No replies to this topic

#1 dfoster

dfoster

    Advanced Member

  • Moderators
  • PipPipPip
  • 238 posts
  • Gender:Male
  • Location:Winter Park FL
  • Interests:Guitar

Posted 04 March 2009 - 09:00 AM

Here are the steps to transfer a database to MSSQL Server using AccuSQL. These steps assume that MSSQL Server 2005/2008 (standard, enterprise, or Express) is setup with TCP and Named Pipes and allows for remote connections and that you have an "sa" account you can use for the transfer process.

1) Open AccuSQL and login as a root administrator.
2) In the bottom left area of AccuSQL, click on the Expanded View radio button.
3) Access the Database --> Transfer database to SQL server option.
4) In the Native data path to transfer area, click the Select Path button. In the Data Folder Path pop-up screen, navigate to the database you would like to transfer and press OK.
5) In the SQL server connection info (SQL server admin role account) area, enter the SQL Server name, authentication mode (SQL server authentication preferably) and the "sa" username and password. In the Database field, type the name for the database you are creating. The Owner field is optional, but typically would be dbo.
6) Now press the Test Connection button. If all is well, you will get a "Test connection succeeded" message. If not, you will get an error message. Verify all the information is correct and retest until you get a success message.
7) Press the Transfer Data button. You will get a "Transferring data to SQL Server" message and AccuSQL will initiate the database creation in SQL Server.
8) After the process completes, press Close Form in the Transfer database to SQL server window.
9) Now access the Database --> Database Location screen and click the SQL Server radio button and click the Next button.
10) You should not change anything in the Application Share Path area. In the SQL server connection info area, enter your server name, authentication mode (SQL server authentication preferred), and your "sa" username and password. In the Database drop-down menu, select the database you just created.
11) Now press the Test Connection button. If all is well, you will get a "Test connection succeeded" message. If not, you will get an error message. Verify all the information is correct and retest until you get a success message.
12) Press the Save button and then press Close Form.
13) Now press the main Exit AccuSQL button to close the application.
14 When you reopen AccuSQL, you will be connected to the SQL Server database. Congratulations!

Tips: If you are sure you have the correct credentials but are having trouble with the transfer, there are a few things you should check.

1) Make sure you have SQL Server correctly setup with TCP and Named Pipes and that you allow for remote connections. You can access the ConfiguringAccuTrackSQL.doc document in the <ROOT>\program files\Accu10Sql\Manuals directory of your installation CD for detailed information.
2) You may need to install the MSOLEDB native connectivity client. To do so, double-click the sqlncli.msi installer in the <ROOT>\program files\Accu10Sql directory of your installation CD. You can use the default installation options.
3) You may have an outdated native file set. These files are created automatically when AccuSQL is first opened. To recreate the native files, exit AccuSQL then in Windows Explorer, navigate to the C:\Documents and Settings\All Users\Documents\accutrack directory and delete any files and/or directories located under it. Typically the temp directories start with an "i3" folder name. After deleting, restart AccuSQL and the temp files will be regenerated and you can proceed with the transfer steps above.
4) Finally, if you still are having trouble, just contact AccuSQL support and they will be happy to assist.

Thanks,
David Foster
AccuTrack Support
david@accutrack.org

David Foster
Engineerica Systems Support





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users