migrate to SQL
Hello Grant,
I was going to suggest this way as well.
Mike
Mike Matthews, Managing Director, Lineal Software Solutions Ltd
Apple Reseller, Microsoft Partner, SQLWorks Business Partner
phone: 01271 375999 | web: lineal.co.uk <www.lineal.co.uk/> | email: mike.matthews@lineal.co.uk <mailto:mike.matthews@lineal.co.uk>
> On 24 Aug 2017, at 09:54, Rudolf Bargholz <rudolf@bargholz.ch> wrote:
>
> Hi Grant,
>
> This will take some time, but you could open the DF1 files in the SQL object browser, open a session to some otehr database, and drag and drop all tables from your DF1 to the other database. This will create the tables in the new database, and transfer the data for each newly created table. From there on you can use any functionality available in the destination SQL database. You could probably even open the tables in Excel.
>
> Regards
>
> Rudolf Bargholz
>
> —–Ursprüngliche Nachricht—–
> Von: omnisdev-en [mailto:omnisdev-en-bounces@lists.omnis-dev.com] Im Auftrag von Grant Thiessen bookitinc
> Gesendet: Donnerstag, 24. August 2017 00:02
> An: OmnisDev List – English <omnisdev-en@lists.omnis-dev.com>
> Betreff: migrate to SQL
>
> A client for whom I have only been providing on-call support for several years, has hired a new programmer to provide them with an entirely new program to run their business, and they are doing it in SQL, and not in Omnis.
>
> Frankly, I am happy to see the last of them, but that is another story.
>
> They have requested one last service from me – to provide them with a tool to export all of the data from the multi-segment DFs that they have (3 segments), in Excel format, for subsequent import into the SQL database.
>
> They would require column headers equal to the field names.
>
> I am pretty much retired from programming. (I know, I’m only 70, what am I doing quitting so young?) However, as my programming time spent over the last several years probably is closer to days, rather than weeks, I am sure I could accomplish this, but not without false steps, and definitely not in the most efficient fashion.
>
> Does anyone have code they wish to share which would accomplish this task? It would need to step through the file structure, then export the data for each file into a separate Excel spreadsheet (I have always found tab-delimited). Probably not relevant, but they are all Mac, using Studio 4.3.x, so it’s pre-unicode, and will not be upgraded to Unicode in Studio.
>
> Or, is there a better way to do this? It’s got to be pretty straightforward, since the clients will be performing this themselves if possible, and they are remote from my location.
>
> Clean-up of data in preparation for import to SQL tables has not been discussed. If someone has code that integrates this, it wouldn’t hurt, but I am not taking responsibility for data quality.
>
> Thanks in advance,
>
> Grant
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com