I know this an old post, but just going throw the comments and trying to get an answer here. I found that Microsoft does not say anything about using percentage...

I appreciate your input, thanks for your time.

Michael -

Many thanks to you, I appreciate it... I got it.

Yes, both ways worked... Once again, thank you all for your input..

Sean -

Many many thanks to you, it worked.

That is exactly how I do all my database migrations 🙂

All user permissions gets copied over when you backup/restore. I have migrated many databases, and found that best way to backup/restore and run the microsfot script to copy all users....

It works with 2008 as well, I used it.

When you backup databases from source and restore them in the destination server, all logins are restored with the databases. After that run the microsoft script to transfer logins,

Sorry for the late reply... It is not recommended to just attach/detach storage. I ended up building the clustered server, and then doing bkup/rstr from the standalone. I ran into...

sweetmoulali -

Dynamic tcp/ip port has nothing to do with clustered envirnment.. During SQL installation, dynamic tcp is set as default if you go with named instance, it is static if...

John -

Thank you for your input. Both named instance ports are to dynamic, and got an application which has tcp port 1433 hadcoded to migrate. I will follow your...

Thank you for the link, I already know how to configure... beside in a clustered environment you do not change based on the link you sent... If you need to...

Lowell -

I did setup cdc and it is working the way I needed, I used http://www.mssqltips.com/sqlservertip/1819/using-change-tracking-in-sql-server-2008/ as a base to get started. Once again, thank you.

Lava

Lowell -

After doing more research, I think I will go with your recommendation to enable CDC and write a store procedure to get the information users need...

Many thanks to you.

Lava