Problem with compare of views: Project -> DB database name

michabbb · Post by **michabbb** » Mon 28 Nov 2011 17:20

hi,
today i´ve found an issue i don´t know if this is a bug or if i am doing something wrong. while comparing a view (project file) with the DB, i never get them synchron because project says:

SELECT
`bs_webtool`.`bilder_zu_modell`.`bhm_pic_id`

and DB says

SELECT
`bilder_zu_modell`.`bhm_pic_id`

and an update at the server (5.1.49-3-log (Debian)) seems nothing
to change here.

any ideas ???

thank you!
micha

michabbb · Post by **michabbb** » Mon 28 Nov 2011 17:23

of course i can remove the database name from all my view-files, but that seems not to be the perfect solution for this, especially the project files were created by dbforge... ;(

alexa · Post by **alexa** » Tue 29 Nov 2011 08:48

There is the 'Target database name' option on the 'Database' page in project's properties. However, if a database name is specified in the script, the 'Target database name' option is ignored.
When creating a project, you may select the 'Prefix object names with a database name' option to prefix object names with a schema name in the script. So, you can unselect the 'Prefix object names with a database name' option and all scripts will not include a database name. After that you can manage a database using project properties.

michabbb · Post by **michabbb** » Tue 29 Nov 2011 12:10

perfect, I will try, thank you!