Web deploy is the best way to go since you are migrating from IIS6 to IIS7.? Below is a link to the instructions on how to do this.? Before beginning, you should also backup the following configuration files on?the Windows 2008?server, administration.config and applicationHost.config.? The default location for these files are in C:\Windows\System32\inetsrv\config.? If you run into issues during the process and need to get the?Windows 2008?server back to its original state, just restore the backup copies of these files.
http://www.iis.net/learn/publish/using-web-deploy/migrate-a-web-site-from-iis-60-to-iis-7-or-above
?
Web deploy creates a package containing your sites configuration and data that you can import on the destination server.? The data will be restored in the same folder?location as on the?Window 2003 server.
If it's easier for you to run the scripts to create and sync your db's, then that's fine.? You can also do the following.
1.? Create the databases on the Windows 2008 Server and the SQL users
2.? Take a full backup of the db's on the Windows 2003 Sever
3.? Restore the backups over the db's on the Windows 2008 Server
4.? Run the orphaned user command on each db for your SQL users: http://msdn.microsoft.com/en-us/library/ms175475.aspx
?
Below is instructions on restoring a db to another server.
http://www.techrepublic.com/blog/window-on-windows/how-do-i-restore-a-sql-server-database-to-a-new-server/454
?
I don't have any input on the VBA apps.
?
?
?
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.