choppaz
June 24th, 2008, 10:43 AM
My background is in C++/Foxpro. In the past, I have written my C++ apps with connections to FoxPro database, and distributed Foxpro runtime engine.
We now have a mandate to use SQL Server 2005 for the database, writing the apps in C#. I think SQL Server is overkill for what I need to do, but it's not my choice. We are not supposed to use SQL Express.
I need to be able to have empty tables each time the application is run. The tables will be populated from ascii files generated by a data-generating tool in a lab. Tables will be populated from these files, in a folder dedicated to a particular "lab run". The C# program will manipulate and produce outputs for that particular run, keeping everything in the dedicated folder for the run.
The application will also be used at other sites (not connected to internet or to our server). I am envisioning having the "skeleton" database (containing no data, only empty tables, stored procedures, etc.) in a dedicated folder. When the application starts, I need to copy the empty tables to the folder dedicated to the run, and populate them. After the application is finished, I need to leave the populated tables in their dedicated folder, containing only data relative to the run.
Any suggestions on how to accomplish this will be appreciated.
We now have a mandate to use SQL Server 2005 for the database, writing the apps in C#. I think SQL Server is overkill for what I need to do, but it's not my choice. We are not supposed to use SQL Express.
I need to be able to have empty tables each time the application is run. The tables will be populated from ascii files generated by a data-generating tool in a lab. Tables will be populated from these files, in a folder dedicated to a particular "lab run". The C# program will manipulate and produce outputs for that particular run, keeping everything in the dedicated folder for the run.
The application will also be used at other sites (not connected to internet or to our server). I am envisioning having the "skeleton" database (containing no data, only empty tables, stored procedures, etc.) in a dedicated folder. When the application starts, I need to copy the empty tables to the folder dedicated to the run, and populate them. After the application is finished, I need to leave the populated tables in their dedicated folder, containing only data relative to the run.
Any suggestions on how to accomplish this will be appreciated.