` Printed Icetips Article

Icetips Article



Par2: Convert TPS to SQL Server table, 5 easy steps
2010-02-21 -- Ikrami Sami
 
5 steps to move your TPS Table to SQL Server Table ::::

1- ( In SQL server ) Create table in SQL server with same tps table name and same 
      fields name
2- ( In Clarion Dictionary Editor ) Convert all string fields to  Cstring ( Don't forget
to 
      browse after that )
3- ( In Clarion Dictionary Editor ) best way to do it ( after you create your table in
SQL
      server , import it to clarion dictionary, so the date fields will be configured
      automatically )
4- Database Driver must be ( ODBC or Microsoft SQL )
5- Finally move you date from TPS to SQL Server, Export your data to excel file then 
    import it to your SQL Server


** For convert all TPS To SQL :

http://www.par2.com/getit/dct2sql_c7.zip



Printed May 1, 2024, 2:45 am
This article has been viewed/printed 35241 times.