Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kantalope
Starting Member
3 Posts |
 Posted - 2002-07-18 : 11:57:39
|
| I have a SQL 2000 database at work and I need to take that home to work on. Problem is - at home I have SQL 7.Is there an easy way to recreate that data on my home machine? I cannot log onto the network at work. I cannot afford to upgrade to 2000 at home. I do have access to ftp for file movin. The databse is not that big. (6MB or something like that)Or am I stuck with manually recreating the tables and exporting a bunch of text files to bulk insert?thanks in advanceEdited by - kantalope on 07/18/2002 11:59:30Edited by - kantalope on 07/18/2002 12:11:22 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-18 : 12:01:10
|
| Yeah, unfortunately since you're going from 2000 to 7.0 you can't backup and restore, you'll have to export to text files. The indexes are easy to create, just Generate Scripts on your database and include all objects, and run the script files on your home server before you import the data.You can Generate Scripts in Enterprise Manager; right click the database and choose the option from the menu (it might be under All Tasks). |
 |
|
|
kantalope
Starting Member
3 Posts |
Posted - 2002-07-18 : 12:14:22
|
dang that was fast  could not even fix my double postin troubles before the answer.thanks a ton - I shall begin converting back to text (sigh) |
|
|
|
|
|
|
How to I get this home