Copying SQL database
#3
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
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
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
Thread
Thread Starter
Forum
Replies
Last Post
JonMc
Subaru Parts
22
06 February 2016 09:50 PM
RonaldoH
ScoobyNet General
2
21 December 2000 09:20 PM