Anyone Using MySQL on Windows Hosting?

by 6 replies
7
Hey Warriors,
I needed your suggestions. I am planning to build a site in asp.net.
I am not comfortable with MsSQL as the backend database platform. Instead I am installing an plugin for Windows Visual Studio Ultimate which enables MySQL connections.

So I am wondering if this would turn out to be a problem when I deploy it on the server ?


If I had Windows Hosting, I would have tested it. Unfortunately I am currently on Linux Hosting.

Thanks
~SD
#programming #hosting #mysql #windows
  • Yes I am using mysql on windows hosting and i dont face any problem as I have get hosting from local server and their support is helping me with it
    • [1] reply
    • Thanks for replying.. But I dint get you exactly what you meant by this
  • MySQL has a windows installation. Many windows hosts include it in their standard package.

    All you need to do is make sure you have the server name, username and password set up in your MySQL for .NET connector.

    It is a proven connector, so you shouldn't have to test it. Just plug ang play.

    Make sure you make the project reference to the MySQL connector to keep a local copy. That way when you deploy the site, it will keep a copy in the bin folder and everything will work.
    • [1] reply
    • Thanks for the information. I have already installed MsSQL 2008 on my local server. But I have the database in MySQL. There are about 103 tables in the database & about 70k+ entries. I find it difficult to move this database from MySQL to MsSQL.

      That's the reason I was preferring to use MySQL for this project.
      • [1] reply
  • I've worked for years with ASP.NET, PHP and both MYSQL and MSSQL... why are you not comfortable with MsSQL. I would highly recommend you sticking with MSSQL if you are going down the ASP.NET route. If you are doing PHP then definitely MYSQL.
    If it's a learning curve then take the time to learn it...it's worth it for the long run. MsSQL Express is free and can be downloaded from here:
    Free Database Software | Database Applications | SQL Server Express
  • Banned
    [DELETED]
  • Banned
    [DELETED]
Join the discussion

Next Topics on Trending Feed

  • 7

    Anyone Using MySQL on Windows Hosting?

    Hey Warriors, I needed your suggestions. I am planning to build a site in asp.net. I am not comfortable with MsSQL as the backend database platform. Instead I am installing an plugin for Windows Visual Studio Ultimate which enables MySQL connections.