I need to move a database that is about 1GB from a shared server where I have limited access to a dedicated server where I will have complete control. First, is SQL Packager the right tool for this job? Is there a better solution (either from red gate or elsewhere)?
And second, when I do the move, can anyone give any kind of approximate estimate of how long the copy and install will actually take for a 1 GB database? I am assuming that during the transfer the databases will be completely unavailable to user. Correct?
Thanks for any comments you can provide.