Skip Navigation Links
xFDN Home
Contributions

Database copy to MS SQL Server

Author: Sheetal Dehadaraya, Software Labs Inc.
xFusion Studio 3.2 has added a data cloning utility. This utility can perform a complete backup of any data source to MS SQL server.
Steps to generate a SQL backup -
  1. Choose any connector to create a source connection for example, QuickBooks.
  2. Create the destination connection to SQL Server.
  3. Right mouse click on the QuickBooks connector to choose the option "Copy to SQL Server".
  4. Select the QuickBooks source connection name and the destination SQL server connection name. Specify the databse name to be created.
  5. Click Start to start the backup process.
The left hand side shows the status of fetching data from the source table. You can monitor the backup progress on the right hand side.
By the end of the process we have a complete backup of the QuickBooks data in SQL server's QBConnProduct database.
©2007 Software Labs, Inc.