Converting Data from SqlServer Express to SqlServer 2005 beta 2??

Hi,
Was wondering if anyone could tell me how to convert the an SQL Server
Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a day
or so now and can't seem to find how to do this!!!
Any ideas?
Many Thanks
Wayne Gibson
Hi
Detach the DB in Express and attach it in SQL Server 2005. Or Backup and
Restore.
The backup and data files have 100% the same format.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9gca4$t42$1$8300dec7@.news.demon.co.uk...
> Hi,
> Was wondering if anyone could tell me how to convert the an SQL Server
> Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a
> day or so now and can't seem to find how to do this!!!
> Any ideas?
> Many Thanks
> Wayne Gibson
>
|||You should find you can just attach it with sp_attach_db. Did you try
that?
Please ask SQL Server 2005 questions in the appropriate newsgroups:
http://communities.microsoft.com/new...=sqlserver2005
David Portas
SQL Server MVP
|||Hi Mike,
Thanks for responding..
Could you tell me how I go about making a backup of a MS SQLServer Express
file.
I got MS SQLServer Express as part of the Visual Studio 2005 Beta 2, but
can't see any tools apart from those in the IDE.
Thanks
Wayne

Converting Data from SqlServer Express to SqlServer 2005 beta 2??

Hi,
Was wondering if anyone could tell me how to convert the an SQL Server
Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a day
or so now and can't seem to find how to do this!!!
Any ideas?
Many Thanks
Wayne Gibson
Hi
Detach the DB in Express and attach it in SQL Server 2005. Or Backup and
Restore.
The backup and data files have 100% the same format.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9gca4$t42$1$8300dec7@.news.demon.co.uk...
> Hi,
> Was wondering if anyone could tell me how to convert the an SQL Server
> Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a
> day or so now and can't seem to find how to do this!!!
> Any ideas?
> Many Thanks
> Wayne Gibson
>
|||You should find you can just attach it with sp_attach_db. Did you try
that?
Please ask SQL Server 2005 questions in the appropriate newsgroups:
http://communities.microsoft.com/new...=sqlserver2005
David Portas
SQL Server MVP
|||Hi Mike,
Thanks for responding..
Could you tell me how I go about making a backup of a MS SQLServer Express
file.
I got MS SQLServer Express as part of the Visual Studio 2005 Beta 2, but
can't see any tools apart from those in the IDE.
Thanks
Wayne

Converting data from MySQL to SQL Server 2005

Hello,

Finally making the move to ASP.NET! I've been advised that to begin with it is probably best to start using SQL Server 2005 with ASP.NET. All my sites are currently using MySQL. Can anyone advise a way for me to import all the data from a MySQL database to a SQL Server 2005 database. Apologies if this isn't directly related to ASP.NET but any help would be greatly appreciated.

Thanks

Check out this page:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx

|||

Perfect. Great help. Thanks a lot.

Converting C++ Unix time_t Julian date to SQL date

I've just been trying to do this. I looked on Google and it seems to
be a common problem with no obvious solution. I've seen various
solutions which don't seem exactly elegant, so I figured I'd post the
solution I came up with. It's effectively a single line solution,
albeit with various embedded calls. It makes an adjustment for the
local timezone too!
DECLARE @.time_t INT
SET @.time_t = 1090834321/* 10:32am, July 26th 2004 BST */
DECLARE @.timestamp DATETIME
SET @.timestamp = dateadd (ss, datediff (ss, GetUTCDate(), GetDate()),
dateadd (ss, @.time_t, '19700101'))
PRINT @.timestamp
Hope that helps. If there's a problem with it, let me know!
andyt
Hi Andy,
I have received a data file and it has julian dates. How Do I convert them
to normal dates? I tried this code and replaced the variable with the date I
received, and All it did was give me the same date with different times.
Any ideas? What does the hardcoded '1970-01-01' do?
Thanks
Noma-Gcina
nmtshontshi@.deloitte.com
"Andy Turner" wrote:

