How to use import/export utility in Sql Server 2000

Hi,

I've a data back up of sql server 2000 database in .bak form. I want to import data from this .bak file using the import/export utility. But there is no .bak option available in datasource select button of import/export utility. Then, what is the way to import data from .bak file?

you can not use import/export wizard in this scenario. You should restore database. Use Restore Command. Read about Restore with Move option in BOL(books online)

copied from BOL :

RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'

Madhu

|||I have marked Madhu's response as it stands, further do not attempt to open this .bak file as it is a database backup file and only by using RESTORE statement you would be able to restore on the other SQL server to extract the data using import/export wizard.|||

Hi

Madhu's suggestion worked well. I am able to restore.

How to use deployment utility using a single package configuration file

Hi,

We are trying to create a deployment utility for a solution. The issue we are facing is, we are using a single package configuration file and when we try to build the solution to create the deployment utility, the build process fails saying that the package configuration file already exists. THe reason for this is while trying to build, the utility copies the configation fiel for the packages, it copies for one, but for the second onward, when it tries to copies, it fails saying the file already exists.

Any idea how to overcome this, or else any suggestions how to perform the similar steps to create a deployment utility for a solution in which the packages share a single package configuration file.

Any suggestion would be really appreciated.

Thanks in Advance,

Manish Singh

This is a recognised problem with the deployment wizard and will, I'm sure, be fixed at some point.

In the meantime, you may want to look at alternative methods such as XCopy. Another alternative may be the WiX toolset, I have had a lot of success with that.

-Jamie

|||Thanks for the post Jamie , but could you let me know how XCopy or WIX Toolset works

Thanks in Advance
Shailesh|||

XCopy basically means using the command-line tool xcopy.exe to manually copy the files.

Using WiX is far more involved and is a much igger subject than can be answered in a single post I'm afraid.

-Jamie

|||Thanks again Jamie , but i found a better option to use the shared configuration file . U can actually create an environment variable and set the path of the Configuration file . Which you could indirectly reference in each and every package .

There is another workaround , where you can manually create the manifest file . This approach allows you to call one configuration file in another :: havent checked this part though .

Thanks for your response
keep up the good work

Regards
Shailesh|||

Shailesh Chaudhary wrote:

Thanks again Jamie , but i found a better option to use the shared configuration file . U can actually create an environment variable and set the path of the Configuration file . Which you could indirectly reference in each and every package .

Shailesh

This is called an Indirect Configuration. I am a big fan.

Indirect configurations ROCK!
http://blogs.conchango.com/jamiethomson/archive/2005/11/02/SSIS_3A00_-Indirect-configurations-ROCK_2100_.aspx

-Jamie

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
--
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.
BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>
|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

How to use Aggregation Utility

Hi all,

I have install the SP2 for AS2005, but I don't know how to start Aggregation Utility.

Thanks,

Do you mean the new aggregation manager utility? It's part of the samples for SQL2005 and is available as a separate download here:

http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Even better you could download the excellent BIDS Helper, which among other useful stuff integrates it with Visual Studio:

http://www.codeplex.com/bidshelper

HTH,

Chris