Converting Desktop Engine to SQL Server 2005

I have got SQL Server Desktop Engine running with 2 database and I need

to install the evaluation version of SQL Server 2005 instead. A

straight upgrade does not seem to be possible. Does someone know if

backing up the databases, uninstalling the desktop engine, installing

SQL Server 2005 and then importing/restoring the databases would be an

option to look into?

Here is an article on Upgradeing MSDE to SQL 2005 Express, you could follow this example then it is an easy upgrade to the Full SQL 2005 Product.

sqlsql

Converting database from 32-bit SQL Server 2005 to 64-bit version of SQL Server 2005

I recently upgraded to SQL Server 2005. My databases are stable and functioning perfectly. However, these databases are using the 32-bit version of SQL Server. The servers are going to be upgraded to 64-bit processors and new Server 2003 64-bit OS's.

Everything I have been able to find says that it is a simple process of backing up the databases in the 32-bit environment and restoring them in the 64-bit environment.

Could it really be that easy? I am looking for someone who has done this to provide any "heads up" commentary on what to look out for during that process. Can anyone provide some information on this process?

Thanks.

i have migrated SQL Server 2000 32 bit database to SQL Server 20005 64 bit version using backup/restore method. This is the best method to migrate the database i would say. there is nothing special while you restore sql server 2005 32 bit backup in 64 bit server.

Madhu

|||

Yes it really is that simple. You can either do a backup and restore or a detach and attach. (With large databases and SAN storage the detach and attach is usually easer and you can just move the drives from one server to another.)

If the new server doesn't work out, moving back is just as simple. Backup and Restore or detach and attach.

converting an xml to html

