For some reason the ancient PB of received a project, using SQL server 2000 as the database,

At the completion of the new requirements of the modified, need to deploy, use

Don't know why, before leaving deployment method, asks to install SQL server 2000, require the user to create the ODBC data source system, require the user to make additions database, this project itself is a very light project, the results become so deployment and its complex and time consuming,

Later I use GSQL instead of a complete sql2000, but still need the user to add additional database, data source and the

So my question is, the use of SQL server program, in the deployment of the general database is how to deal with?

These steps can create a data source automation, additional database?

Can completely get rid of to install SQL server this step, the software to make such as green software, easy installation, mobile?

If you have, for PB project how to deal with, please?

Thank you for your attention!

CodePudding user response:

If you are using SQL Server database, as far as I know, this step can't get away from the installation database,
I generally is write a program that I can use the code to create the database, create a table, or additional database,
Green's database, I have seen only a database file, but when you meet the data volume larger performance is washed-up,
Or look at your own application,

CodePudding user response:

Join in the OLEDB way, configured the corresponding address with respect to OK,

CodePudding user response:

Your program written in SQL, database construction, build table, lead based data

CodePudding user response:

Essentially a database itself is inevitable need to environment, but can hold a desktop