7 replies to this topic

[asafe]

I have questions:
If I develop a app that uses Sql Server, what files I'm suppossed to give to user? Does user need to have Sql Server installed?
And if I use Mysql?

[dbug]

I don't understand the question... obviously if your application uses a database the user will need access to a database with the requisites imposed by your application.

[asafe]

What I want to know is:
If I use Acess I give the .mdb to the client. If I use SQL Server or Mysql what I give him?

[dbug]

Well, if your program uses SQL Server or MySQL, your client must have SQL Server or MySQL installed in some server. And probably you should give them a SQL script to create all the tables and stuff needed for your program into the database.

Once this is done, you (or your client) can install your program in the user workstations.

[asafe]

Well, I mean if SQL Server or Mysql have database files like Acess has .mdb.

[dbug]

These servers use files to store the databases, but these files cannot be copied to other servers. You need to transfer data using SQL scripts or some sort of backup and restore.

[asafe]

I see. I can use mysqldump or backup task in SQL Server.

[Alexander]

Is this for an offline app? If you can export your SQL database into a csv or mdb format, you can use a native API to access them in that format. They only need SQL server or MySQL if you export it as an SQL dump.