I run a small website with access and coldfusion. I now want to learn how to administer a SQL Server 2005 database. I have created a local site which uses SQL Server 2005. I have all my .sql files to create, drop and populate my tables. Where's the best place to start learning how to start working with sql files on a site ( as opposed to on my local computer ) Thanks in advance
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Early Guidance
- Thread starter ice789911
- Start date
- Thread starter
- #2
Well it seems that the answer for me lies in the Microsoft SQL Server Database Publishing Wizard which will create a sql file for me and then I can execute it on my server. If I later wanted to alter the data in one of my core tables is it standard practice to write another sql file and execute it ( ie an INSERT statement) or is it standard practice to create an interface in say Coldfusion and amend the table that way
- Status