• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 485
  • Last Modified:

How to migrate from ASA 8.0 to 10.0 Database?

Hi,


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?

0
xsysys
Asked:
xsysys
1 Solution
 
xsysysAuthor Commented:
Hi,




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.
0
 
EE_AutoDeleterCommented:
xsysys,
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.

EE_AutoDeleter
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now