Is .net framework and sql server needs to be installed fully

Question

Hi everyone

I had developed application in c# with sql server as a backend database.

kindly tell me whether I have to install full .net framework and sql server management studio and sql express on the target computer

or is their any native runtime executable that work for this case.

As file size of sql server is approx 1gb and it takes approx an hour to install.

Is there any solution that save time and space too.

Thanks in advance

Answer 1

You can run your query from sqlcmd.

Answer 2

But sql express doesnot allow us to manage tables, login etc. Its management studio provides login, running scripts etc. how to tackeltackel that.

Answer 3

It is necessary to install .net framework. For SQL server there is no need to install management studio on client machine. You also can install express edition of SQL server.