December 1, 2003 at 4:12 pm
I am an experienced ASP developer. I have come across a project where I have access to a live SQL Server hosting a database for an ASP/Database driven website.
I need to download a copy of one of the databases from the server and set it up in a local SQL Server 2000 /IIS ASP development environment.
I am running windows 2000 Pro, can anyone tell what SQL Server software I need to install and how I go about doing this.
Thanks for your time, any help will be greatly appreciated.
Gelboe
December 1, 2003 at 6:38 pm
If you are going to host the SQL Server database, then you need some version of SQL Server suitable. If you have MSDN Universal you have rights to all the versions, but something like SQL Server developer would work. The SQL Server CAL is cheap and permits a desktop version that might (or might not) be adequate, but is where I'd start if I didn't have MSDN Universal.
December 1, 2003 at 9:45 pm
some bad news for you here sqlserver stardard or enterprise won't install on windows 2000 Pro!
you would have to use the developer edition just $50
HTH
* Noel
December 2, 2003 at 5:56 am
thanks for this info.
would developer edition allow me to connect to a remote SQL Server 2000 Enterprise and copy a database file to be downloaded an run locally?
is it also true that the SQL Server 2000 Eval Ed. will run on a Windows 2000 Pro machine and allow me to do the same things?
really appreciate your time.
cheers
gleboe
December 2, 2003 at 9:18 am
Better to run the same edition as your living SQL server
December 2, 2003 at 3:04 pm
Depending on the types of things you are doing in the database you should be able to use the Dev edition on your local machine. I've been doing that for a long time on my XP machine with no problems. Just make sure you use the same collation on both machines.
The best way to create your local database would be to grab a SQL backup of the database from your server and then restore it on your local machine. Then make sure you set up all the users the same as on the server.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 3, 2003 at 3:21 am
thanks everyone, this is all really helpful stuff.
regards
gelboe
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply