SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server problem!


SQL Server problem!

Author
Message
nicholas-250056
nicholas-250056
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 1
Good day, my name is nicholas, a newbie of SQL Server 2000, currently, got a question to ask, please kindly help!

Currently, i already created 87 tables in SQL Server 2000 Developer Edition (in my PC), then, can i know is there any method to "copy & paste" all these 87 tables or "copy & paste" the whole database to the SQL Server 2000 Standard Edition (in a server)?

i already try the "Generate SQL Script", but since like i am in the wrong steps already~! Thus, please kindly help me, teach me or show me some instructions, MANY THANKS!

best regards,
Nicholas
Jason Hall
Jason Hall
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2086 Visits: 82
The best method for this is to take a backup of your development database and restore the backup file into production.
SQLBill
SQLBill
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25192 Visits: 1087

another method is to detach the database, copy the .mdf and .ldf files to their new location and then attach them.

-SQLBill





nicholas-250056
nicholas-250056
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 1
are u means right click the database, select "All Task" -> then "Back up Database?

is it means that if i can find the .mdb & .ldf together, then wht u means of "ATTACH" them?

Thanks for ur help~!
sushila
sushila
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18503 Visits: 639
Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back to life either

at any rate - jason hall's method:

click on the wizard icon (the magic wand) on the tool bar of enterprise manager, go to "management" - "backup wizard" - it'll walk you through all the steps - copy the backup file which will be saved with a .bak extension in your backup folder - save it in a folder in your target server - create a brand new database in the target server - - and right click - select "all tasks" - "restore database" - "from device" - "select devices" - "add" - navigate to saved .bak file and open - say "ok"

sqlbill's is to right click - select "all tasks" - detach database - go to the data folder which will have saved your data and log files with an .mdf and .ldf extension - copy these files - and then "attach" them in the target server. However, if you're new to all this - my suggestion would be to do it Jason's way - it's easier to follow!

A third way - if you have only created the tables but not populated it with any data - is to right click on one of the tables - select "all tasks" - "generate sql script" - "show all" - and under the options tab - select either "create one file" or "create one file per object" - then you can copy this/these file/s and run the script in the query analyzer (after having created a new database in the target server).

Use BOL (books on line) for help and guidance regardless of the method you choose. Everything seems difficult when it is new but with practice you'll be surpised how easy and effortless it all becomes. Good luck!







**ASCII stupid question, get a stupid ANSI !!!**
CJohnson-232084
CJohnson-232084
SSC Eights!
SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)

Group: General Forum Members
Points: 880 Visits: 3

THANK YOU SUSHILA!!!

>>Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back to life either <<

I have had this happen several times and have yet to figure out why. I've taken to saving my reply in Notepad before clicking "Post Reply" or "Preview." This is an irritation, but not as bad as losing several minutes of work (and carefully crafted brilliance ).


sushila
sushila
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18503 Visits: 639
I keep meaning to do this (type response in Notepad) but suffer from memory lapses everytime!

I'm not sure why I'm being thanked - is it because I confirmed for you the fact that you needn't have been rubbing your eyes out off your head everytime your (carefully crafted brilliance) turns out to be apparitional ?!?!?!







**ASCII stupid question, get a stupid ANSI !!!**
CJohnson-232084
CJohnson-232084
SSC Eights!
SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)

Group: General Forum Members
Points: 880 Visits: 3

I thank you for confirming the event. I thought I was just experiencing premature 'old timers' disease and losing my way around the form. This is an inconsistent, irritating, recurring problem. I would love to take the time to figure out what is going on, but as we all know, time is in short supply in our field these days. Hence the long diatribe and the continued popularity of this forum!

I love your refreshing use of 'apparitional.' Proficiency in and appreciation of grammar, syntax, and non-technical vocabulary is somewhat rare in IT.

Happy days.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search