Reply to thread

Message

I think you've done the right thing by moving this conversation to a different thread.

I have 35 years of database design experience and I finished my career as a database architect at Imperial College. I've been very lucky to get into SQL databases very early on and I have lots of inside knowledge that is a bit hidden now. I started developing for Windows in 1991, 2 months before Windows 3 came out .

The bulk of my work, in the last 10 years has been with SQL Server and SQLite using WPF, LINQ and Entity Framework. I also worked at Oracle houses where I gained my best knowledge about database design.

I understand the point about the original reasons for design decisions being lost as developers leave and I am happy to reconsider why we have certain features and whether they are still relevant.

The upgrade I am proposing is significant, but I believe we can manage it. There is no rush, because we need to get it right.

Testing will be key and, thank you, CyberSimian, for your offer to help. I have been implementing this change as an upgrade to the latest version: i.e. I install the latest release, in this case 1.29, and then copy files over that installation. I think this approach would be good to start before moving to a full release. The issue for me is that I tend not to use special settings and that is where people like CyberSimian will be of great help because he uses, or is familiar with, so many of the features I don't touch.

Can you tell me where I can deposit files for others to pick up? I'll try to make it easy to install by sending the files and a batch file to do the install - to keep it really simple. Alternatively, as you're in the UK, CyberSimian, I am happy to communicate by email to avoid cluttering up the forum should that work better - using the forum to get views from people generally.

Tony

<blockquote data-quote="Anthony Vaughan" data-source="post: 1286630" data-attributes="member: 153283">I think you've done the right thing by moving this conversation to a different thread.I have 35 years of database design experience and I finished my career as a database architect at Imperial College. I've been very lucky to get into SQL databases very early on and I have lots of inside knowledge that is a bit hidden now. I started developing for Windows in 1991, 2 months before Windows 3 came out <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /> .The bulk of my work, in the last 10 years has been with SQL Server and SQLite using WPF, LINQ and Entity Framework. I also worked at Oracle houses where I gained my best knowledge about database design.I understand the point about the original reasons for design decisions being lost as developers leave and I am happy to reconsider why we have certain features and whether they are still relevant.The upgrade I am proposing is significant, but I believe we can manage it. There is no rush, because we need to get it right.Testing will be key and, thank you, CyberSimian, for your offer to help. I have been implementing this change as an upgrade to the latest version: i.e. I install the latest release, in this case 1.29, and then copy files over that installation. I think this approach would be good to start before moving to a full release. The issue for me is that I tend not to use special settings and that is where people like CyberSimian will be of great help because he uses, or is familiar with, so many of the features I don't touch.Can you tell me where I can deposit files for others to pick up? I'll try to make it easy to install by sending the files and a batch file to do the install - to keep it really simple. Alternatively, as you're in the UK, CyberSimian, I am happy to communicate by email to avoid cluttering up the forum should that work better - using the forum to get views from people generally.Tony</blockquote>

[QUOTE="Anthony Vaughan, post: 1286630, member: 153283"] I think you've done the right thing by moving this conversation to a different thread. I have 35 years of database design experience and I finished my career as a database architect at Imperial College. I've been very lucky to get into SQL databases very early on and I have lots of inside knowledge that is a bit hidden now. I started developing for Windows in 1991, 2 months before Windows 3 came out :) . The bulk of my work, in the last 10 years has been with SQL Server and SQLite using WPF, LINQ and Entity Framework. I also worked at Oracle houses where I gained my best knowledge about database design. I understand the point about the original reasons for design decisions being lost as developers leave and I am happy to reconsider why we have certain features and whether they are still relevant. The upgrade I am proposing is significant, but I believe we can manage it. There is no rush, because we need to get it right. Testing will be key and, thank you, CyberSimian, for your offer to help. I have been implementing this change as an upgrade to the latest version: i.e. I install the latest release, in this case 1.29, and then copy files over that installation. I think this approach would be good to start before moving to a full release. The issue for me is that I tend not to use special settings and that is where people like CyberSimian will be of great help because he uses, or is familiar with, so many of the features I don't touch. Can you tell me where I can deposit files for others to pick up? I'll try to make it easy to install by sending the files and a batch file to do the install - to keep it really simple. Alternatively, as you're in the UK, CyberSimian, I am happy to communicate by email to avoid cluttering up the forum should that work better - using the forum to get views from people generally. Tony [/QUOTE]