Connecting to SQL

[Poults]

Morning all, hope everyone is doing well.

 

We have a legacy piece of software that runs on SQL2008 and I need to be able to access it in case HMRC needs us too in case of an audit. It contains old customer accounts and data and is purely legacy. What would you use to connect to it in a user friendly form for reference?

 

Thanks.

[Bedders]

I'd use SSMS (SQL Server Management Suite) but I don't know if the latest version should be used to connect to an SQL 2008 database (it will most probably work, but may have unintended side effects).

 

https://www.itsupportguides.com/knowledge-base/sql-server/how-to-install-sql-management-studio-2008-r2/ does this help?

[Poults]

So this will let me view the information within the database?

[CAWJames]

We use the latest version of SSMS to connect through all our SQL servers, the oldest being 2008R2(I know, I know)

[bknaggs]

Any reason why you can’t just use the legacy software itself?

[Poults]

Any reason why you can’t just use the legacy software itself?

 

It requires a key each year to keep functionality, Iv inherited it with a new job and we are looking at cost cutting as its very expensive.

[Bedders]

So this will let me view the information within the database?

 

Yes. It will let you connect to the SQL database from a workstation, and manage the database.

It is the same software that might be installed on the server and used on the database host to manage it, similar to using RSAT to manage Windows servers.

 

Screenshots from one of our example databases, SSMS V18 connecting to MSSQL Server 2019:

 

[Poults]

Yes. It will let you connect to the SQL database from a workstation, and manage the database.

It is the same software that might be installed on the server and used on the database host to manage it, similar to using RSAT to manage Windows servers.

 

Screenshots from one of our example databases, SSMS V18 connecting to MSSQL Server 2019:

 

]

 

Thanks for your help, I will give that a go and see what i can do.

[bknaggs]

It requires a key each year to keep functionality, Iv inherited it with a new job and we are looking at cost cutting as its very expensive.

 

Can you export the information out of the software to make it accessible in a better way or has your license already expired?

[Poults]

Can you export the information out of the software to make it accessible in a better way or has your license already expired?

 

The manager password I have is wrong, support aren't being very helpful, probably as the license runs out tomorrow but from what I have seen I don't think you can anyway. I think their may have been some bad feeling towards my company when they switched provider - very unprofessional but it is what it is.