Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

fascination view-effect

cibmagic's profile image cibmagic posted 2 weeks ago in General Permalink

Hi Forum,

i am running dozens of databases for my Company. In fact, there is one, who is "the haert and the Soul" of all.

Once per month i run an import-session from sap over. To prevent any crashes, i use a 1:1-copy of my db for "the first" Import - if this causes no probs, i'll do the Import to the original (ok, there are better ways, but ....)

Fact: The "test"-db is a 1:1 copy of the original, made by heidi-SQL via "Export database as sql"

If I (me, on my Workstation) open this TEST-db (!!!!!!!!) = Copy i see my my views-sources like this (as expected) :

select bla, bla, bla from table join table ... join table (and so on)

if other's (with very much less rights to the Server !!!!) open the same view-source, they see: select bla, bla, bla from ORIGINAL-DB.table join ORIGINAL-DB.table ...

So, any changes in the copy won't affect the views in the copy

I own two Screenshots, which Show the different presentation of the same view-code on two different Clients - working in a Hospital i like not to present them online !

So - does "Export database as SQL" mean, that views allways reference to the orig-db, not to the current db, in this case test-db ????????

Oh my god, what an fucking english - hope you've understand me ....

Best Regards Stephan

Is this NORMALLY for SQL, is it a Problem of Server-Rights ??? or what ?

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.