Hi ,
I am a beginner. I AM trying to convert an xml fie into html :
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited with XML Spy v2007 (http://www.altova.com) -->
<CATALOG>
<CD>
<TITLE>Empire Burlesque</TITLE>
<ARTIST>Bob Dylan</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>Columbia</COMPANY>
<PRICE>10.90</PRICE>
<YEAR>1985</YEAR>
</CD>
<CD>
<TITLE>Hide your heart</TITLE>
<ARTIST>Bonnie Tyler</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>CBS Records</COMPANY>
<PRICE>9.90</PRICE>
<YEAR>1988</YEAR>
</CD>
</CATALOG>I thought i should first create a DTD for this .Is that
true?
Please help me get started.
-Shyam
Just create an XSLT stylesheet. Here are some examples.
http://www.topxml.com/xsltstylesheets/
"shyamali" <shyamalibala@.gmail.com> wrote in message
news:1172074617.679808.198740@.j27g2000cwj.googlegr oups.com...
> Hi ,
> I am a beginner. I AM trying to convert an xml fie into html :
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <!-- Edited with XML Spy v2007 (http://www.altova.com) -->
> <CATALOG>
> <CD>
> <TITLE>Empire Burlesque</TITLE>
> <ARTIST>Bob Dylan</ARTIST>
> <COUNTRY>USA</COUNTRY>
> <COMPANY>Columbia</COMPANY>
> <PRICE>10.90</PRICE>
> <YEAR>1985</YEAR>
> </CD>
> <CD>
> <TITLE>Hide your heart</TITLE>
> <ARTIST>Bonnie Tyler</ARTIST>
> <COUNTRY>UK</COUNTRY>
> <COMPANY>CBS Records</COMPANY>
> <PRICE>9.90</PRICE>
> <YEAR>1988</YEAR>
> </CD>
> </CATALOG>I thought i should first create a DTD for this .Is that
> true?
> Please help me get started.
> -Shyam
>
|||On Feb 21, 11:16 am, "shyamali" <shyamalib...@.gmail.com> wrote:
> Hi ,
> I am a beginner. I AM trying to convert an xml fie into html :
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <!-- Edited with XML Spy v2007 (http://www.altova.com) -->
> <CATALOG>
> <CD>
> <TITLE>Empire Burlesque</TITLE>
> <ARTIST>Bob Dylan</ARTIST>
> <COUNTRY>USA</COUNTRY>
> <COMPANY>Columbia</COMPANY>
> <PRICE>10.90</PRICE>
> <YEAR>1985</YEAR>
> </CD>
> <CD>
> <TITLE>Hide your heart</TITLE>
> <ARTIST>Bonnie Tyler</ARTIST>
> <COUNTRY>UK</COUNTRY>
> <COMPANY>CBS Records</COMPANY>
> <PRICE>9.90</PRICE>
> <YEAR>1988</YEAR>
> </CD>
> </CATALOG>I thought i should first create a DTD for this .Is that
> true?
> Please help me get started.
> -Shyam
And here are some XSLT Tools to design your stylesheet:
http://www.stylusstudio.com/xslt.html
Download free trial from: http://www.stylusstudio.com/xml_download.html
Sincerely,
The Stylus Studio Team
http://www.stylusstudio.com
sqlsql

converting an xml to html

Hi ,
I am a beginner. I AM trying to convert an xml fie into html :
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited with XML Spy v2007 (http://www.altova.com) -->
<CATALOG>
<CD>
<TITLE>Empire Burlesque</TITLE>
<ARTIST>Bob Dylan</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>Columbia</COMPANY>
<PRICE>10.90</PRICE>
<YEAR>1985</YEAR>
</CD>
<CD>
<TITLE>Hide your heart</TITLE>
<ARTIST>Bonnie Tyler</ARTIST>
<COUNTRY>UK</COUNTRY>
<COMPANY>CBS Records</COMPANY>
<PRICE>9.90</PRICE>
<YEAR>1988</YEAR>
</CD>
</CATALOG>I thought i should first create a DTD for this .Is that
true?
Please help me get started.
-ShyamJust create an XSLT stylesheet. Here are some examples.
http://www.topxml.com/xsltstylesheets/
"shyamali" <shyamalibala@.gmail.com> wrote in message
news:1172074617.679808.198740@.j27g2000cwj.googlegroups.com...
> Hi ,
> I am a beginner. I AM trying to convert an xml fie into html :
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <!-- Edited with XML Spy v2007 (http://www.altova.com) -->
> <CATALOG>
> <CD>
> <TITLE>Empire Burlesque</TITLE>
> <ARTIST>Bob Dylan</ARTIST>
> <COUNTRY>USA</COUNTRY>
> <COMPANY>Columbia</COMPANY>
> <PRICE>10.90</PRICE>
> <YEAR>1985</YEAR>
> </CD>
> <CD>
> <TITLE>Hide your heart</TITLE>
> <ARTIST>Bonnie Tyler</ARTIST>
> <COUNTRY>UK</COUNTRY>
> <COMPANY>CBS Records</COMPANY>
> <PRICE>9.90</PRICE>
> <YEAR>1988</YEAR>
> </CD>
> </CATALOG>I thought i should first create a DTD for this .Is that
> true?
> Please help me get started.
> -Shyam
>|||On Feb 21, 11:16 am, "shyamali" <shyamalib...@.gmail.com> wrote:
> Hi ,
> I am a beginner. I AM trying to convert an xml fie into html :
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <!-- Edited with XML Spy v2007 (http://www.altova.com) -->
> <CATALOG>
> <CD>
> <TITLE>Empire Burlesque</TITLE>
> <ARTIST>Bob Dylan</ARTIST>
> <COUNTRY>USA</COUNTRY>
> <COMPANY>Columbia</COMPANY>
> <PRICE>10.90</PRICE>
> <YEAR>1985</YEAR>
> </CD>
> <CD>
> <TITLE>Hide your heart</TITLE>
> <ARTIST>Bonnie Tyler</ARTIST>
> <COUNTRY>UK</COUNTRY>
> <COMPANY>CBS Records</COMPANY>
> <PRICE>9.90</PRICE>
> <YEAR>1988</YEAR>
> </CD>
> </CATALOG>I thought i should first create a DTD for this .Is that
> true?
> Please help me get started.
> -Shyam
And here are some XSLT Tools to design your stylesheet:
http://www.stylusstudio.com/xslt.html
Download free trial from: http://www.stylusstudio.com/xml_download.html
Sincerely,
The Stylus Studio Team
http://www.stylusstudio.com

convert SQL Server DB to Access DB

Hi,
IS it possible to take a SQLServer DB and convert it into an access
version? If so, can you easily convert stored procedures in access
queries? Or is all this not possible?Using SSIS in SQL Server 2005 and using DTS in SQL Server 2000, you can
easily export your SQL Server tables and views into a Microsoft Access
database.
To do this, go to your database in SQL Server and right click on it.
Tasks\Export Data. Choose your source from SQL Server and choose your target
as Microsoft Access from the list and go on...
--
Ekrem Önsoy
"bcap" <rayh@.patriots.com> wrote in message
news:1190648932.092871.210280@.19g2000hsx.googlegroups.com...
> Hi,
> IS it possible to take a SQLServer DB and convert it into an access
> version? If so, can you easily convert stored procedures in access
> queries? Or is all this not possible?
>|||Hi
This is not the way most people go! Is SQL Express not an option? AFAIK
there is not a way to convert a stored procedure to an Access query. Your
stored procedure may contain code and logic that is not possible to do in an
Access query, so unless they are very simple single statements being run in
the query you will need to write the logic into the client application. You
can import/export the tables and data into Access quite easily.
John
"bcap" wrote:
> Hi,
> IS it possible to take a SQLServer DB and convert it into an access
> version? If so, can you easily convert stored procedures in access
> queries? Or is all this not possible?
>

Convert numeric data to text possible?

I have a need to covert a number (like 180) to the text version (one hundred
eighty). Is this possible is RS? If so, how?
Thanks!
LeighYou can create custom function using the VB.NET syntax.
Check this page for some examples:
http://msdn.microsoft.com/SQL/sqlwarehouse/ReportingServices/default.aspx?pull=/library/en-us/dnsql2k/html/erscstcode.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Leigh" <Leigh@.discussions.microsoft.com> wrote in message
news:938DE0DF-A3CD-45CB-857B-6CDA722121C8@.microsoft.com...
>I have a need to covert a number (like 180) to the text version (one
>hundred
> eighty). Is this possible is RS? If so, how?
> Thanks!
> Leigh