Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
Does Platform 5.1 still work with SQL 2000?
Community
›
Forums
›
Technology & Integration
Does Platform 5.1 still work with SQL 2000?
New Post
New Post
Richard Chang
Posted on 2010-12-01
Richard Chang
Rank: #5372
Posted on 2010-12-01
Does Platform 5.1 work with SQL 2000?
Miguel João
Posted on 2010-12-15
Miguel João
Rank: #73
Posted on 2010-12-15
Solution
Hello Richard.
The Agile Platform 5.1 no longer supports SQL Server 2000 as the main database nor through database connections.
Currently it only support SQL Server 2005 and SQL Server 2008 version of the Microsoft RDBMS.
You can find the system requirements on the document
Agile Platform 5.1 - Systems Requirements
Were you considering using it as a main database, or just to integrate with?
Cheers
Miguel João
Solution
Nuno Reis
mvp_badge
mvp_label
Posted on 2012-01-04
Nuno Reis
mvp_badge
mvp_label
Rank: #92
Posted on 2012-01-04
Solution
Related question:
I have a set of legacy applications (made in .net with shared SQL 2000 databases) that I want to migrate to outsystems (5 or 6, it also depends and the schedule to upgrade outsystems).
We can't duplicate data because it is shared and other apps will need it updated.
I planned to do it phased, migrating each application individually and upgrading the sql at the end.
If outsystems can't work with MS SQL 2000 want would you suggest? Will a database mirroring to 2008 be enough or must I migrate all at once?
Solution
Miguel João
Posted on 2012-01-25
Miguel João
Rank: #73
Posted on 2012-01-25
Solution
Hi Nuno
It really depends on the data's and application requirements.
Up front I can say that you'll need a supported SQL Server (recommend SQL Server 2008 R2) to have your Agile Platform 6 up and running over that database.
Then, you should see the SQL Server 2000 as an integration, where the Agile Platform will not manage the data model, and the applications will just access it's data. Although not supported, you could try to read the data through a Database Connection configured on the Service Center, and use an extension to import the external data model representation. If it fails, then the other option is to code an extension to connect to the SQL Server 2000 and access the required data.
A common alternative is to have a DTS/Integration Services package that will copy and synchronize the data between different versions of the SQL Server (I don't think you can do it with mirroring), and have the Agile Platform to integrate with the copied version of the data model.
There's also teh possibility to use linked servers between the 2 SQL Servers, and import the data model representation on an extension, however, if you pretend to use the external datamodel to extensively perform queries and inner joins with local entities, this will significantly impact the performance, and we usually do not recommended it.
So it depends on the use case for the data access.
Cheers
Miguel Simões João
Solution
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...