Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rbs100
Starting Member
4 Posts |
 Posted - 2008-11-17 : 02:29:51
|
| Hi,I am new to SQL Server.1. I have a table which is of xml datatype and stores xml data.Using SQL Server SSIS, If I try to copy the database to another database, the xml data is not getting copied or it is copied as string data. How to resolve this issue?2. I want to know take a backup of the SQL Server DB and import into seperate location through a cd?Can anyone answer my question?Thank you,RBS |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 02:46:42
|
| How were you trying to copy db? |
 |
|
|
rbs100
Starting Member
4 Posts |
Posted - 2008-11-17 : 04:30:11
|
| Is there a command or method which is equilant to export command in Oracle? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 05:07:46
|
quote:
Originally posted by rbs100
Is there a command or method which is equilant to export command in Oracle?
you mean for exporting xml to sql table? try OPENROWSET(BULk..)or BULK INSERThttp://msdn.microsoft.com/en-us/library/ms191184.aspx |
|
|
|
rbs100
Starting Member
4 Posts |
Posted - 2008-11-17 : 05:15:01
|
| But is there any utility similar to exp command of Oracle? I want to export multiple tables. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 05:18:48
|
quote:
Originally posted by rbs100
But is there any utility similar to exp command of Oracle? I want to export multiple tables.
export multiple tables? then why dont you use export import wizard?http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm |
|
|
|
rbs100
Starting Member
4 Posts |
Posted - 2008-11-17 : 06:18:52
|
| I tried using export/import wizard. But it is not creating any output file. It is exporting the data and trying to import directly. I want to export it and carry it in a cd to my client place and import it. How to do it? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 09:54:01
|
quote:
Originally posted by rbs100
I tried using export/import wizard. But it is not creating any output file. It is exporting the data and trying to import directly. I want to export it and carry it in a cd to my client place and import it. How to do it?
what do you mean by export and create cd? then i think best way will be to take backup of your db and then take it in cd to client place and restore. |
|
|
|
|
|
|
Export and Import