How can I see the contents of a database in the browser?

1

I have a database that was created with a version of SQL Server old and I'm trying to open it in a new version. I get a message that says:

  

"The database can not be opened because it is version 852. This server   supports version 782 and earlier. A downgrade path is not supported. "

They recommended that I open the database in the browser and copy everything to the new version, but I do not know how to do it. If you have a better solution, let me know.

    
asked by user20100 21.11.2016 в 00:18
source

3 answers

0

Because of what the error message says, what you are trying to do is open a SQL Server 2016 database in a SQL Server 2014 engine .

As the new structure is very different between the two versions, what you could do (as long as you have access to the original database) is create the database scripts of structure (Tables, Views, stored procedures, etc.) and its content (the data) using SQL Server Managment Studio (Right click on the database> Tasks> Generate Scripts).

With those scripts you would create the complete database in SQL Server 2014.

    
answered by 21.11.2016 / 05:25
source
0

You can use a web administration utility for the database. You can try: link

    
answered by 21.11.2016 в 00:32
0

Try to open it with a multiplatform database tool, you only need the credentials of logeo and now, I recommend this: link In the link you download the corresponding version to your operating system, install it and later connect with your credentials of the SQL instance.

    
answered by 21.11.2016 в 01:37