June 4, 2009 at 3:16 am
Hello,
This is my first time on this forum and with SQL Server. I was given the task of deploying an application which uses SQL SERVER as database engine. A dump of the initial database was given along with a serial of scripts that have to be applied on the database.
The objective is to import that dump file in the database, but I don't know how to that with SQL Server.
The main issues that I have are:
- How to install the database engine (SQL Server 2000/2005).
- How to create the schema user the dump file will be imported on.
- How to perform the import.
Can anyone help me or provide me with links to documentation related to the problems I described?
Thanks in advance.
The typical DBA life is like that of an airline pilot,
“Long moments of boredom followed by small moments of sheer terror”,and one place for sheer terror is an error during a database startup.:cool:
June 4, 2009 at 3:22 am
What do you mean by dump ??
support.microsoft.com/kb/303747 : Install SQL Server 2000
technet.microsoft.com/en-us/library/ms143516.aspx : Install SQL Server 2005
msdn.microsoft.com/en-us/library/ms189462.aspx : How to create schema ..
Looks like you are too much dependent on asking questions 🙂 ..try searching and digging yourself ...
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
June 4, 2009 at 1:24 pm
"dump file" is pre-SQL2000 usually meaning backup file. Install SQL from your media, get to sp4 on SQL2000 or sp3 for SQL2005 from the Microsoft website, as long as the application is certified on that platform and install that as well. Open BOL and read up on restore database. It should be fairly straightfoward. Post back if have any issues. If so, please post what you attempted to do, in detail, and any error messages you may have received.
-- You can't be late until you show up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply