Hi all,

We have baan application with following configuration :

baan iv c4
service pack : 21
localization : in5
database : mssql 2000 standard edition

porting set : 6.1c.07.08 port number PA.2777

can anybody give step by step procedure for updrading database from ms sql 2000 to ms sql 2005.

thanking in advance,
vishal mistry

If u have possibility to install SQL 2k5 separately ,copy small SQL 2k data to SQL2k5 instance then I would recommend u that approach first . U may try only 0 company data .

Default sort order for new db's should be ISO_Latin_american_general1 binary .

U only need to create new 2 db definitions for SQL2k5 , and link the same to the tables in ttaad4120m000 and convert to runtime DD .

Once found successful , u can just import / export other companies . U may need to test tabledef change (table linking to DB ) in offline mode (when no other users work) .

dear sir,
i followed following steps to see if things work:

1. copied whole database from ms sql 2000 to sql 2005
2. created database users in ms sql 2005 for baan and baandb and set neccesory security.
3. in tabledef6.1, i added one line for particulart table (tiitm000) and pointed to my new database server.

also, when i transferred data from 2000 to 2005, it did not copy stored procedures and tables indexes. for checking purpose i manually created index and stored procedure for tiitm000.

it worked fine and i was able to modify item parameters through baan session itself but still not satisfied with the steps i followed. i would appreciate if you can tell me steps which i am required to carry out.

thanking in advance,
vishal

U can restore SQL 2k backup to SQL 2k5 .

Alternatively u can export all baan db tables and import the same server to server with all constraints and objects .

Make sure u have the right porting set (probably 6.1c.07.13 ) before u do this complete exercise . There is no need for new license keys for this .

dear sir,

thanks a lot for ur help. i restored my sql 2000 database to on sql 2005 and changed MSQL_SERVER parameter in session ttaad4110m000 to point to my new database server. after doing this i am able to connect to this new server from baan application and do all everything except the following:

1. creating database users
2. changing password for database groups

when i tried to do above two things, it gave me error. i am attaching screen dump for reference. hope to get more help from you.

thanks a lot.
vishal

The last problem sounds like a password problem with your database system administrator (the user is usually sa) password. These sessions should prompt you for a password. Are you entering the correct sa password for the SQL 2005 server?

Vince

Yes i am entering correct password.

vishal

Where is the error message .