SQL Server problem!

Question

Post reply

SQL Server problem!

nicholas-250056

SSC Journeyman

Points: 87
More actions
August 3, 2005 at 12:34 am

#165540

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jason Hall Hall of Fame Points: 3906 More actions · Answer 1

The best method for this is to take a backup of your development database and restore the backup file into production.

SQLBill SSC Guru Points: 51440 More actions · Answer 2

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

-SQLBill

nicholas-250056 SSC Journeyman Points: 87 More actions · Answer 3

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 SSC-Dedicated Points: 35293 More actions · Answer 4

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 Default port Points: 1492 More actions · Answer 5

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 SSC-Dedicated Points: 35293 More actions · Answer 6

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 Default port Points: 1492 More actions · Answer 7

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.