I developed our wordpress site on a subdomain, so I did not disrupt our homepage while I got everything up and running with Wordpress (It was originally running under Orchard, and I needed tochange it).
After the WP site was ready I changed the Wordpress Address general setting to the correct URL, and copied all the files over.
Unfortunately, it seems like this is not all that really needs to be done. Today (quite randomly, since it worked before oddly), images for a part of my site weren't showing up. Long story short it was because all of my WordPress media are pointing to the URL for them on the subdomain, NOT the core domain the site was currently running on.
After doing more research in the database, I can see other references to the subdomain still in the database, such as the
posts.guid field in the database for all posts on the site.
What do I have to do to correctly move everything over to my core domain, so when I nuke the subdomain it doesn't affect the main site? I would prefer not having to completely recreate content (like re-upload images) if possible.