# [1.6.0.72 RC] Database migration fails on MS SQL
**URL:** https://www.finalbuilder.com/forums/t/91-1-6-0-72-rc-93-database-migration-fails-on-ms-sql/5960
**Category:** Bugs
**Created:** [March 4, 2015, 4:01am UTC](https://www.finalbuilder.com/forums/t/91-1-6-0-72-rc-93-database-migration-fails-on-ms-sql/5960 "2015-03-04T04:01:23Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@catenalogic](https://www.finalbuilder.com/forums/u/catenalogic)
#### Post date: [March 4, 2015, 4:01am UTC](https://www.finalbuilder.com/forums/t/91-1-6-0-72-rc-93-database-migration-fails-on-ms-sql/5960/1 "2015-03-04T04:01:23Z")
Could not initialise database: An error occured executing the following sql: UPDATE builds\_variableprompt vp SET variableid = v.id FROM core\_variable v WHERE v.name = vp.variablename The error was Incorrect syntax near ‘vp’. Check the eventlog for more info
---
### Author:  [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [March 4, 2015, 11:34am UTC](https://www.finalbuilder.com/forums/t/91-1-6-0-72-rc-93-database-migration-fails-on-ms-sql/5960/2 "2015-03-04T11:34:55Z")
HI Geert,
Thanks for reporting this. I knew I missed something. I’ll get an update as soon as possible.
---
### Author:  [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [March 5, 2015, 6:33am UTC](https://www.finalbuilder.com/forums/t/91-1-6-0-72-rc-93-database-migration-fails-on-ms-sql/5960/3 "2015-03-05T06:33:14Z")
Hi Geert,
The database migration code has now be updated and tested in SQL Server. The update is included in version 1.6.0.73 RC.
---
### Author:  [@catenalogic](https://www.finalbuilder.com/forums/u/catenalogic)
#### Post date: [March 5, 2015, 11:27am UTC](https://www.finalbuilder.com/forums/t/91-1-6-0-72-rc-93-database-migration-fails-on-ms-sql/5960/4 "2015-03-05T11:27:19Z")
Works great now, thanks!