> I've just been trying to do this. I looked on Google and it seems to
> be a common problem with no obvious solution. I've seen various
> solutions which don't seem exactly elegant, so I figured I'd post the
> solution I came up with. It's effectively a single line solution,
> albeit with various embedded calls. It makes an adjustment for the
> local timezone too!
>
> DECLARE @.time_t INT
> SET @.time_t = 1090834321/* 10:32am, July 26th 2004 BST */
> DECLARE @.timestamp DATETIME
> SET @.timestamp = dateadd (ss, datediff (ss, GetUTCDate(), GetDate()),
> dateadd (ss, @.time_t, '19700101'))
> PRINT @.timestamp
>
> Hope that helps. If there's a problem with it, let me know!
>
> andyt
>
|||The Unix timestamp value represents the number of seconds since 1970-01-01.
You can convert it like this:
DECLARE @.ts INTEGER
SET @.ts = 1098230400
SELECT DATEADD(SECOND,@.ts,'19700101')
(This isn't a Julian Date BTW)
David Portas
SQL Server MVP

Converting a SQL Database to MSDE

Ok, I've got the tables created, the proc's created (and they work) and
everything else is done on the backend. My question is how to do I get
everything I've created in the database using a full version of SQL into an
MSDE database that I can distribute to my userbase so they can play. Someone
said all I need to do is a backup and restore -- but I'm not sure how it
would be done. Can anyone help?
Backup and Restore is all you need.
Backup the database to a flat file
Restore onto MSDE using the flat file.
I would use SQL Enterprise Manager...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MisterB" <MisterB@.discussions.microsoft.com> wrote in message
news:65AA739F-3DA8-4CEF-813D-E8E4AFD95DAD@.microsoft.com...
> Ok, I've got the tables created, the proc's created (and they work) and
> everything else is done on the backend. My question is how to do I get
> everything I've created in the database using a full version of SQL into
an
> MSDE database that I can distribute to my userbase so they can play.
Someone
> said all I need to do is a backup and restore -- but I'm not sure how it
> would be done. Can anyone help?
|||"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23V6IM1p7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Backup and Restore is all you need.
> Backup the database to a flat file
> Restore onto MSDE using the flat file.
> I would use SQL Enterprise Manager...
Note that the datafile will need to be less than 2 gigabytes.

> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "MisterB" <MisterB@.discussions.microsoft.com> wrote in message
> news:65AA739F-3DA8-4CEF-813D-E8E4AFD95DAD@.microsoft.com...
> an
> Someone
>
|||How do you reattach the file(s) you backed up to the MSDE?
"Wayne Snyder" wrote:

> Backup and Restore is all you need.
> Backup the database to a flat file
> Restore onto MSDE using the flat file.
> I would use SQL Enterprise Manager...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "MisterB" <MisterB@.discussions.microsoft.com> wrote in message
> news:65AA739F-3DA8-4CEF-813D-E8E4AFD95DAD@.microsoft.com...
> an
> Someone
>
>

Convert Ntext type to XML type

I have a ntext column which stores rows of xml data.

Ive decided that the best way to query the xml data is to Convert the ntext data into xml data type and use Sql Server 2005 builtin Xml Query tools to perform FLWOR expressions. The problem Im having is getting the ntext data Converted to xml.

When I try to convert the ntext text, I of course get an error that local variables of ntext type are invalid.

Any suggestions on a way I might accomplish this?

Thanks, -lance

Hi,

From your description, it seems that you met trouble while you are going convert the field type from ntext to xml, right?

Based on my understanding , there are several factors which may cause the failure of the converting. Please make sure that you are not using "UTF-8" for your XML encoding in your ntext field. You can use "UTF-16" instead.

Another factor is you should make sure that the XML schema is right and the tags are in the right format, otherwise, it would also cause the failure of the converting.

Thanks.