Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
- file has been selected to download. You can either download the file now with any of the other files selected below or add them to your download folder in order to download them at a later time. Adding files to your download folder is recommended when downloading multiple files at a time. By downloading, you agree to the Software Transaction, License and End User License Agreements listed here.
- file has been selected to download. You can either download the file now with any of the other files selected below or add them to your download folder in order to download them at a later time. Adding files to your download folder is recommended when downloading multiple files at a time. By downloading, you agree to the Software Transaction, License and End User License Agreements listed here.
Customers who have selected the file above have also downloaded the recommended files listed below. Popup blocker should be disabled in order to download the files listed below
- file has been selected to download. You can either download the file now with any of the other files selected below or add them to your download folder in order to download them at a later time. Adding files to your download folder is recommended when downloading multiple files at a time. By downloading, you agree to the Software Transaction, License and End User License Agreements listed here.
- file has been selected to download. You can either download the file now with any of the other files selected below or add them to your download folder in order to download them at a later time. Adding files to your download folder is recommended when downloading multiple files at a time. By downloading, you agree to the Software Transaction, License and End User License Agreements listed here.
Customers who have selected the file above have also downloaded the recommended files listed below. Popup blocker should be disabled in order to download the files listed below
Please wait while we verify your entitlement to this file...
Downloads are restricted from Tablet and Mobile devices. Please access this page from a non-restricted device to complete this download.
Prior to downloading this Software, you must review the Software Transaction Agreement located here and confirm, by clicking the I agree check box below, that your organization accepts and is bound by the terms and conditions of the Software Transaction Agreement for this Software.
If you purchased the licenses for this Software by executing an order form with Quest or if you have an agreement with Quest that states that all purchases are governed by such agreement, then the terms and conditions of that agreement supersedes and takes precedence over the Software Transaction Agreement.
I agree to the above.
Our technical support staff has identified the following critical information to get you started. To get the best results make sure you read through all material prior to using your Quest Product.
Summary
This article explains how to insert data into SQL table using the Create new table feature.
Description
Along with the basic functionality to insert data into existing SQL tables the application has the capability to use the structure from an existing SQL table, create new one in a SQL database and then insert the desired data into it.
To start with the process, the first step upon starting the application is to set the SQL Server, type of the Authentication and the SQL database in the New project window. For this example will be used SQL Server 2019, Windows authentication type and the AdventureWorks2018 database:
Clicking on the Next button the Action tab will be shown which is the second step to do to be able to insert data into SQL table. Here the Import mode should be selected and clicked on the OK button:
Once these initial steps are done the AdventureWorks2018 database will be loaded into the main grid with the default settings:
To import and insert data into SQL table that will be created later, the following steps should be taken. Click the Manage button from the Home tab and the Manage import window will be opened:
Under that window click the button to choose the data source. There are two options for data sources, Database and File. For this example the File data source will be used:
Click the browse button and navigate to the file which will be used to insert data into SQL table, select it and then click the Open button. In this example the Excel file dbo.NewListCustomers will be used:
After that the view will go back to the previous window and by clicking OK button the Excel data will be shown into the Manage import window. For the options the Detect range automatically will be used which will automatically detect the whole range of data in the dbo.NewListCustomers.xlxs Excel file, in this example the data in the file is from the A1 to the K51. Then Import by rows mode will be used and for the Header, the First row in range selected to include the column names when the new table is created and data inserted:
When the source data is set, click the OK button in the bottom right of the Manage import window and the view will go back to the main grid of the application. The next step to set up and insert data into SQL table is to choose the SQL table with the structure which will be used in the new SQL table. In the new SQL table the columnsCustomer ID, Company Name, Contact Name and City will be used. In this example structure with such SQL table already exist in the SQL database named dbo.Customers and this SQL table is be used as template for the new one:
Click the Settings panel on the right side and from the Mapping drop down menu select the dbo.NewListCustomers.xlxs Excel file which will be used to import the new list of the data for the new SQL table. Under the Table select the Create new option and enter the name for the new table, in this case SQL table will be named dbo.NewCustomerList2020 and for Import mode leave the default option Insert new:
The last step before starting the import process is to map the columns in the main grid, as mentioned, in this case the columns Customer ID, Company Name, Contact Name and City will be used. For every column click on the drop down menu and select the matching column name:
When everything is set start the process by clicking the Process button from the Home tab:
It will show the Process window with affected tables and columns, in this case one SQL table will be affected and 4 columns (Customer ID, Company Name, Contact Name and City):
Click the Import button to execute the process and when it is finished it will show the results in the View results window. For this example successfully is created new NewCustomerList2020 SQL table with inserted data into 4 new columns:
To see that data from the Excel file is properly inserted, the SELECT TOP query will be run in the SSMS and results will be shown which prove that exact defined 4 columns are mapped and the new SQL table is created:
Below is a list of the recommended software along with any documentation that will help with the install process to bring your product to the version referenced.
Version | Full Support as of | Limited Support as of | Support Discontinued |
---|---|---|---|
2020.02 | 4/16/2020 | ||
2020.01 | 2/29/2020 | 4/16/2020 | 10/16/2021 |
Earlier product versions not listed are considered discontinued. |
The Product Support Life Cycle table above describes the phase during which products are eligible for product support and new release downloads.
As a result of Quest's recent divestiture from Dell, Quest acquired a number of products from Dell. Some of these legacy products found on this website may still contain Dell branding. However, these products are now owned and supported solely by Quest and not Dell. Dell is not affiliated with these products or services and any services Quest provides for these products is independent of Dell.
The Product Support Life Cycle describes the phases during which our products are eligible for patches (fixes), support and downloads from the Support Portal.
It is our policy to provide support and fixes in current versions of our products when you are under a current support agreement. Fixes to older versions are at our discretion. We strive to put resources behind the most recent product releases in order to continually improve and enhance the value of our solutions.
We will attempt to answer questions on older versions of our products provided resources are available; however, if you are using a discontinued version, we encourage you to upgrade to the currently supported version of the product.
Our usual support policy is to provide support on both the current (n) and prior (n-1) versions of our products. Refer to the product life cycle table on your Product Support page or Knowledge Base for specific supported versions of your product.
Full Support
Limited Support
Discontinued
Continuing Support
If you are unable to upgrade or migrate your product prior to its end-of-life, we offer a Continuing Support service to provide you with one year of limited support beyond your software's end-of-life or end-of-support date. Continuing Support is not guaranteed on every product:
For solutions that include an appliance, if we determine a hardware part needs
to be replaced, a replacement part is delivered to your location based on the terms of your agreement. Regardless of the service response level purchased, some component parts are specifically designed for easy removal and replacement and are designated as Customer Replaceable (CR). If during the diagnosis we determine that a service request can be resolved with a CR designated part, we ship the part to you. If the part is not designated as CR, we provide on-site parts replacement during the next business day or within four business
hours based on the service level you purchased.
Learn more about Quest
Support Services.
We recognize that certain support offerings and policies may change as the acquired company is fully integrated into the Quest® Support organization. Our goal is to make sure the continuity of services remains as synergistic as possible during this time. To help during the transition, we provide information and links about recent acquisitions on our Support Portal. For questions or support for a product that we have recently acquired, contact Customer Service using the numbers listed on the Contact Support page on our Support Portal.
Product Enhancements
If you are interested in submitting product enhancement requests, you can do so by creating a case with support. When we receive a product enhancement request, the Support Engineer will work to define and clearly document the request. Once documented, the request will be submitted into the enhancement review system, the identification number will be provided to the submitter, and the support case will be closed.
Product Management will review the open enhancement requests on a periodic basis and consider them for inclusion in a future product release. Product enhancements will not be considered or implemented in current or prior product releases. There is no guarantee that a specific enhancement request will be implemented in a future version of our product. It is at our discretion if a certain enhancement will be offered for an additional charge or as a chargeable option.
Product Defects
If your issue is determined to be a defect in the product, it is recorded in our defect tracking system, a unique Defect Identifier (ID) will be provided to you and the support case will be closed. Notifications of new product releases will be emailed to you as long as you who have configured your profile to receive product notifications. Release Notes for new releases of products will contain the list of Defect Identifiers that were addressed in the release. You can review the release notes or search the Knowledge Base on the Support Portal using your Defect Identifier to see if the issue has been addressed. We do not guarantee that all defects identified will be fixed in a future release of the product.
Our products have license keys generated
for your use. Some products require a new license key when upgrading to a new release and/or patch. We recommend that prior to any migration or upgrade of our products, new licenses
are confirmed as functioning properly because some license keys are machine and machine name specific.
If you have questions about licensing of a product, complete the form available on our Support Portal Licensing Assistance page. A licensing representative will respond to your query within 24 hours.
Support for Trial Users
We offer software trials on selected products for evaluation purposes. Support for trial users is limited to 30 days from the registration date. Service Requests for your trial software may only be submitted during the first 30 days of your testing period.
Addtional Services
There may be times when additional resources are required to solve your case. We can work with Quest Services to ensure a reliable handoff of your issue.
Quest Services for your solutions
Quest® adoption services ensure your IT staff is effectively using your solution to its fullest potential. Quest deployment services help you quickly install and configure your product properly.
Quest software-enabled services combine the strengths of our proprietary software, tools and domain expertise to reduce complexity, demands on your IT staff and costs. Quest Services help you:
Visit Quest Professional Services.
A customization indicates functionality and configurations added to a Quest® product that are not provided as part of the standard generally available product release and, as such, would be outside the scope of the support and maintenance services provided herein. Customizations can include new or modified scripts used within or alongside our products as well as additional functionality,such as custom reports, dashboards,rules and automated actions, developed by you, your partners or our services organization.
Support and Customizations
Technical support does not perform or maintain customizations. The design and development of customizations to our products is your responsibility. Assistance from technical support is limited to helping ensure that the product’s functionality, which enables the addition of customizations, is functioning as expected. Alternatively, you may obtain guidance
through product-specific support sites or the Support Portal Knowledge Base.
Advanced Assistance
If more thorough and detailed assistance is needed to design and develop customizations, we recommend that you engage our Quest Services organization or fully certified partners to assist. Their expertise in designing customized solutions will ensure that you receive maximum value and product adoption. In addition to providing post-implementation expert services, Quest Services also offers a variety of prepackaged customizations for products that may meet your specific requirements
Educational Services
We recommend that you obtain appropriate product training before attempting to design, develop and implement any customization to our products. Our training courses will equip you with the necessary knowledge and ability to design and implement effective changes to our products. For more details on the training services available, refer to the Quest Educational Services section.
Maintaining Customizations
Careful consideration should be given to all customizations during future migration or upgrade exercises to new product or platform versions. Customizations could inhibit the upgrade itself and may require a level of rework to continue functioning properly. Technical support does not take ownership for any customizations. We strongly encourage you to document and maintain records on any implemented customization work. These records can be useful in determining whether problems are caused by customization or are a defect in the core product.
Our products leverage the binary compatibility offered through virtualization technologies, which provide complete transparency to the operating systems and applications deployed. As
a result, for all service requests received where the product is being used in a virtual environment, we assume that the problem is common to both native and virtual operating environments and that we require you to recreate the problem in a native environment if and when there is reason to believe that the problem is unique to the virtual environment itself.
From a purely functional perspective, our products operate in exactly the same way; however, we can make no guarantees with respect to performance or scalability in a virtualization environment running multiple virtual instances. Configuration aspects, such as CPU, memory availability, I/O subsystem and network infrastructure, can all influence such
a deployment, which should be given careful consideration to ensure that the virtual layer has the necessary resources available to provide a satisfactory user experience.
We provide full details of all systems requirements, together with platform and third-party product versions supported on our products, in the release notes published for each product. These include operating system versions, service-pack levels, mail clients or server versions, database versions, browsers and other related technology supported, as well as which particular version level our products have been formally tested and certified to run against. The support of future platform versions, new service packs and other related technologies is generally taken into consideration and addressed during the regular product maintenance and release cycles of our products. Contact Quest® Support if you have questions regarding the current support status of any product and a particular related platform, patch or third-party product support not explicitly documented in our release notes, and we will provide collaborative assistance with the product in question.
For more information about the latest third-party platforms and versions supported, review the system requirements section of the release notes for your product or search the Knowledge Base on our Support Portal. Please note that while we do not directly or officially support third-party software, we work closely with many other providers to
ensure that you receive the best possible service at all times.
Regional software license agreement applicable to your use of the software is available below (including software preinstalled on hardware or made available to you by download, disk media or otherwise, at no additional cost).
Click here to find your regional agreement.
A security vulnerability is a flaw or weakness in the design, implementation, operation or management of a product or service that could be exploited to violate the system's security policy. To protect businesses and organizations worldwide, it is critical that the broader community of IT and security professionals report potential vulnerabilities as soon as they are recognized. This allows industry experts to take appropriate action to resolve any vulnerability that is discovered.
Click here to review Vulnerability Reporting information.
Click here to review Vulnerabilty Reporting Acknowledgements.
You have been redirected to xxxxx which contains support information for yyyyy.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
Upgrade to IE 11 Click here
Upgrade to Chrome Click here
If you continue in IE8, 9, or 10 you will not be able to take full advantage of all our great self service features.