S D
accessd667 at yahoo.com
Wed Mar 3 07:13:40 CST 2004
thnx for the replies. History: I work for company A and I'm stationed at Customer B. I'm hired by Customer B to develop stuff. Customer B has also hired company C to implement/migrate changes. Company C has a rule that they ONLY use scripts to implement/migrate changes that can be run by 'ZERO-KNOWLEDGE-USERS'!! That is why I need a piece of code to generate CreateTable scripts. I need this piece of code in Access 2000. if anybody neesd any more info don't hesitate to ask. Regards, Sander Developer <Developer at ultradnt.com> wrote: Robert: I thought that at first, but if that was the case, why not just send the client the empty .mdb? Communication is key ... Lol Steve -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart Sent: Tuesday, March 02, 2004 1:13 PM To: accessd at databaseadvisors.com Subject: [AccessD] Re: Create scripts: CreateTable? 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" >Subject: RE: [AccessD] Create scripts: CreateTable? >To: "'Access Developers discussion and problem solving'" > >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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster.