I want to know the recommended method to move a database and data from dev to pre-prod to production in SQL Server. The databases are originally created in MS Access so some upsizing to SQL Server will be needed
The 3 options I've read about: (I'm sure there are others)
- Use Detach and Attach - I've been led to believe this doesn't give a clean build and may cause issues but is easy to do as just moving/copying the .mdf, .ldf files
- Script the database and objects into each environment - this provides a clean build but is more time consuming
- Do a back-up/ restore - takes longer but appears to be a favored method.
Any advice most welcome.