CODEWITHSUNDEEP
javamysqlsql-serverspring
Kunal
Kunal

Reputation: 327

Java Web Application connect to MYSQL and SQL SERVER

I have a SpringMvc Web App running perfectly on a tomcat server alongside MySql. What i need to do is that i need to store some data to another database on a SQL Server in another hosting.

So i am wondering if a spring mvc project has the capability to have simultaneously an MySql connection and SQL Server connection. If not what could you advice me since i need to copy the contents of the mysql to sql every once in a while (say for instance in an interval of 2h).

Thanks

Upvotes: 0

Views: 872

Answers (1)

ninja.coder
ninja.coder

Reputation: 9648

You can create two different DataSources with respective Drivers and Connection Credentials. It should work fine.

Upvotes: 1

Related Questions