If you just create the database in SQL 2000 you can get all the tables in
with an ODBC import.
You can get SQL 2000 Server and all the MS OS's and Vision 2002 and Office
XP all for $299 through the MS subscription program. Check the archives here
for info or let me know and I can repost it.
That will be the easiest way to move all the data. You won't need the SQL
the database import should grab the correct columns and data types. You
might have to reset primary key's.
Dan
on 6/11/02 7:05 PM, Len Wright at [EMAIL PROTECTED] wrote:
> You might have better luck going to MS-SQL. As I recall, MS-Access is
> different enough from SQL to make a smooth migration not quite work.
>
> Either way, it's going to require you to get the sql code from pervasive. I
> don't know if Pervasive can do that. If it can, then either run it in the
> query analyzer in ms-sql, or create a procedure in ms-access using the sql
> from pvsw
>
>
>
> Regards,
>
> Len Wright
> Plus International Corp
> www.plusinternational.com
>
> Direct: 604-415-2384
> Fax:604-415-0830
>
>
>>>> [EMAIL PROTECTED] 06/11/02 12:09PM >>>
> Hi,
> Is there a way I can export the database structure of a database in
> pervasive SQL to MS Access database?
>
> Please help.
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
