Modify an existing SQL mapping for Sql server

[bill_wu]

I add a new field in dept file, and it is added successfully in sql DB.

I want to change the field type from "varchar"(default) to "nvarchar", but it could not work. I can change it manually in DB, but the front-end can not recognize the change.

Then I move the file from SQL back to P4, then go to "Modify an existing SQL mapping", change the field type, the screen message shows that the update is successful, but when I go out and back to see the mapping, it remains the same before update.

I follow the data conversion doc to do this -----restart the service with no backgroun process and login with one user.

Any one who can help? Thanks in advance.

[harn145]

Which version of SC/SM are you on?

[bill_wu]

SC: OVSC6.2
DB: Sql server 2005

[harn145]

You could consider changing it on the RDBMS and then using the "sync" type option (the actual name eludes me at the moment) in dbdict that retrieves the RDBMS settings.

[thommey]

Hi,

1. you don't need to move the file back from sql to P4
2. add the field to your sql db (no clue if alter table in sc is working correct now)
3. Use your sc sql utilities: "modify an existing sql mapping"
4. check there the field and change the field type if needed
5. save it and proceed
6. sc sql utilities: "update mapping template"
7. check their the field and field type and save it
8. sc sql utilities: "refresh sql cache"
9. you are done!

Regards
Thommey