From SQL Express to XML file

HI guys,

Is there any tool to import the database from SQLExpress to change it into XML without doing much programming code in .Net?

Thanks!

Chin

Hi Chin,

The short answer is no, SQL Express doesn't include any import/export tools. That said, Transact-SQL provides syntax that lets you represent your data as XML, and you could use that to produce XML and then save that to a file.

Check out my answer to a similar question at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368472&SiteID=1 for links to pertinent BOL topics.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

From SQL Express to XML file

HI guys,

Is there any tool to import the database from SQLExpress to change it into XML without doing much programming code in .Net?

Thanks!

Chin

Hi Chin,

The short answer is no, SQL Express doesn't include any import/export tools. That said, Transact-SQL provides syntax that lets you represent your data as XML, and you could use that to produce XML and then save that to a file.

Check out my answer to a similar question at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368472&SiteID=1 for links to pertinent BOL topics.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

sql

from sql 2005 to sqlexpress 2005

Is there any way to export/import/copy a database from sql 2005 to sql
express2005?
Thanks.Detach/attach and backup/restore are two options.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alex D." <alexware69@.hotmail.com> wrote in message news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.g
bl...
> Is there any way to export/import/copy a database from sql 2005 to sql
> express2005?
> Thanks.
>|||thanks I'll try dettach/attach cause restore is not working
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Detach/attach and backup/restore are two options.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Alex D." <alexware69@.hotmail.com> wrote in message
> news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...|||"Is not working" isn't a very good problem description. Restore should work,
and if you show us some
details (the RESTORE command, error message etc), we can probably help you o
ut with that. But attach
is a good option as well. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alex D." <alexware69@.hotmail.com> wrote in message news:uouca9rbGHA.3352@.TK2MSFTNGP03.phx.g
bl...
> thanks I'll try dettach/attach cause restore is not working
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>|||The most likely cause of a failure here would be that the database is over
4GB so it can't run in Express. If that's the case, attach won't work
either.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ewa1khsbGHA.3504@.TK2MSFTNGP04.phx.gbl...
> "Is not working" isn't a very good problem description. Restore should
> work, and if you show us some details (the RESTORE command, error message
> etc), we can probably help you out with that. But attach is a good option
> as well. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Alex D." <alexware69@.hotmail.com> wrote in message
> news:uouca9rbGHA.3352@.TK2MSFTNGP03.phx.gbl...
>|||Good catch, Roger. Didn't think about that... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uvu%23qvsbGHA.1320@.TK2MSFTNGP04.phx.gbl...
> The most likely cause of a failure here would be that the database is over
4GB so it can't run in
> Express. If that's the case, attach won't work either.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>|||database is not over 4gb. the error message I am getting when trying to
restore is a permissions message. It seems that my new database dont have
permissions to restore the backup. I am using sql authentication and the sa
in both databases have the same password.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uvu%23qvsbGHA.1320@.TK2MSFTNGP04.phx.gbl...
> The most likely cause of a failure here would be that the database is over
> 4GB so it can't run in Express. If that's the case, attach won't work
> either.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:ewa1khsbGHA.3504@.TK2MSFTNGP04.phx.gbl...
>

from sql 2005 to sqlexpress 2005

Is there any way to export/import/copy a database from sql 2005 to sql
express2005?
Thanks.Detach/attach and backup/restore are two options.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alex D." <alexware69@.hotmail.com> wrote in message news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
> Is there any way to export/import/copy a database from sql 2005 to sql
> express2005?
> Thanks.
>|||thanks I'll try dettach/attach cause restore is not working
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
> Detach/attach and backup/restore are two options.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Alex D." <alexware69@.hotmail.com> wrote in message
> news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to export/import/copy a database from sql 2005 to sql
>> express2005?
>> Thanks.|||"Is not working" isn't a very good problem description. Restore should work, and if you show us some
details (the RESTORE command, error message etc), we can probably help you out with that. But attach
is a good option as well. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alex D." <alexware69@.hotmail.com> wrote in message news:uouca9rbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> thanks I'll try dettach/attach cause restore is not working
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>> Detach/attach and backup/restore are two options.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Alex D." <alexware69@.hotmail.com> wrote in message news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to export/import/copy a database from sql 2005 to sql express2005?
>> Thanks.
>|||The most likely cause of a failure here would be that the database is over
4GB so it can't run in Express. If that's the case, attach won't work
either.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ewa1khsbGHA.3504@.TK2MSFTNGP04.phx.gbl...
> "Is not working" isn't a very good problem description. Restore should
> work, and if you show us some details (the RESTORE command, error message
> etc), we can probably help you out with that. But attach is a good option
> as well. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Alex D." <alexware69@.hotmail.com> wrote in message
> news:uouca9rbGHA.3352@.TK2MSFTNGP03.phx.gbl...
>> thanks I'll try dettach/attach cause restore is not working
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>> Detach/attach and backup/restore are two options.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Alex D." <alexware69@.hotmail.com> wrote in message
>> news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to export/import/copy a database from sql 2005 to sql
>> express2005?
>> Thanks.
>>
>|||Good catch, Roger. Didn't think about that... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uvu%23qvsbGHA.1320@.TK2MSFTNGP04.phx.gbl...
> The most likely cause of a failure here would be that the database is over 4GB so it can't run in
> Express. If that's the case, attach won't work either.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>|||database is not over 4gb. the error message I am getting when trying to
restore is a permissions message. It seems that my new database dont have
permissions to restore the backup. I am using sql authentication and the sa
in both databases have the same password.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uvu%23qvsbGHA.1320@.TK2MSFTNGP04.phx.gbl...
> The most likely cause of a failure here would be that the database is over
> 4GB so it can't run in Express. If that's the case, attach won't work
> either.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:ewa1khsbGHA.3504@.TK2MSFTNGP04.phx.gbl...
>> "Is not working" isn't a very good problem description. Restore should
>> work, and if you show us some details (the RESTORE command, error message
>> etc), we can probably help you out with that. But attach is a good option
>> as well. :-)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Alex D." <alexware69@.hotmail.com> wrote in message
>> news:uouca9rbGHA.3352@.TK2MSFTNGP03.phx.gbl...
>> thanks I'll try dettach/attach cause restore is not working
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>> Detach/attach and backup/restore are two options.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Alex D." <alexware69@.hotmail.com> wrote in message
>> news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to export/import/copy a database from sql 2005 to sql
>> express2005?
>> Thanks.
>>
>