Hi James,

It's easy to rebuild your databases. check my app's part:

  lcdatabase="mydb"

   TEXT TO lcsqlcom  ADDITIVE NOSHOW TEXTMERGE 
   
      CREATE DATABASE <<lcdatabase>>
      USE <<lcdatabase>>
      
      /*------ tkformka ------ */
      CREATE TABLE tkformka (
       formno int PRIMARY KEY,sipno int,odemeno int,belgeno int,belgetar datetime,basildimi char(1),
       dovkod char(3),kur decimal(19,4),onay char(1),tarih datetime,vadgun smallint,gun smallint,
       kim char(10),iptal char(1),otositip char(1),ozelkod char( 5),tkkayno decimal(19),sira smallint,
       carikod char(20),adres1 varchar(40),adres2 varchar(40),ilce varchar(15),il varchar(15),
       sevktar datetime,depokodu char(20),aciklama1 varchar(50),aciklama2 varchar(50),
       aciklama3 varchar(50),aciklama4 varchar(50),vadetarihi datetime,adi varchar(30),
       soyadi varchar(15),tlindirim decimal(19,4),yuzdeindir real,masraf decimal(19,4),
       kdvdahil char( 1),topkdv decimal(19,4),toplam decimal(19,4),yekun decimal(19,4),
       vdairesi varchar(15),vno varchar(15),yuvarlama smallint,sonindir decimal(19,4),
       sonartir decimal(19,4),siveren char(15),sipalan char(25),sipduz char(15),
       peozacti smallint,otositar1 datetime,otositar2 datetime
       ,guid uniqueidentifier )

       CREATE INDEX guid      ON tkformka(guid)
       CREATE INDEX carikod   ON tkformka(carikod)
       CREATE INDEX tarih     ON tkformka(tarih)

ENDTEXT
  sqlrun(m.myhandle,m.lcsqlcom)

>Hey All,
>
>OK so I developed my application using VFP as the front end and SQL as the backend. I want to install on the target machine with VFP and MSDE on the same machine (for now). Can anyone point me to articles or references on how to have the installation put MSDE on the target machine along with rebuilding the database structures on the target machine (I'm assuming executing a script generated by SQL but how do I make the install process do that)?
>
>Aloha,
>
>James