I have a bit of a situation and I am new with this sort of operation. I have an MS SQL database that runs an application. This application was recently upgraded but I need to transfer the data over to the new database somehow.
Now I am using the import/export wizard for Studio Express but I have a couple of questions...
The database structure probably has changed a bit on the new MS SQL database. When I go to import, will it put the data into the correct fields? Even if there are new fields perhaps?
Is there anything I should be concerned with and watch for?