SQL Server have export/import function?

[gbraden]

We have a couple of SQL Server 2000s. Is there an easy way to port a test application onto a production server? I have an Oracle background, and this could be done in Oracle using the export and import utilities, but SQL Server does not seem to have the same functionality.

Just point me to what documentation, via enterprise manager or website that I need to read.

Thanks




Visit me at

http://www.aviationartist.com

 

[manmaria]

Right click on the database,select Tasks,select import data, then DB wizard will open then next,then select the source etc., etc. Rest is self explanatory when you open the wizard.

HTH

 

[Catadmin]

Are you trying to port over an application or port over data? SQL Server can't port over an application, but it can be used to port over data.

Follow manmaria's instructions for pulling in simple data. Also, you could create an SSIS (Integration Services) package if you have to do complicated transformation tricks.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[gbraden]

okay. I am thinking that I didn't give enough information. I have 'ported' over tables and data, but it appends new data to the table. I want to port over data (and table structure) and overlay the old.

Oracle has spoiled me. Ultimately I need to delete the old tables, and import the new. I could do that with the Oracle export/import parameter file. Here, when I end up deleting the tables and reimporting, so I was looking for a 'cleaner' way.

Our application is a asp.net front end, served by IIS and with sql server 2000 as our database backend. I


Glen Braden

 

[Catadmin]

All you have to do is truncate the tables (TRUNCATE TABLE <tablename>), turn on IDENTITY_INSERT and then import the data afresh.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"