How to migrate from ASA 8.0 to 10.0 Database?


We are trying to convert some of our client databases from ASA8 TO ASA10 and we are facing different problems with different databases. Can you help us in solving the problems faced?

When we just create a new database in ASA8 and tried to migrate to ASA10, we were successful in doing so with out any problems.
But we faced the following problems in converting existing databases in ASA8 to ASA10:
A. After few steps of execution the following error occurs

Creating new database

***** SQL error: Syntax error near '(end of line)' on line 1

The database <database name> could not be unloaded.

The database <database name> could not be unloaded.


For another existing db:

B. All the tables were loaded and new database is created but the following error occurs after that:

Creating indexes

***** SQL error: There is already a variable named '@ls_report'

The database <database name> could not be unloaded.

The database <database name> could not be unloaded.


Can you let us know if any trouble shooting document available with respect to this migration?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

xsysysAuthor Commented:

As we were working from our side to solve the below migration problems, we could find that the error ***** SQL error: Syntax error near '(end of line)' on line 1

Was due to one of our stored procedure (Still we could not trace the exact problem in stored procedure) but when we delete this stored procedure in ASA8 and migrate, we could migrate the database to ASA 10.


***** SQL error: There is already a variable named '@ls_report' => the error was occurring as in a stored procedure duplicate variable was declared i.e. the same variable was declared twice!

Solution: - When we remove one of the declarations and then migrate the database, we could migrate the database.
Because you have presented a solution to your own problem which may be helpful to future searches, this question is now PAQed and your points have been refunded.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.