Export Views from database to database

medboutakat's profile image medboutakat posted 9 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 9 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 9 months ago Permalink

Probably same as issue #1064 ?

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