Forums

Hello,

I've read some documentation on how to access my database from the outside (https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere/), but I would like to know if it is possible to create a Linked Server from Microsoft SQL Server Management Studio to read my tables.

I've googled a lot and can't find the right answer (or maybe I have, but don't know how to implement it)

Thanks in advance.

I may be misunderstanding what I've read, but it looks to me like a linked server has to be running Microsoft SQL Server, so you wouldn't be able to link a MySQL server like the one hosted on PythonAnywhere.

Thank you for your answer.

I have another question regarding databases.

According to this help page https://help.pythonanywhere.com/pages/MSSQLServer/ I can connect to an external database (Microsoft SQL Server) or more than one. Is it possible to connect to that external database AND use the one pythonanywhere provides (MySQL)?

I know they are two different things, but can I create a route on flask to test the other database without deleting or damaging the database I already have?

You'd need a paid account to connect to an external database, but if you had one of those you could certainly write code to connect to multiple databases from the same script. If you're using Flask-SQLAlchemy, this page might be useful documentation on how you might go about doing that.

Thank you Giles!

No problem!