Hi, You can link to your Cache database from MS SQL server through ODBC. (Create a DSN for your Cache DB on SQL Server, then create a linked server via this DSN to your Cache database). This far I've done and works.
Then you'll need to see if "Generate SQL script" option is available for those tables. Regards, Teoman "Leonardo J. Tramontina" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Does anyone know if it's possible and how to do to generate a SQL script to > create the tables of my application? > Let me be more clear: I have my classes and would like to generate a script > to create tables based on my classes definitions in order to make tests in > others relational data bases. For example, for my class Person, I have Name > (%String, MAXLEN = 50, required) and DOB (%Date, format 4, required) > properties. I�d like it generates the following script: > > CREATE TABLE User.Person (Name char(50) not null, > DOB date not null) > > > Thanks, > Leonardo > >
