Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Copying SQL database

Thread Tools
 
Search this Thread
 
Old May 22, 2003 | 12:11 PM
  #1  
rik1471's Avatar
rik1471
Thread Starter
Scooby Regular
 
Joined: Nov 2001
Posts: 4,788
Likes: 0
Post

How do I copy the structure only of an SQL database?
Reply
Old May 22, 2003 | 12:13 PM
  #2  
Alec's Avatar
Alec
Scooby Regular
 
Joined: Aug 1999
Posts: 583
Likes: 0
Post

SQL server?
Reply
Old May 22, 2003 | 12:21 PM
  #3  
GaryK's Avatar
GaryK
Scooby Regular
 
Joined: Sep 1999
Posts: 4,037
Likes: 0
From: Bedfordshire
Post

rik,

right click on one of the tables and select all tasks->generate sql script, then select all objects (and check the last tab if you want triggers and indexes scripted) and voila a script you can open in QA to create your schema.

Gary
Reply
Old May 22, 2003 | 12:22 PM
  #4  
HHxx's Avatar
HHxx
Scooby Regular
 
Joined: Nov 2001
Posts: 2,576
Likes: 0
Post

Oracle?
MySQL?
Ingres?
Reply
Old May 22, 2003 | 12:42 PM
  #5  
rik1471's Avatar
rik1471
Thread Starter
Scooby Regular
 
Joined: Nov 2001
Posts: 4,788
Likes: 0
Post

It's MS SQL Server, I'll try the instructions given - thanx.
Reply
Old May 22, 2003 | 04:21 PM
  #6  
rik1471's Avatar
rik1471
Thread Starter
Scooby Regular
 
Joined: Nov 2001
Posts: 4,788
Likes: 0
Post

Cheers GaryK,
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
JonMc
Subaru Parts
22
Feb 6, 2016 09:50 PM
Iqy7861
Insurance
5
Oct 1, 2015 07:57 PM
IAN WR1
ScoobyNet General
8
Sep 28, 2015 08:14 PM
Littleted
Computer & Technology Related
0
Sep 25, 2015 08:44 AM
RonaldoH
ScoobyNet General
2
Dec 21, 2000 09:20 PM




All times are GMT +1. The time now is 01:45 PM.