Export Views from database to database

medboutakat's profile image medboutakat posted 10 months ago in Import/Export Permalink

if u export databaseA to an other databaseB check views defination , views will read data from databaseA

in export the name of databaseA is addeed in database B view definition and if u check definition of a view in database B u will find for example

this difiniton from databaseB but the but it stell read data from database A ALTER ALGORITHM = UNDEFINED DEFINER=gmsoft@% SQL SECURITY DEFINER VIEW view_vente_order_output_all AS select o.REFERENCE AS RefSorie,ol.ID AS ID,c.CLIENT_CODE AS Code Client,c.NOM AS Client,ol.OUTPUT_ID AS OUTPUT_ID,ol.LIVRAISON_ID AS LIVRAISON_ID,ol.PRODUIT_ID AS PRODUIT_ID,ol.PRODUIT_REFERENCE AS PRODUIT_REFERENCE,ol.DESIGNATION AS DESIGNATION,ol.UNITE_ID AS UNITE_ID,ol.QUANTITE AS QUANTITE,ol.PRIX_UNITAIRE AS PRIX_UNITAIRE,ol.TAUX_TVA AS TAUX_TVA,ol.REMISE AS REMISE,ol.NOM1 AS NOM1,ol.NOM2 AS NOM2,ol.NOM3 AS NOM3,ol.DATE_EXPIRY AS DATE_EXPIRY,ol.FREE_QUANTITY AS FREE_QUANTITY,ol.PRIX_ACHAT AS PRIX_ACHAT,o.ID AS outPutId,o.REFERENCE AS REFERENCE,o.LIVRAISON_DATE AS LIVRAISON_DATE,o.VALIDATION_DATE AS VALIDATION_DATE,o.VALIDATION AS VALIDATION,o.CLIENT_ID AS CLIENT_ID,o.MONTANT_TOTAL AS MONTANT_TOTAL,o.TotalRemise AS TotalRemise,o.DELEVERED AS DELEVERED from ((databaseA.vente_order_output_ligne ol join databaseA.vente_order_output o on(ol.OUTPUT_ID = o.ID)) join databaseA.vente_client c on(c.CLIENT_ID = o.CLIENT_ID)) ;

ansgar's profile image ansgar posted 10 months ago Permalink

This was an issue very long ago in an outdated HeidiSQL version. Which HeidiSQL version are you using?

ansgar's profile image ansgar posted 10 months ago Permalink

Probably same as issue #1064 ?

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