Can Import Wizard Move MS Access Triggers? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Can Import Wizard Move MS Access Triggers?

This is the first time I have used the Import/Export Wizard. I need to migrate a small number of MS Access tables to SQL 2000. Can the Import Wizard migrate Triggers and Defaults? So far I have only managed to migrate tables? Second question. When choosing a data source if I select Drive do Microsoft Access (*.mdb) I have the ability to select the mdb file and a corresponding mdw (security). However if I select Microsoft Access I do not have the ability to specify an mdw and therefore cannot connect to the source Access db. What is the difference between the two data sources? Thanks, Dave
Accodint to my knowledge, you will not be able to transfer defaults. DTS allows you to transfer only DATA. thsi is my beleive. I might be wrong here
Other alternative is to script the access triggers and modify accordingly to use in SQL server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Access doesn’t have triggers. Access tables can have defaults, validation rules, indexes, cascading relationships – that’s it basically. If you need something like triggers, you use a bound form to catch the various events, and there is no way that there can ever be an upsizing tool that translates VBA code behind a form to T-SQL triggers …
Thanks all. We decided to use the Access upsize utility instead of DTS. The strange thing with the utility is that some NULL columns became NOT NULL in SQL Server and some NOT NULL became NULL. We also had column names > 30 characters in Access that were truncated by the utility. Default names > 28 characters were also truncated. Fortunately we only moved a small number of tables and defaults. In regards to triggers I’m only going by what our developer told me. I’ve never personally worked with Access. He said that the upsizing utility will translate various relationships to triggers. Not exactly sure what he meant by that. Dave
The following links will give you more information on upsizing the access to SQL.
http://www.sqlservercentral.com/columnists/dasanka/upsizingtheaccessdatabaseintothesqlserver.asp
http://www.granite.ab.ca/access/sqlserverupsizing.htm Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>