SQL server to Access transformation

[pankajdaga]

Hi,

I did not know how to convert an SQL server database to Access. Paladine had suggested using a DTS and probably is the easiest way to do it. However, I have a few questions regarding this:

- The first one is that I cannot seem to import the identities and Primary keys in the Access tables. Is there any way to do this. The allow Identity insert check mark is disabled.

- Second, I would like to be able to run this DTS package through ASP.NET and basically have the access file that is generated available for download. Any ideas on how to do that?

Thanks a lot,

Sincerely,
Pankaj

 

[nigelrivett]

You can run a package via dtsrun - a command line utility or using the object model
Here's how to use the object model from t-sql - easy to convert.

http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.