I think you're likely stuck with exporting each DataPerfect panel into a CSV file (a standard DataPerfect function) and then importing each panel export into your SQL database. This can be done on a SQL Server 7 using the Bulk Copy Program (BCP). BCP is a command-line utility that ships with SQL Server 7. I believe the syntax below will work:
- bcp [<database-name.>][<owner.>]<table-name> in
<csv-file> [/U<username>] [/P<password>]
[/S<server-name>] /c /t,
- <database-name> is an optional parameter specifying the name of
the database. It can only be omitted if the desired database is the
default database.
- <owner> the name of the table owner.
- <table-name> the name of the table.
- <csv-file> The name of the comma separated file.
- <username> The SQL Server username to use. This can be left blank if NT authentication is used.
- <password> The password to use for the account.
- <server-name> The name of the server on which the database resides. This can be omitted if the database is local.
- <owner> the name of the table owner.
-
1) The flags above are case sensitive.
2) Each receiving table should expect the fields in the same order as
they are saved in the DataPerfect export file.
Good luck.
Pat Riley
505-797-9072
At 02:00 AM 7/30/2007, you wrote:
I need to convert a dataperfect application to Microsoft SQL Server.
Are there any tools available that will help me with that ?
I can analyze the .STE file by hand, but since this application has 60-70 panels, an automated way of converting is very much prefered.
Thanks in advance for the assistance.
Walter Hissink
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
