[AccessD] Re: Create scripts: CreateTable?

Robert L. Stewart rl_stewart at highstream.net
Tue Mar 2 12:12:37 CST 2004


Steve,

I believe he was asking about a way of doing it in Access,
like the way SQL Server can do it.

Robert

At 10:59 AM 3/2/2004 -0600, you wrote:
>Date: Tue, 2 Mar 2004 10:40:58 -0500
>From: "Developer" <Developer at UltraDNT.com>
>Subject: RE: [AccessD] Create scripts: CreateTable?
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID: <000501c4006c$c5294260$7001a8c0 at COA3>
>Content-Type: text/plain;       charset="US-ASCII"
>
>There is absolutely something like it, in MS-SQL 7.0 or 2000 (it's
>likely in 6.5 too, I just don't remember).  In Enterprise Manager
>(2000), you right click on the development database, then "All Tasks",
>"Generate SQL Script...".  Select any objects you want scripted
>(including sp's, views, etc.) and EM will generate a text file you can
>run in Query Analyzer on the production server.  I use this all the time
>to develop one server and deploy on another.  If you are quicker at
>Access tables, you may want to do your tables there, use the SQL upsize
>wizard, then generate the script (watch for data-type conversion quirks,
>however, going from Access to SQL with the wizard).  Books Online will
>give all the details for script generation.
>
>Hth
>Steve





More information about the AccessD mailing list