SQL Server with local db

(4 posts) (2 voices)
  1. cbrady, Member

    Is it possible to use SQL with the report definitions being saved into someother local database? It is not possible to add a new database to the SQL Server

  2. myDBR Team, Key Master

    By default, myDBR uses it's own database for storing all objects. myDBR does not make any changes to user database and only thing needed is a read access to the data.

    --
    myDBR Team

  3. cbrady, Member

    SQL Server technically hosts multiple "databases". So does the myDBR use SQL Server for it's own database or can it use SQL Server (for the user data) and MySQL (for the myDBR objects) at the same time?

    Since this is a fundamental requirement I didn't want to get started configuring everything only to find out that only one db engine could be used at a time.

    Thank you!

  4. myDBR Team, Key Master

    If you install myDBR on top of MS SQL Server, myDBR installation creates a SQL Server database where it stores all reporting objects.

    You can also install myDBR-objects directly to your user database, if you cannot create additional databases.

    When using SQL Server you can also mix different database vendor databases (MySQL, Oracle etc) using SQL Server's linked servers. The technical requirement is that routines stored in myDBR database must have read access to database where the actual data resides.

    --
    myDBR Team


Reply

You must log in to post.