Last post Jul 07, 2018 12:30 PM by JohnsonWelch
Feb 04, 2018 05:40 PM|KulerMaster|LINK
We have upgraded our application having a brand new database with totally new design.
The old database is containing customers data that we need to migrate to the new database.
They are different in every aspect.
My question is how do i plan the migration properly? Is there a checklist template that you can recommend me?
Feb 05, 2018 07:24 AM|Deepak Panchal|LINK
In general scenario, You can refer below check list that may help you.
SQL Server Database Migration Checklist
How to move databases between computers that are running SQL Server
How to migrate a SQL Server database to a newer version of SQL Server
but you had mentioned that, both database are totally different.
So in that case, I suggest you understand both database very well and Try to migrate single table at a time by checking proper data types, column names etc.
Jul 07, 2018 12:30 PM|JohnsonWelch|LINK
You can migrate your data from one database to another by Export/Import Wizard, by using Generate Script etc. Transfer data from one database to another by going through the following thread: