Search:
Search questions and share your knowledge with the world here on Questionpoint.

Interview Question in Data Transformation Services (DTS)

I am new to SQL server. Is there any one can tell me how to transfer the Tables, Forms, Querys, reports and Macros to SQL? (Using DTS ?)

Answers to "How to transfer MS Access into SQL server"

RE: How to transfer MS Access into SQL server?
Search the Access help file for "Upsizing Wizard".
Vote for this answer ::

RE: How to transfer MS Access into SQL server?
You could use SSIS (built into sql server 2005) or DTS (sql server 2000) (also known as integration services) You could use a Linked server (inside of sql you can create a link to your ms access database) then do an INSERT INTO [sqlserver.table] FROM [msaccess.table] command to copy your tables from access to SQL directly. http://www.databasejournal.com/features/... OR You could use the Access upsizing wizard: http://support.microsoft.com/default.asp... i think those are the best 3 options.
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Search questions and share your knowledge with the world here on Questionpoint.