Access to SQL Server migration
I have an Access database (which runs in 100s of MBs) on the server and I want to move all its data to a SQL Server database. So, I'm restricted to do it entirely on the server.
"One way is to retrieve the list of tables from the access database and copy each table to the SQL Server database."
"Remember, I have to do it entirely on the server. Access and SQL Server migration tools are not an option"
I agree, DTS is what you need. Very easy to use. But do check the field types after exporting as Access and SQL Server have different field types.
You really need to explain more about what your constraints are? What tools can you use on the server? is this a one off migration or something you do regularly?
Fog Creek Home