This Q&A article provides information on how Data Connector can be used to perform a data migration, restore or copy of data from one Notification Server database to another. PLEASE NOTE: Symantec Technical Support is unable to assist the customer with the in-depth implementation or troubleshooting of using Data Connector to migrate, restore or copy data. Symantec Technical Support can provide the customer with information on how best to achieve their goals and can demonstrate how to set up an import rule, but for extensive configuration, the customer can contact Symantec Consulting Services for this, who can be reached at http://www.symantec.com/it-consulting-services.
Question: Can Data Connector be used to perform a data migration?
Answer: The answer depends on the nature of the migration:
One-time migration
Data Connector can be used to migrate data from an old Notification Server version to a new version, such as 6.0 to 7.5. This is very complex, however, because the customer would need to be familiar with what tables and data classes to access, and be familiar with the differences in the database schemas between the two versions. Because of this, is it strongly recommended to instead use the Data Migration Wizard for data migration.
Continuous migration
If the customer needs to have an on-going "migration" of data, using the Data Migration Wizard would not be practical. The best suggestion is to then create a linked server object in SQL Server Management Studio to the old version's database and then make custom reports to view its data on the new Notification Server. This is the officially supported way to use "continuous" old data on a new Notification Server.
Question: Can Data Connector be used to perform a database restore or copy data from one database to another?
Answer: If data is needing to be restored, it is recommended to perform a database restore in Microsoft SQL Server to the last known good backup of the database. With that said, Data Connector can be used to restore or copy data from one database to another. The complexity is similar to using Data Connector to perform a data migration, however, as the customer would need to be familiar with what tables and data classes to access.
Question: Can Data Connector be used to migrate or copy Inventory data?
Answer: While Data Connector can be used to migrate or copy Inventory data, this is not recommended. This can result in problematic or duplicate inventory. Additional information on this can be found in the following article:
How to import AddRemoveProgram and InstalledSoftware data using a Data Connector import rule
http://www.symantec.com/business/support/index?page=content&id=HOWTO84052
Question: With the above information and complexity in mind, how can Data Connector be used to perform a data migration, restore or copy data from one database to another?
Answer: To begin with, the customer should be familiar with how to create and configure an import rule. Information on this can be found in the following articles:
Symantec Management Platform 7.1 SP2 User Guide
http://www.symantec.com/business/support/index?page=content&id=DOC4730
How to import data using a Data Connector Import Rule
http://www.symantec.com/business/support/index?page=content&id=HOWTO79380
Next, it should be noted that there is not usually a single table for resources that can be used with the import rule. This results in likely needing numerous import rules to be used to numerous tables for a single resource type. The most efficient way to do this is by using an OLEDB data source that references a custom import SQL query that the customer creates. For example, computers are desired to be migrated/restored/copied. The following, in brief, describe how this can be accomplished:
Notes: (1) The following article further discusses how to create a Data Connector import rule that accesses a database:
How to create a Data Connector data source that can access a database
http://www.symantec.com/business/support/index?page=content&id=HOWTO94484 (2) An internal-only Symantec Knowledge Base article exists that further demonstrates how to perform these steps. This can be provided upon request by contacting Symantec Technical Support and asking for article HOWTO85114.
Question: Since using Data Connector to migrate data is very complex, is there an easier way that this can be performed?
Answer: Yes, use the Data Migration Wizard. Migration and implementation guides can be found in the Symantec Knowledge Base. Some of these include:
Symantec™ IT Management Suite powered by Altiris™ technology Migration Guide version 7.0 to 7.5
http://www.symantec.com/business/support/index?page=content&id=DOC5669
Symantec™ IT Management Suite powered by Altiris™ technology Migration Guide version 6.x to 7.5
http://www.symantec.com/business/support/index?page=content&id=DOC5668
Best practices for migrating to Symantec Management Platform 7.1
http://www.symantec.com/business/support/index?page=content&id=HOWTO54437
Altiris™ IT Management Suite from Symantec™ Migration Guide version 7.0 to 7.1
http://www.symantec.com/business/support/index?page=content&id=DOC3550
Altiris™ IT Management Suite from Symantec™ Migration Guide version 6x to 7.1
http://www.symantec.com/business/support/index?page=content&id=DOC3549
Related Article
How can Asset data be imported/copied/migrated to a new Symantec Management Platform server?
http://www.symantec.com/business/support/index?page=content&id=HOWTO95167