database on a local network

Question

I have never before put a database on a local network

I want to put a database on a local network
Between a number of devices what full steps
- devices Windows 7, but some 32 and the other 64

Answer 1

what do you mean by put db on a local nw? DO you mean create db on sqlserver instance which is on a domain?

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

Answer 2

I want to put the database for 3 devices
The process of addition, deletion or modification of any 3 devices
Computers on a local network .

without hosting

Answer 3

I want to put the database for 3 devices
The process of addition, deletion or modification of any 3 devices
Computers on a local network .

without hosting

sorry still didnt understand

you wont put db for any device as such

db will be standalone and devices may access it through apps for data storing/retrieving

so on the whole the question doesnt make any sense to be honest

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

Answer 4

Sorry for the first time I do this thing regarding the database
I am talking about the transition from access to sql Server

I may not use the scientific method to ask the question
But what I need to do is connect to the database between the devices by the ip for each device

Answer 5

Are you mean to put database on shared location?

Answer 6

I am talking about the transition from access to sql Server

To migrate Access to SQL Server, you use the SQL Server Migration Assistant for Access. The following links show how you can achieve that.

https://docs.microsoft.com/en-us/sql/ssma/access/sql-server-migration-assistant-for-access-accesstosql?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/ssma/access/getting-started-with-sql-server-migration-assistant-for-access-accesstosql?view=sql-server-2017

Here is another way with steps on how to do that.

https://www.online-tech-tips.com/ms-office-tips/ms-access-to-sql-database/

---

Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

Answer 7

Sorry for the first time I do this thing regarding the database
I am talking about the transition from access to sql Server

I may not use the scientific method to ask the question
But what I need to do is connect to the database between the devices by the ip for each device

ok

Now somewhat making sense

I think what you need to do is to install sqlserver in a machine and create you db in it

All other machines will be connected to sqlserver machine and will be part of a domain

Then you will be able to access sqlserver from any of the machines in the domain by specifying local IP address or the machine name on the domain.

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

Answer 8

SQL Server is not a file you put on a filesystem like Access databases and share with many people.  SQL Server is a service you install on a server and applications/users connect to the server to access the database.  They are quite different.

Answer 9

Hi ahmeddc,

According to your description, you have three devices and want to use the SQL Server.

In this scenario, you can set one device as the server which hosts the SQL Server, the other two devices together with itself as the client, then these clients can connect to this SQL Server instance with IP.

On these three servers, we can use the driver or some tool like SQL Server Management Studio (SSMS) as the client to connect to the SQL Server.

After configuration, we can use SQL Server Migration Assistant for Access as mentioned by Mohsin_A_Khan to migrate data from Access to SQL Server.

Actually, SQL Server works differently from Access, Access is a file-based dataset while SQL Server is a server-based database. There is another edition called SQL Server Compact Edition, it is also file-based.

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].