Page 1 of 1

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

Posted: Mon 28 Nov 2011 17:20
by michabbb
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

Posted: Mon 28 Nov 2011 17:23
by michabbb
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... ;(

Posted: Tue 29 Nov 2011 08:48
by alexa
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.

Posted: Tue 29 Nov 2011 12:10
by michabbb
perfect, I will try, thank you!