FoxPro/Visual FoxPro - Crear instalador incluyendo MYSQL + db + tables

 
Vista:

Crear instalador incluyendo MYSQL + db + tables

Publicado por loly (6 intervenciones) el 27/06/2014 16:51:39
Hola buenos días amigos, saludos a todos que este bien G.A.D.
Estoy creando un SETUP de mi distribuible, he logrado integrar el conector de mysql desde Drivers&DNS del InstallShield pero no he podido integrar el MYSQL que incluye el Administrador y el querybrowser, así como la base de datos y las tablas de la misma.

Si alguien sabe como hacerlo quisiera me hiciera el favor de pasarme el dato...

Crear el SETUP y se instale Runtimes de vfp.+ sistema + Mysql + Base de Datos + Tablas +. ETC.

Saludos
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder
sin imagen de perfil

Crear instalador incluyendo MYSQL + db + tables

Publicado por Ernesto Hernandez (4623 intervenciones) el 18/07/2014 20:24:50
To create an installation that creates a SQL Server database on the target machine by running customized SQL script:

Create a new Basic MSI or InstallScript MSI project.
In the View List under Behavior and Logic, click Property Manager.
Create a new property that has the following name:

IS_SQLSERVER_DATABASE2
In the View List under Server Configuration, click SQL Scripts.
Add and configure a new SQL connection:
Right-click the SQL Scripts explorer and click New SQL Connection. InstallShield adds a new connection with the name NewConnection1 as the default name.
In the SQL Scripts explorer, click the NewConnection1 item, and then click the General tab.
In the Default Target Server Name (optional) box, type TESTSQLSERVER.
Clear the Create Catalog If Absent check box.
In the Connect using area, select the Server authentication using the Login ID and password below option.
In the Login ID box, type sa. Leave the Password box blank.
Click the Requirements tab.
Ensure that the Microsoft SQL Server check box is selected and the MySQL and Oracle check boxes are cleared.
Add and configure a new SQL script for NewConnection1:
In the SQL Scripts explorer, right-click NewConnection1 and click New Script.
Change the name of the script to NewScript1.
In the SQL Scripts explorer, click NewScript1, and then click the Script tab.
In the script editor pane, add the following script:

CREATE DATABASE [TestDB] ON (NAME = N' TestDB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\testdb.mdf' , SIZE = 3, FILEGROWTH = 10%) LOG ON (NAME = N' TestDB_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\testdb.ldf' , SIZE = 1, FILEGROWTH = 10%)

COLLATE SQL_Latin1_General_CP1_CI_AS

Click the Runtime tab.
In the Script Execution area, select the Run Script During Login check box and ensure that the Run Script During Install and Run Script During Uninstall check boxes are cleared.
Add and configure a second new SQL connection:
Right-click the SQL Scripts explorer and click New SQL Connection. InstallShield adds a new connection with the name NewConnection2 as the default name.
In the SQL Scripts explorer, click the NewConnection2 item, and then click the Advanced tab.
In the Target Catalog Property Name list, select IS_SQLSERVER_DATABASE2.
Click the General tab.
In the Catalog Name box, type TestDB.
Clear the Create Catalog If Absent check box.
In the Default Target Server Name (optional) box, type TESTSQLSERVER.
In the Connect using area, select the Server authentication using the Login ID and password below option.
In the Login ID box, type sa. Leave the Password box blank.
Click the Requirements tab.
Ensure that the Microsoft SQL Server check box is selected and the MySQL and Oracle check boxes are cleared.
Add and configure a new SQL script for NewConnection2:
In the SQL Scripts explorer, right-click NewConnection2 and click New Script.
Change the name of the script to NewScript2.
In the SQL Scripts explorer, click NewScript2, and then click the Script tab.
In the script editor pane, add the following script:

CREATE TABLE TestTable (TestColumn1 CHAR NOT NULL PRIMARY KEY)

Click the Runtime tab.
In the Script Execution area, select the Run Script During Install check box and ensure that the Run Script During Login and Run Script During Uninstall check boxes are cleared.

When you run the installation, it creates the TestDB database and adds a table called TestTable to that database.

Suerte !!
Valora esta respuesta
Me gusta: Está respuesta es útil y esta claraNo me gusta: Está respuesta no esta clara o no es útil
0
Comentar