Victoria (Australia) is rich in natural resources and has a strong history of primary industry development. Agriculture, mining, petroleum, fishing and forestry are all primary industries. Department of Primary Industries (DPI) works with these industries so they generate wealth and employment, and also take their environmental and social responsibilities seriously.
DPI wanted their three In-house databases to be migrated from Sybase ASE 12.0 to Microsoft SQL Server 2005. The Sybase database had farmer details like properties, animals, diseases on animals etc. The database migration involved over 100 tables and number of rows varied from just a couple of rows to six million. DPI wanted a comprehensive solution that was fast and highly user friendly ensuring no loss/corruption of data absolutely.
The solution:
DPI chose SwisSQL migration solution for their database migration requirement. SwisSQL Data Migration tool offered the required data migration customizations coupled with a simple GUI to accomplish the database migration. All the tables and its records where migrated successfully saving enormous amount of time.
"Your product did a great job. The SwisSQL Data Migration tool saved hundreds of hours off the project in the development stage and then enabled us to achieve the migration in one weekend.It was an invaluable tool for the project." said Geoff Collishaw, Department of Primary Industries (Victoria).
Key Benefits:
Rapid data migration across databases ensuring data integrity with no loss of data. The whole data migration operation was performed during weekend without any hassles, avoiding any downtime and loss of productivity
Faster time to market, by enabling smooth switching of the production system from Sybase ASE to Microsoft SQL Server
Time and Cost savings by eliminating unproductive manual migration effort
Easy to Install and Easy to Use tool with user friendly & intuitive GUI
About Department of Primary Industries (Victoria, Australia):
DPI was established in December 2002 after bringing together a number of areas from the former Department of Natural Resources and Environment (DNRE). The Department promotes the sustainable development of primary industries for the benefit of all of Victoria. The Department supports the agriculture, fisheries, petroleum, minerals, energy and forest industries in Victoria. DPI uses a collaborative approach to influence improvements in industry performance and to encourage the adoption of new technologies and development practices. It does this by using its expertise in science and technology to provide information and advice on the use and management of resources. DPI also assists industries by running a range of community education and extension programs.
ZOHO Corporation provides affordable software for database migration, management and provisioning of complex networks, systems, and IT applications. With a broad product portfolio and an active customer base ranging from enterprises, equipment vendors, and service providers, ZOHO Corporation has emerged as a very affordable and high-quality alternative to expensive software that is common in this industry.
ZOHO Corporation is headquartered in Pleasanton, CA with offices in NJ, NH, India, UK, China and Japan. It has a well-trained partner base around the globe and thousands of customers world-wide. For more information, call 925-924-9500 or visit our Web site at: www.webnms.com.
________________________________________________________________
