Restoring a .sql file to a 2000 Server

25 Sep 2006 1:59 AM

Matt D.

I was working originally with what turned out to be a very unreliable
offshore IT firm in India. I had to finally severe our working relationship
with them. The were about 70% complete even though that demanded 100%
payment upfront. My problem is they site me all the site files and a data
base .sql file. I have am in no way a DBA, my background is systems
engineer. I have a local installation of SQL Server 2000 along with out Web
host SQL 2000 Server. I am clueless how to get the data base (the .sql file)
into the MS SQL 2000 Server. Sorry if I seem out of it, I am home with a
severe cold/flu.

Thanks in advance for you input/advice,
matt

28 Sep 2006 6:54 AM

Dejan Sarka

Matt,

>I was working originally with what turned out to be a very unreliable
>offshore IT firm in India. I had to finally severe our working relationship
>with them. The were about 70% complete even though that demanded 100%
>payment upfront. My problem is they site me all the site files and a data
>base .sql file. I have am in no way a DBA, my background is systems
>engineer. I have a local installation of SQL Server 2000 along with out Web
>host SQL 2000 Server. I am clueless how to get the data base (the .sql
>file) into the MS SQL 2000 Server. Sorry if I seem out of it, I am home
>with a severe cold/flu.

The .sql files are usually T-SQL scripts, i.e. text files with Transact-SQL
commands. Try to open it in Query Analyzer (a tool shipped with SQL 2000)
and execute the commands.

--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message