Re: How do you create a databse?
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 01/27/05
- Next message: Wayne Snyder: "Re: Remote synchronization"
- Previous message: Siobhan Perricone: "MSDE, Laptop, Enterprise Manager where to start"
- In reply to: Do Park via SQLMonster.com: "How do you create a databse?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 Jan 2005 08:40:13 -0500
See inline...
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Do Park via SQLMonster.com" <forum@SQLMonster.com> wrote in message news:3049694078734840ade4cd0e06a02414@SQLMonster.com... > Hello all, > > I usually use Enterprise Manager to create databases. Maybe I did not trust a script. > I think that it may be time to use a script to create databases. > > I?d like to hear your opinions. > 1. Do you use Enterprise Manage or a script when you create a database? Almost always.. > 2. What are cons and pros? The only con is if you use SEM you will not have a script.... but you can generate one from SEM.... so there is essentially no difference... (You can schedule a script to run also.) > 3. Would you please show me sample scripts that I can use? Take a look at the scripts in your SQL install directory Instpubs and instnwind. These are the install scripts which MS wrote to setup the pubs and northwind databases. > 4. Which one do you use a script or Enterprise Manager? SEM... I have taught SQL for years, and early on I always had people write scripts.... DB creation was more complicated, and the GUIs were unreliable. Now days, I use the GUI almost exclusivly, no reason not to... I guess the only exception is that if I am already in Query Analyzer, I just type in the script... the smallest script to create a test database is simply create database test.... Very simply. > 5. Which one do you recommend? > 6. Which tool do you use OSQL or Query Analyzer when you run a script? QA for interactive, and either OSQL or schedule something using SQL Agent... hope this helps... and good luck... > > Thanks in advance, > Do. > > -- > Message posted via http://www.sqlmonster.com
- Next message: Wayne Snyder: "Re: Remote synchronization"
- Previous message: Siobhan Perricone: "MSDE, Laptop, Enterprise Manager where to start"
- In reply to: Do Park via SQLMonster.com: "How do you create a databse?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
