i'm in the process of migrating two sites from shared servers to a decidated Win 2008 R2 which has SQL Express on it
the problem is that replication isn't available and i don't have access on the (current) shared server which will allow me to do a backup/restore to the new one. it's not a huge amount of data - 20-30 megs at the most
i have one db which was backed up a few days ago which needs to be synched with the current one, so we can take it offline, and another which i need to import completely
what would be the best way of going about a) synching the db that's been backed up and b) importing the second db completely?