Anyway to automatical generate script to populated DB from Access
- From: "jerryk" <jerryk@xxxxxxxxxxxxxx>
- Date: Fri, 25 Aug 2006 16:09:57 -0700
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
.
- Follow-Ups:
- Re: Anyway to automatical generate script to populated DB from Access
- From: Arnie Rowland
- Re: Anyway to automatical generate script to populated DB from Access
- Prev by Date: Customizing maintenance plan reporting in SQL2005
- Next by Date: Re: Anyway to automatical generate script to populated DB from Access
- Previous by thread: Customizing maintenance plan reporting in SQL2005
- Next by thread: Re: Anyway to automatical generate script to populated DB from Access
- Index(es):
Relevant Pages
|
