Synchronize SQL data-base?

[AntonS]

Hi everyone,

 

not sure where I should ask, so I just post here. Sorry if it's wrong place.

 

I have a question:

I have a SQL data base and want to use it on 2 computers, on the pc at home and on the laptop at my parents. It's a Poker database, thats why.

 

Is there any possibility to use the same database on both PC's, other then just copy-pasting every single time and putting on an USB stick?

 

Thanks for help!

[bcguru9384]

1 minute ago, AntonS said:

Hi everyone,

 

not sure where I should ask, so I just post here. Sorry if it's wrong place.

 

I have a question:

I have a SQL data base and want to use it on 2 computers, on the pc at home and on the laptop at my parents. It's a Poker database, thats why.

 

Is there any possibility to use the same database on both PC's, other then just copy-pasting every single time and putting on an USB stick?

 

Thanks for help!

use onedrive then it will autosync 

[AncientNerd]

49 minutes ago, AntonS said:

Hi everyone,

 

not sure where I should ask, so I just post here. Sorry if it's wrong place.

 

I have a question:

I have a SQL data base and want to use it on 2 computers, on the pc at home and on the laptop at my parents. It's a Poker database, thats why.

 

Is there any possibility to use the same database on both PC's, other then just copy-pasting every single time and putting on an USB stick?

 

Thanks for help!

As long as the two machines are on the same network some of the time you can set up two way replication between the two databases. SQL 2012 or higher will sync the changes between the two databases when the machines are on the same network. They will be out of sync while they are not on the same network.

 

48 minutes ago, bcguru9384 said:

use onedrive then it will autosync 

This would maybe work although it presumes that you have enough onedrive storage for your database or you pay for additional one-drive storage.

 

If you are paying for storage, consider moving the database to Azure a minimum SQL azure cloud based SQL server is under $5/month and comes with 2GB of storage. The Azure account comes with the any of the MS tools downloads so if you have been building a SQL-server database then you probably already have one and may have some per month money - my MSDN account came with $150/month worth of Azure credits to use.

[AntonS]

Thanks

[bowrilla]

For 5$ you get webspace with mysql databases … then you can access it from everywhere. You could also set up your home pc with dyndns and access your database at home. Just needs some portforwarding and firewall settings. Or get a raspberry pi and use that as your server with your database.

[vanished]

-topic moved-