i want to use sql server database as vb.net backend. do i need to create databse programmatically .?

Question

i m using sql server as my backend for vb.net application. i have added sql server database in my project. do i need to create database programmatically for client site. or i can copy the same database on client site using setup. or i need to install sql server at client's end.

Answer 1

You can copy the database to the client site. The client site will need to have SQL server installed.



SQL server 2005 Express Edition is available for free for a limitted time at msdn.microsoft.com/vstudio/express/sql



It needs to be registered though.



The express version is fully functional, but it has something like a 2GB or 4GB maximum database size. Once downloaded it is free to re-distribute.



It does not have some of the features of the full version that allow for all replication and scaling functionality, but it also can be downloaded with a vast set of extra tools.

Answer 2

Are you building a web app or desktop app?



If it is a web app no you do not you just need to make a connection to SQL Server more than likely through the web server



If a desk top app you really only need to copy the DB if you will be working with the data when your are not connected to the same network as the SQL Server



Now if you are talking about editing a Dataset that is a different story. .Net will take care of transferring to and from SQL server once you make the correct connections and SQL statements.

Answer 3

ur problem sounds familiar. i m doing a project on java with same aim. see if u r building a client side system that communicates with db residing on the server then

1. create db using front end tools in SQL server or with SQL commands.

2. link ur client system with the db.

u said u wanted to programmatically create db. it is possible thru embedded SQL. in java it is easy. no idea for vb.

Answer 4

this is a complicated question to respond to. I truly have by no ability encountered a situation in programming to create a database utilising code. So I wont be the final individual to respond to this question. in spite of the undeniable fact that from the layout and shape attitude it isnt a sturdy theory to realize this. you are able to create tables regulate tables yet no longer attempt and regulate databases