Migrating data from say 2017 SQL Web edition to SQL Standard. Any limitations?
For one of our projects we were hoping to use the 2017 MS SQL web edition for pre-production(DEV, UAT, QA etc) and post-QA testing migrate the data, stored procedures/scripts to STD edition in production. Involves one big push initially and then with every release smaller data being pushed. Are there any limitations or compatibility issues we can run into?
Not knowing what your workload is or what features your application needs, theres no way to guide you one way or another. Best way forward is to review the differences in features/scale between Web and other editions at - https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017 , determine if those limits may work in theory for your scenario and proceed with actual testing.