Last post Aug 25, 2005 06:41 PM by lilryno
Aug 21, 2005 11:16 AM|lilryno|LINK
I have a DNN 2.1.2 site and pay for hosting. I've been using DNN 2.1.2 on my local machine with Windows XP Pro for development utilizing the Access database on my local machine. I have Visual Studio Enterprise Architect for custom module development.
I'm not a very good programmer but I've been able to make custom modules that work for my site although they all use independent Access databases. I'd like to move away from this practice and use the SQL database like real module developers do.
I would like to upgrade my local development machine to DNN 3.1.1 and then eventually my website on my rented shared server.
I have no real experience with SQL Server and I'm trying to figure out how to create the SQL database on my local Windows XP Pro machine so that I can upgrade my development DNN site to 3.1.1
I have SQL Server 2000 Developer Edition since it came with Visual Studio. But I'm wondering if I can install this on an XP Pro machine and what features I should install to do DNN development work. I would like to learn how to get into the
SQL server, create tables, create scripts to convert forums to another forum, and to fix module problems that go bad and to make custom modules that use the DNN SQL database. But I'm not sure what features I will need for the SQL Server 2000 install to get
The install of SQL Server 2000 says the Developer Edition runs on "Microsoft Windows NT Workstation 4.0, Windows 2000 Professional, and all other Windows NT and Windows 2000 operating systems." It doesn't mention XP Pro. Is it possible there has been a service
pack for XP Pro that allows Server 2000 to run?
But I've seen elsewhere documentation that "SQL Server 2000 Developer Edition run on the operating systems listed above for the Enterprise and Standard Editions as well as on Windows XP Professional, Windows XP Home
Edition, Windows 2000 Professional and Windows NT Workstation 4.0 with SP5 or later. "
Can anyone give me some advice on how to install SQL Server 2000 Developer Edition on my Win XP Pro local machine so that I can install DNN 3.1.1 and get into the nitty gritty with SQL for the purposes of creating
custom modules? I'd like to start doing things right and it seems SQL is a definite requirement. Thanks for any help!
Aug 21, 2005 01:08 PM|thecrispy1|LINK
Aug 21, 2005 02:14 PM|lilryno|LINK
Thanks! Just wanted to make sure.
I bought Visual Studio .NET Enterprise Architect and it came with a whole box of server CDs. Advanced Server, Server 2003, SQL Server 2000 Dev Ed, Exchange Server, Commerce Server and a bunch of other stuff way over my head. Hopefully they are full versions.
I guess we'll see.
I'm thinking I will wipe the computer clean, install XP Pro, get all the SPs and updates, then install Visual Studio .NET again, then put my DNN 2.1.2 site back on there and finally....install SQL Server 2000 Developer Edition and try to configure everything.
I just want all this stuff to play nice and I have a feeling I'm going to run into problems.
Thanks again for the info.
Aug 25, 2005 06:28 PM|Powers|LINK
Aug 25, 2005 06:41 PM|lilryno|LINK