Can I use a SQL Server database in my RAILS 4 project on ubuntu?

3

I want to develop a website in RAILS 4 but I must necessarily use an existing database of SQL Server, is it possible to use it in ubuntu or do I have to program in Windows?

    
asked by LuisC 19.06.2016 в 07:54
source

2 answers

1

SQL Server can not install it on ubuntu, anyway if you have an existing SQL Server database already running on some server, you can do your development on RAILS and connect to this SQL Server database, or you can set up a separate environment with OS Windows and SQL Server installed for your development environment. And your website in RAILS would continue to develop on your machine with Ubuntu.

    
answered by 19.06.2016 в 11:36
1

Currently your options are:

  • There is a version of sql server for linux, but it is still in development. If you want to access a preview of this version you have to sign up at link but I do not assure you that it is stable at all, nor that it is compatible with the sql server drivers for Ruby.
  • Running sql server on a dedicated machine (OJO, here I refer to an instance of DEVELOPMENT, not an instance with real data) and that your rails application connects to it. For me this is the best option, however you need extra equipment to run the application.
  • virtualize a windows machine on your ubuntu with virtualbox and then install SQL server. this option is the cheapest, however it will encourage your development team considerably since you will have 2 operating systems running.
  • develop the rails application in windows. This is the simplest option, however a sea of incompatibilities awaits you as you integrate new gems to your project that are not compatible with windows.
answered by 19.06.2016 в 17:38