Home > How to use the multi write function of the Modbus driver

How to use the multi write function of the Modbus driver

Page 1
Page 1
Advantech AE Technical Share Document
Date 2015 / 3 / 20 SR# Category ��FAQ �� SOP Related OS Microsoft Windows Server 2008 Abstract How to migrate data from MS Access into SQL Server Keyword migrate data, MS Access, SQL Server, WebAccess, SCADA Related Product WebAccess V7.2, V8.0 ∎ Problem Description: The default database of WebAccess is MS Access, subject to the limits of the MS Access Database itself; each data file capacity is 2 GB. When the data quantity is too big, will influence on the speed of data query and report output, so we would better to replace the database with the large capacity database like SQL Server or Oracle etc.,. The historical data is stored in the MS Access before, can also be imported into the SQL Server or Oracle. In this SOP, we will illustrate how to migrate MS Access 2007 data into SQL Server2008. ∎ Brief Solution - Step by Step: On the network, there has many methods to migrate the data from MS Access into SQL Server; in the documents we use the ��SQL Server Migration Assistant for Access��. SQL Server Migration Assistant could do these things: ✧ Save the database structure, including data, indexes, and the default value etc. ✧ Automatically Access validation rules and preset equivalent transformation into the appropriate SQL Server. ✧ After the transformation, maintain the integrity of the data table associated with reference. Specific steps are as follows: Step1: Download the tool named ��SQL Server Migration Assistant for Access�� from the following Microsoft web site: http://www.microsoft.com/sql/solutions/migration/default.mspx Step2: Before doing the migration, we should add a database in SQL Server. You should use WebAccess to do it, so in the database; there will have the default tables of WebAccess. Step3: After install the ��SQL Server Migration Assistant for Access��, start the tool, there will pop up a Migration Wizard window automatically. You can do the congratulations follow its steps, as shown in Picutre1.

Page 2
Page 2 Picture1
Step4: Create a new SSMA project. The ��Name�� and ��Location�� you can freely define. ��Migrate to�� is the target database version, must choose correct version of SQL Server, otherwise there will be errors in the process of migration. Here, we choose the ��SQL Server 2008��, as shown in Picutre2.
Picutre2
Step5: Add Access database files to the migration project. If you don��t know the location of the file, you can use the ��Find Database��, as shown in Picutre3.

Page 3
Page 3 Picture3
After this step, you also can Close the wizard, and continue setting in the tool windows. Step6: Select Objects to Migrate In the ��Access Metadata Explorer��, there are all queries and tables in the database file. You can choose the tables that will be migrated to SQL Server, as shown in Picutre4.
Picture4
Step7: Connect to SQL Server or SQL Azure Click the ��Connect to SQL Server��, in the Connect to SQL Server window, we will enter the SQL connection information. My SQL Server is in local, as shown in Picutre5.

Page 4
Page 4 Picture5
Step8: Link migrated tables When the connection is successful, in the ��SQL Server Metadata Explorer��, we will see the existing databases in SQL Server. Then you can choose the corresponding tables of database that be created in step5, as shown in Picutre6.
Picture6
Step9: Convert objects, load them to database, and migrate data. Click the ��Migrate Data�� to start. Step10: After finish the migration, we need to change the type of ��LogDate�� from ��datatime�� to ��date��, and change the type of ��LogTime�� from ��datatime�� to ��time��. In this way these data can be queried from WebAccess.

Set Home | Add to Favorites

All Rights Reserved Powered by Free Document Search and Download

Copyright © 2011
This site does not host pdf,doc,ppt,xls,rtf,txt files all document are the property of their respective owners. complaint#nuokui.com
TOP