Anyway to automatical generate script to populated DB from Access

25 Aug 2006 11:09 PM

jerryk

Hi,

I am in the process of migrating an Access DB to SQL Server. We need to do
this several times as part of the testing / deployment cycle. Right now we
are manually running the Access upsizing Wizard, then running a script to
add in the Views, Stored Procedures, etc. It would be nice if we could
figure out how to generate a script that would delete the data in the SQL
DB, Remove any constraints/relationships, upload the data from Access, and
add the constraints/relationships back in. Is it possible to generate such
as script or series of scripts?

jerry

25 Aug 2006 11:26 PM

Arnie Rowland

If you are using SQL 2000, look at the Import Wizard. If using SQL 2005,
examine SSIS.

Both will allow you to save all of the steps into a script ('Package'), and
then you can re-run the package whenever you wish.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"jerryk" <jer***@insteptech.com> wrote in message
news:e$rFWuJyGHA.2572@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> I am in the process of migrating an Access DB to SQL Server. We need to
> do this several times as part of the testing / deployment cycle. Right now
> we are manually running the Access upsizing Wizard, then running a script
> to add in the Views, Stored Procedures, etc. It would be nice if we could
> figure out how to generate a script that would delete the data in the SQL
> DB, Remove any constraints/relationships, upload the data from Access, and
> add the constraints/relationships back in. Is it possible to generate
> such as script or series of scripts?
>
> jerry
>
>
>
>