Minimum Date in DateStamp field is not 1-Jan-100. Wouldn't we expect that.
In SQLServer2000 is it "1-Jan-100", if not WHY ??,
In the previous versions it is "01-Jan-1753"
bikramjeetThe problem lies with the Gregorian calendar, not the SQL software.
If you go back before 1753, you start to run into all kinds of problems with dates. Finding out which day corresponds to a particular date means that the algorithm needs to know where you want the date resolved from a political standpoint as well as a chronological standpoint. There are also a number of other problems that crop up, such as certain calender days occuring more than once. It gets ugly.
See Wolfram (http://scienceworld.wolfram.com/astronomy/GregorianCalendar.html) for more explaination.
-PatP|||The problem lies with the Gregorian calendar, not the SQL software.
If you go back before 1753, you start to run into all kinds of problems with dates. Finding out which day corresponds to a particular date means that the algorithm needs to know where you want the date resolved from a political standpoint as well as a chronological standpoint. There are also a number of other problems that crop up, such as certain calender days occuring more than once. It gets ugly.
See Wolfram (http://scienceworld.wolfram.com/astronomy/GregorianCalendar.html) for more explaination.
-PatP
I always found that to be a lame excuse...
As if there aren't enough...what the technical word they use...oh well, kludges in M$ internal code anyway...
If they really wanted to..(and who the hell said ancient dates are precise anyway)...bulid it in tho the damn date functions...why limit it?
Next they'll be telling us you can't travel fatser than the speed of light...
The Church of M$|||I always found that to be a lame excuse...Yeah, but Convert() would be kind of funky if it had arguments for your location, political affiliation, and religion!
Oracle solves this problem by simply ignoring the Gregorian reformation altogether... You simply learn to live on Oracle time!
There are other client programming languages that have library code that detects the PC's locale and uses that to make the decisions (which are frequently incorrect) about date conversions. This can be a real hoot to debug, since the exact same binary running on the exact same release of windoze would change its results based on where it thought the PC was!
That leads to the issue of lunar calendars that have leap months added on a tough to predict basis... That's even more fun!
I don't remember if you were involved in the discussion of database normalization that Rudy invited me to that was the first time I'd posted here... The issue of dates is a lot like the issue of normalization: if you know nothing about it, no problem; if you know a little bit about it, not a big problem; as you learn more than just a little, the problem gets bigger and uglier really fast. The whole thing becomes a slippery slope, so it gets tough to dance!
-PatP
Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
Wednesday, March 21, 2012
Friday, March 9, 2012
Migration SQLSERVER DB from one server to another Server
Hello,
How to migrate SQLSERVER DB from one server to another Server?
We are planning from Compaq server to Dell and vice versa?
Thx.
-SeenaBackup all databases from one server and restore on the other.
I think BOL has info on how to do this for system databases - if not just do a search.
Also look at detach/attach.
Worth reading up about system databases first.|||Hello,
It is the same as the other member of dBforums explained to you. It is so simple, you need only to backup the database. If you are using MS SQL Server 2000, you'll have to choose the database:
- right click
- all tasks
- backup database
- choose the device to which you want to copy (tape/disk)
Then on the other PC, create these databases manually and:
-choose the newly created DB
-right click
-all tasks
-restore database
-choose the source
Otherwise, you can use the DTS service which is available in SQL Server 2000.
it is so simple to use.
Take cares & good luck!
Alzebdeh
Originally posted by sqlserverdb
Hello,
How to migrate SQLSERVER DB from one server to another Server?
We are planning from Compaq server to Dell and vice versa?
Thx.
-Seena|||The easiest, if you have both computer on-line, is to Detach the databases
and copy the MDF and LDF files into the new server, then attach those files
into new SQl.
"Alzebdeh" wrote in message
news:2441325.1043640789@.dbforums.com...
> Hello,
> It is the same as the other member of dBforums explained to you. It is
> so simple, you need only to backup the database. If you are using MS SQL
> Server 2000, you'll have to choose the database:
> - right click
> - all tasks
> - backup database
> - choose the device to which you want to copy (tape/disk)
> Then on the other PC, create these databases manually and:
> -choose the newly created DB
> -right click
> -all tasks
> -restore database
> -choose the source
> Otherwise, you can use the DTS service which is available in SQL
> Server 2000.
> it is so simple to use.
> Take cares & good luck!
> Alzebdeh
> Originally posted by sqlserverdb
> > Hello,
> > How to migrate SQLSERVER DB from one server to another Server?
> > We are planning from Compaq server to Dell and vice versa?
> > Thx.
> -Seena
> --
> Posted via http://dbforums.com (http://dbforums.com/)
How to migrate SQLSERVER DB from one server to another Server?
We are planning from Compaq server to Dell and vice versa?
Thx.
-SeenaBackup all databases from one server and restore on the other.
I think BOL has info on how to do this for system databases - if not just do a search.
Also look at detach/attach.
Worth reading up about system databases first.|||Hello,
It is the same as the other member of dBforums explained to you. It is so simple, you need only to backup the database. If you are using MS SQL Server 2000, you'll have to choose the database:
- right click
- all tasks
- backup database
- choose the device to which you want to copy (tape/disk)
Then on the other PC, create these databases manually and:
-choose the newly created DB
-right click
-all tasks
-restore database
-choose the source
Otherwise, you can use the DTS service which is available in SQL Server 2000.
it is so simple to use.
Take cares & good luck!
Alzebdeh
Originally posted by sqlserverdb
Hello,
How to migrate SQLSERVER DB from one server to another Server?
We are planning from Compaq server to Dell and vice versa?
Thx.
-Seena|||The easiest, if you have both computer on-line, is to Detach the databases
and copy the MDF and LDF files into the new server, then attach those files
into new SQl.
"Alzebdeh" wrote in message
news:2441325.1043640789@.dbforums.com...
> Hello,
> It is the same as the other member of dBforums explained to you. It is
> so simple, you need only to backup the database. If you are using MS SQL
> Server 2000, you'll have to choose the database:
> - right click
> - all tasks
> - backup database
> - choose the device to which you want to copy (tape/disk)
> Then on the other PC, create these databases manually and:
> -choose the newly created DB
> -right click
> -all tasks
> -restore database
> -choose the source
> Otherwise, you can use the DTS service which is available in SQL
> Server 2000.
> it is so simple to use.
> Take cares & good luck!
> Alzebdeh
> Originally posted by sqlserverdb
> > Hello,
> > How to migrate SQLSERVER DB from one server to another Server?
> > We are planning from Compaq server to Dell and vice versa?
> > Thx.
> -Seena
> --
> Posted via http://dbforums.com (http://dbforums.com/)
Migration of SQLServer user databases to another SQLServer
Guys,
I would like to migrate a number of user databases from one SQLSERVER (name:
LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to another (na
me: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3)).
Please can you outline the steps involved and any pitfalls I should watch fo
r? I am new to SQLServer and this is live data. This needs completing today
as well!!
TIA, KenKen,
Have a look at:
INF: Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/defaul...kb;EN-US;224071
Mark Allison, SQL Server MVP
Ken Jones wrote:
> Guys,
> I would like to migrate a number of user databases from one SQLSERVER (nam
e: LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to another (
name: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3)).
> Please can you outline the steps involved and any pitfalls I should watch
for? I am new to SQLServer and this is live data. This needs completing toda
y as well!!
> TIA, Ken
>
Mark Allison, SQL Server MVP
http://www.allisonmitchell.com|||Hi,
Since you need to upgrade only the user databases you can do one of the
folowing
1. Detach and Attach databases
2. Backup and Restore the databases
1. Detach and Attach
a. Use SP_DETACH_DB to detach the MDF and LDF files
b. Copy the files to Destination server
c. Use SP_ATTACH_DB to attach the databases
(Refer books online for information)
2. Backup and Restore
a. Backup the source databases using BACKUP DATABASE command
b. Copy the .BAK files to destination
c. Restore the database using RESTORE DATABASE command
After this steps you may need to move the logins from source server to
destination server.
Have a look into the below link for information.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"Ken Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:1442724A-12BF-4AF2-8A02-B558DCA60658@.microsoft.com...
> Guys,
> I would like to migrate a number of user databases from one SQLSERVER
(name: LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to
another (name: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3)).
> Please can you outline the steps involved and any pitfalls I should watch
for? I am new to SQLServer and this is live data. This needs completing
today as well!!
> TIA, Ken
>|||Mark,
So I can detach (using sp_detach) from the source database, ftp to new serve
r and then attach (using sp_attach)'
Is that all there is to it? Will the sp_attach alert master as to the appear
ance of x number of new user databases as I am moving from one SQLServer (li
ve) to a completely different, functioning SQLServer(live)?
TIA, Ken.|||Thanks for your swift replies - WOW!!|||Hi Hari,
Some of my files are .DAT files. Will this affect the detach and attach proc
ess?
TIA, Ken|||DAT files could mean they are 6.5 database files. You can't move such across
to 7.0/2000. You need to have those databases available in a 6.5 install and
use the upgrade wizard from there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Ken Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:40772738-BE5B-4C98-86D9-DE1DB7959FFB@.microsoft.com...
> Hi Hari,
> Some of my files are .DAT files. Will this affect the detach and attach
process?
> TIA, Ken|||"I would like to migrate a number of user databases from one SQLSERVER (name
: LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to another (n
ame: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3))."
Both are SQLServer8 servers. I am going to try the sp_detach_db and sp_attac
h_db by ftp'ing the LDF and MDF files. I'll see if this works.
Ken|||OK I just mentioned the 6.5 stuff because in 6.5 DAT were the default
extension for both database and backup files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Ken Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:63CF9224-D4BF-4550-AF7E-4B139C9C1E69@.microsoft.com...
> "I would like to migrate a number of user databases from one SQLSERVER
(name: LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to
another (name: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3))."
> Both are SQLServer8 servers. I am going to try the sp_detach_db and
sp_attach_db by ftp'ing the LDF and MDF files. I'll see if this works.
> Ken
I would like to migrate a number of user databases from one SQLSERVER (name:
LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to another (na
me: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3)).
Please can you outline the steps involved and any pitfalls I should watch fo
r? I am new to SQLServer and this is live data. This needs completing today
as well!!
TIA, KenKen,
Have a look at:
INF: Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/defaul...kb;EN-US;224071
Mark Allison, SQL Server MVP
Ken Jones wrote:
> Guys,
> I would like to migrate a number of user databases from one SQLSERVER (nam
e: LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to another (
name: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3)).
> Please can you outline the steps involved and any pitfalls I should watch
for? I am new to SQLServer and this is live data. This needs completing toda
y as well!!
> TIA, Ken
>
Mark Allison, SQL Server MVP
http://www.allisonmitchell.com|||Hi,
Since you need to upgrade only the user databases you can do one of the
folowing
1. Detach and Attach databases
2. Backup and Restore the databases
1. Detach and Attach
a. Use SP_DETACH_DB to detach the MDF and LDF files
b. Copy the files to Destination server
c. Use SP_ATTACH_DB to attach the databases
(Refer books online for information)
2. Backup and Restore
a. Backup the source databases using BACKUP DATABASE command
b. Copy the .BAK files to destination
c. Restore the database using RESTORE DATABASE command
After this steps you may need to move the logins from source server to
destination server.
Have a look into the below link for information.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"Ken Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:1442724A-12BF-4AF2-8A02-B558DCA60658@.microsoft.com...
> Guys,
> I would like to migrate a number of user databases from one SQLSERVER
(name: LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to
another (name: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3)).
> Please can you outline the steps involved and any pitfalls I should watch
for? I am new to SQLServer and this is live data. This needs completing
today as well!!
> TIA, Ken
>|||Mark,
So I can detach (using sp_detach) from the source database, ftp to new serve
r and then attach (using sp_attach)'
Is that all there is to it? Will the sp_attach alert master as to the appear
ance of x number of new user databases as I am moving from one SQLServer (li
ve) to a completely different, functioning SQLServer(live)?
TIA, Ken.|||Thanks for your swift replies - WOW!!|||Hi Hari,
Some of my files are .DAT files. Will this affect the detach and attach proc
ess?
TIA, Ken|||DAT files could mean they are 6.5 database files. You can't move such across
to 7.0/2000. You need to have those databases available in a 6.5 install and
use the upgrade wizard from there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Ken Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:40772738-BE5B-4C98-86D9-DE1DB7959FFB@.microsoft.com...
> Hi Hari,
> Some of my files are .DAT files. Will this affect the detach and attach
process?
> TIA, Ken|||"I would like to migrate a number of user databases from one SQLSERVER (name
: LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to another (n
ame: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3))."
Both are SQLServer8 servers. I am going to try the sp_detach_db and sp_attac
h_db by ftp'ing the LDF and MDF files. I'll see if this works.
Ken|||OK I just mentioned the 6.5 stuff because in 6.5 DAT were the default
extension for both database and backup files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Ken Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:63CF9224-D4BF-4550-AF7E-4B139C9C1E69@.microsoft.com...
> "I would like to migrate a number of user databases from one SQLSERVER
(name: LECOMMS02 - Windows NT - 5.0(2195), SQLServer 8.00.534(SP2)) to
another (name: LEPIV01 - Windows NT - 5.0(2195), SQLServer 8.00.780(SP3))."
> Both are SQLServer8 servers. I am going to try the sp_detach_db and
sp_attach_db by ftp'ing the LDF and MDF files. I'll see if this works.
> Ken
Migration of Sql Server 7
Hi All,
Greetings,
We have
sql server 7
Sqlserver ServicePack SP3
Sort Order = 32
BuildNumber 7.00.961
on Windows NT,Now we are planning to upgrade operating system from win NT machine to windows 2000.
Please let me know what and all precausion do i need to take what and what all backup should be done apart from user database.
How do i take care of the users,logins,roles, DTS Job and Replication.
Please help me in this and also any links if u have on this topic
Waiting for reply
TIA
AdilWill you also be upgrading to SQL 2000 ?
When I moved to a new machine, we shut down SQL Server on both boxes, copied the database files to the new server and then started SQL Server. Because you are moving master you get all the login id's, etc. Just make sure you are running the same version of SQL server, otherwise it can get complicated.|||yes we are running the same version of SQL server.
pls suggest how do i go about it.
Thanks for ur reply
TIA
Adil
Greetings,
We have
sql server 7
Sqlserver ServicePack SP3
Sort Order = 32
BuildNumber 7.00.961
on Windows NT,Now we are planning to upgrade operating system from win NT machine to windows 2000.
Please let me know what and all precausion do i need to take what and what all backup should be done apart from user database.
How do i take care of the users,logins,roles, DTS Job and Replication.
Please help me in this and also any links if u have on this topic
Waiting for reply
TIA
AdilWill you also be upgrading to SQL 2000 ?
When I moved to a new machine, we shut down SQL Server on both boxes, copied the database files to the new server and then started SQL Server. Because you are moving master you get all the login id's, etc. Just make sure you are running the same version of SQL server, otherwise it can get complicated.|||yes we are running the same version of SQL server.
pls suggest how do i go about it.
Thanks for ur reply
TIA
Adil
Wednesday, March 7, 2012
Migration from VFP to MS SQL Server 2000
Dear Friends,
I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to
share the experience with you, if you have undergone such a task. Is
there any utility for achieving
this.
Any white paper or link for guidance on the same.
I wannted to migrate the whole database to MS SQL Server 2000. I
wanted to migrate the table
structures and procedures to MS SQL Server 2000.
Please shed some light please.
Regards
KumarReplied in microsoft.public.sqlserver.server
Please don't multi-post.
--
David Portas
----
Please reply only to the newsgroup
--
Subscribe to:
Posts (Atom)