how to deploy windows application in c# or vb
-
hello all, I'm a Asp.net developer and i know how to deploy a asp.net site with sql server database. in asp.net website we just link with Remote server and deploy our database on that server. but my question here is that while creating a window application in c# or vb if we have a database in sqlserver how we will deploy the sql sever database on every client machine individually. is there any option in setup and deployment wizard. or we there is any other way. Regards
Amit Agarwal
-
hello all, I'm a Asp.net developer and i know how to deploy a asp.net site with sql server database. in asp.net website we just link with Remote server and deploy our database on that server. but my question here is that while creating a window application in c# or vb if we have a database in sqlserver how we will deploy the sql sever database on every client machine individually. is there any option in setup and deployment wizard. or we there is any other way. Regards
Amit Agarwal
You wouldn't normally deploy sql server with an application, you normally have sql server running on a dedicated windows server on the network and clients connect to it, otherwise you have no single database for the company - each user has their won database, which doesn't make sense.
Bob Ashfield Consultants Ltd
-
hello all, I'm a Asp.net developer and i know how to deploy a asp.net site with sql server database. in asp.net website we just link with Remote server and deploy our database on that server. but my question here is that while creating a window application in c# or vb if we have a database in sqlserver how we will deploy the sql sever database on every client machine individually. is there any option in setup and deployment wizard. or we there is any other way. Regards
Amit Agarwal
There's no option. People generally deploy an Access DB if they can. Otherwise you need to deploy SQL Server Express, and code to create the database within it. This is a fair bit of work.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
There's no option. People generally deploy an Access DB if they can. Otherwise you need to deploy SQL Server Express, and code to create the database within it. This is a fair bit of work.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
hello guys thanks for your reply. but after googling i found that there are some options why which we can do this if you look at this forum reply.. http://bytes.com/forum/thread142240.html[^] you will fnd out that Dan Guzman replied that "Depending on your requirements, you can include the scripts in a .Net project as either content files or as embedded resources. You can then include that project in your Setup and Deployment project. Your custom action can read and execute the scripts from either the resource assembly or from the file system" this seems gud but i don't know how to achieve this. and what about this Article: http://www.codeguru.com/csharp/.net/net_security/encryption/article.php/c9601__1/[^] Regards
Amit Agarwal
-
hello guys thanks for your reply. but after googling i found that there are some options why which we can do this if you look at this forum reply.. http://bytes.com/forum/thread142240.html[^] you will fnd out that Dan Guzman replied that "Depending on your requirements, you can include the scripts in a .Net project as either content files or as embedded resources. You can then include that project in your Setup and Deployment project. Your custom action can read and execute the scripts from either the resource assembly or from the file system" this seems gud but i don't know how to achieve this. and what about this Article: http://www.codeguru.com/csharp/.net/net_security/encryption/article.php/c9601__1/[^] Regards
Amit Agarwal
Basically it means you can deploy a program which creates the database. Which is what I was saying. The program still needs to run, and it need to find the DB, and run the scripts to create your tables, etc. Access mdb files are easier.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
Basically it means you can deploy a program which creates the database. Which is what I was saying. The program still needs to run, and it need to find the DB, and run the scripts to create your tables, etc. Access mdb files are easier.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )