title: SqlAlchemy Python multiple databases
body: <p>I'm using SqlAlchemy to access multiple databases (on the same server). My current connection string is the following</p>
  
  <pre><code>connect_string = "mssql+pyodbc://{0}:{1}@{2}/{3}".format(USERNAME_R, PASSWORD_R, SERVER_R, DATABASE_R)
  engine = create_engine(connect_string)
  session = sessionmaker(bind=engine)()
  Record = declarative_base(engine)
  </code></pre>
  
  <p>How do I modify this declaration to be able to connect to multiple databases on the same server (e.g. <code>DATABASE1</code> &amp; <code>DATABASE2</code>). It seems like this is pointing in the right direction, but it's not very clear and I'm not sure if it is specific to Flask:</p>
  
  <p><a href="https://pythonhosted.org/Flask-SQLAlchemy/binds.html" rel="noreferrer">https://pythonhosted.org/Flask-SQLAlchemy/binds.html</a></p>