How to creat a mdb file in Sql Server2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hi,

I am creating a website on ASP.NET and I want to use the database file. So that on which ever system I work for that project I should easily access the databasew without creating it again and again.

Is it possible that I can have a db file through which I can access my whole database having the tables which are required in the project?

Posted 13-Jun-12 22:28pm

Dexter Arora

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AmitKumar89 · Answer 1 · 2012-06-13T22:46:00

Hi,
Your question is not so clear.
Do we need to create database again and again? If you are in network just set the database connection string. And if you are not in a network then copy the mdf and database log file from that system to current location and set the path..

All the best.
--AK

**Zoltán Zörgő** · Answer 2 · 2012-06-13T22:47:00

I don't really see, what your problem could be.

If your "which ever" systems are in an intranet, you just have to have the sql server published via tcp/ip. This is default for commercial editions. If you have express edition you need to enable tcp/ip binding. You just have to use the proper connection string. If your Visual Studio Express edition has no Server explorer, only Database Explorer, you will not be able to access the server from within Visual Studio, but your application will be able to work correctly.

By the way, you don't need to recreate the database structure. Make a backup form a clean version, and you can restore on different servers, if you need.

Joshi, Rushikesh · Answer 3 · 2012-06-13T22:57:00

Let we take it differently, why you can't use a central SQL Server database?

If geo location/connectivity is an issue, then you can use create an MDB file and copy it on all system from where you are working but I am not in favor of this because -
- You will not keep data synch between all system.
- MDB files only supports OleDB connections so you will not able to consume SQLClient.

For one time activity, if you already have database in SQLServer then you can make use of SQLServer Export wizard to convert Database into MSAccess (MDB) file.

Let's come-up with detailed question and your concerns.

Thank You
Rushikesh Joshi

Dexter Arora · Answer 4 · 2012-06-13T23:06:00

Solution 4

Zoltán Zörgő5 :
The systems are not in intranet. They are on different networks.When I copy my project on other system, then I have to recreate the database and the tables which I guess is not fissible. I want a mdb file along with the project so that I can use the tables in any system whether on same network or on different. Its just for my own convinience

Posted 13-Jun-12 23:06pm

Dexter Arora

Comments

Zoltán Zörgő 14-Jun-12 5:46am

Don't post comments as answer, since they are not answers!
Ok, I got your point. But first of all, you really use MDB (Access) files with SQL Server, not MDF files? As I said you don't have to recreate, the database. Just create once, fill up with all the data, that should be present on start. Than make a backup of it. Make a batch file that restores it to a new database on the local system (the one you are currently setting up). But you will need the SQL server to be present. If you dont need a full-blown SQL server, you can use SQL Server Compact Edition. You can deploy it easily with your application.
Read this comparison

How to creat a mdb file in Sql Server2005

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0