|
Home > Archive > MS SQL Server > October 2006 > Need help getting this .sql file into my SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need help getting this .sql file into my SQL Server
|
|
|
| I was working originally with what turned out to be a very unreliable
Offshore IT firm in India. I had to finally sever our working
relationship with them. They were about 70% complete even though they
demanded 100% payment upfront. WON'T EVER DO THAT AGAIN!
My problem is they site me all the site files and a data base .sql
file. I 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 database (the .sql file) into the
MS SQL 2000 Server. Basically my website is totally dysfunctional until
I restore the MS SQL server 2000 database. Please help as I am pulling
out my hair!
Thanks in advance for you input/advice,
MattD.
| |
| Tibor Karaszi 2006-10-24, 6:33 pm |
| You can use Query Analyzer, File Open to script files and login to the local SQL Server instance.
But beyond that, we can't say much. We don't even know if the script files includes the creation of
the database for you...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"MattD" <matt.downer@techniglobal.com> wrote in message
news:1159601738.868571.255320@i42g2000cwa.googlegroups.com...
>I was working originally with what turned out to be a very unreliable
> Offshore IT firm in India. I had to finally sever our working
> relationship with them. They were about 70% complete even though they
> demanded 100% payment upfront. WON'T EVER DO THAT AGAIN!
>
> My problem is they site me all the site files and a data base .sql
> file. I 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 database (the .sql file) into the
> MS SQL 2000 Server. Basically my website is totally dysfunctional until
> I restore the MS SQL server 2000 database. Please help as I am pulling
> out my hair!
>
> Thanks in advance for you input/advice,
> MattD.
>
|
|
|
|
|