Yikes - you dont give a lot of information, so, to start with ..
Quote:
I need to migrate database to new database
why - what makes this necessary
Quote:
with new schema
is this the actual reason ?
a) how many tables in the current schema/database
b) how much data ? how many objects etc
c) are the databases going to run under the same version of MSSQL
d) are the databases going to run on the same machine/server ?
e) what is the use of the current database - realtime data ?
f) do you have an 'outage' window to migrate the data ?
g) do you trust your backups
h) how many client programs/systems need to change to use the new database
i) what is the age profile of the data - do you have old data sitting there that doesnt need to migrate because its old for example
j) what audit & security requirements do you have
k) how many tables/much data needs to change to conform to the new schema
There are probably a billion more questions, all around what, why, how much, when - requirements ie even before you get to 'process'