![]() |
![]() |
![]() |
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.
Green Pajamas
"One way is to retrieve the list of tables from the access database and copy each table to the SQL Server database."
Green Pajamas
"Remember, I have to do it entirely on the server. Access and SQL Server migration tools are not an option"
DJ
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.
Espen Antonsen
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?
Harvey Pengwyn
|