Home Products Downloads Purchase Support News Members Company
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly. Click Here for more info.
FAQs
Quick answers to common questions. Click Here for more info.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.
Online Documentation
All of our help files for download or convenient viewing online. Click Here for more info.
Videos
Watch product demos, training videos, or tutorials of our products' main features.  We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools


Is there a way to skip the errors on execution with .NET executable generated by ApexSQL Script?

SUMMARY


The way to skip a script execution error with generated .NET executable is discussed.
SYMPTOMS

I scripted my database as .Net Executable, but on its execution there was thrown an error and the package dialog got closed.

RESOLUTION
Yes, it is possible to skip a script execution errors.
For selected output type .NET executable




You can set Ask for Confirmation error handling option ON.




You can skip then any error happened during the package execution.




LAST REVIEW

17 September 2007 Date of Last Review

Labels:

...


Is there a way to script my objects in the proper creation order?

SUMMARY

It is possible to script the objects in the proper creation order.

SYMPTOMS

Script execution completed with errors because of attempt to create dependent objects before the objects they depend on.

CAUSE

The generated script uses incorrect objects creation order.

RESOLUTION


Make sure that Explicitly Parse Database for Proper Script Creation Order option is turned On.




If this option is enabled ApexSQL Script will parse the database looking for the object dependencies and building the proper object creation order.

LAST REVIEW

19 September 2007 Date of Last Review

Labels:

...


Script Wizard warns me that I didn’t select the objects for a single chosen database.

SUMMARY
I selected only one database for scripting but anyway Script Wizard warns me that I didn’t select the objects for scripting, but I did. What’s wrong here?

SYMPTOMS

Script Wizard displays the message "Please select at least one object to script for database ..." for case of a single database is chosen and objects for scripting are checked.

CAUSE
This happens if you didn’t select the objects in the mode you chose in the Script Wizard. For example, you did select the objects in Data mode:





And didn’t select any in Structure mode:






However in the Script Wizard you chose scripting Structure Only:






ApexSQL Script warns you to select the objects in Structure mode:





RESOLUTION

Verify that that objects are checked in the Structure or(and) Data mode according to mode they are to be scripted in(Data, Structure, both Data and Structure).

LAST REVIEW

19 September 2007 Date of Last Review

Labels:

...


After few databases selection for scripting at Script Wizard start up I was warned that I had to select at least one object.

SUMMARY
The reason of appearance of the warning is explained.

SYMPTOMS
When starting Script Wizard a message-box with the warning "Please select at least one object to script for database ..." is displayed.

CAUSE
You did not select any object to be scripted for one of the chosen databases.



RESOLUTION
Change the current database selection to the database pointed in the warning and select the objects to be scripted or de-select the database to not consider it at scripting stage.

LAST REVIEW

19 September 2007 Date of Last Review

Labels:

...


Welcome to the ApexSQL Troubleshooting and Known Issues

Welcome to the ApexSQL Troubleshooting and Known Issues. This is an online resource to help you find solutions to known issues with Apex SQL tools.

Labels: , , , , , , , , , , ,

...

© 2008 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy