We currently have 8 locations around the world with Access database on a
local machine in each location. Some of these locations are in remote areas
where network or internet connectivity is not available all the time. We are
looking to discontinue the Access database and migrate to either MS SQL
Server or Oracle.
We want to have local databases in each location and when ever there is
connectivity we want to be able to update the main database in the US. What
are the advantages of using SQL Server for this purpose and how can this be
done?
Thanks
SQL Server 2000 Replication Overview
http://www.microsoft.com/sql/evaluat...eplication.asp
AMB
"ADW" wrote:
> We currently have 8 locations around the world with Access database on a
> local machine in each location. Some of these locations are in remote areas
> where network or internet connectivity is not available all the time. We are
> looking to discontinue the Access database and migrate to either MS SQL
> Server or Oracle.
> We want to have local databases in each location and when ever there is
> connectivity we want to be able to update the main database in the US. What
> are the advantages of using SQL Server for this purpose and how can this be
> done?
> Thanks
>
|||SQL Server is easier to admin if you don't plan to hire a dedicated
experienced Oracle DBA.
Its software license is also cheaper, dual core CPUs count as 1 CPU license.
SQL 2005 is just around the corner in November, you can check the June
preview.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
http://www.microsoft.com/sql/2005/pr...5features.mspx
Showing posts with label size. Show all posts
Showing posts with label size. Show all posts
Tuesday, March 20, 2012
Advantages of using SQL Server vs Oracle for Small to Mdium Size N
We currently have 8 locations around the world with Access database on a
local machine in each location. Some of these locations are in remote areas
where network or internet connectivity is not available all the time. We are
looking to discontinue the Access database and migrate to either MS SQL
Server or Oracle.
We want to have local databases in each location and when ever there is
connectivity we want to be able to update the main database in the US. What
are the advantages of using SQL Server for this purpose and how can this be
done?
ThanksSQL Server 2000 Replication Overview
http://www.microsoft.com/sql/evaluation/features/replication.asp
AMB
"ADW" wrote:
> We currently have 8 locations around the world with Access database on a
> local machine in each location. Some of these locations are in remote areas
> where network or internet connectivity is not available all the time. We are
> looking to discontinue the Access database and migrate to either MS SQL
> Server or Oracle.
> We want to have local databases in each location and when ever there is
> connectivity we want to be able to update the main database in the US. What
> are the advantages of using SQL Server for this purpose and how can this be
> done?
> Thanks
>|||Thanks for the info, but what are the advantages of using MS SQL over Oracle?
ADW
"Alejandro Mesa" wrote:
> SQL Server 2000 Replication Overview
> http://www.microsoft.com/sql/evaluation/features/replication.asp
>
> AMB
> "ADW" wrote:
> > We currently have 8 locations around the world with Access database on a
> > local machine in each location. Some of these locations are in remote areas
> > where network or internet connectivity is not available all the time. We are
> > looking to discontinue the Access database and migrate to either MS SQL
> > Server or Oracle.
> >
> > We want to have local databases in each location and when ever there is
> > connectivity we want to be able to update the main database in the US. What
> > are the advantages of using SQL Server for this purpose and how can this be
> > done?
> >
> > Thanks
> >|||SQL Server is easier to admin if you don't plan to hire a dedicated
experienced Oracle DBA.
Its software license is also cheaper, dual core CPUs count as 1 CPU license.
SQL 2005 is just around the corner in November, you can check the June
preview.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
local machine in each location. Some of these locations are in remote areas
where network or internet connectivity is not available all the time. We are
looking to discontinue the Access database and migrate to either MS SQL
Server or Oracle.
We want to have local databases in each location and when ever there is
connectivity we want to be able to update the main database in the US. What
are the advantages of using SQL Server for this purpose and how can this be
done?
ThanksSQL Server 2000 Replication Overview
http://www.microsoft.com/sql/evaluation/features/replication.asp
AMB
"ADW" wrote:
> We currently have 8 locations around the world with Access database on a
> local machine in each location. Some of these locations are in remote areas
> where network or internet connectivity is not available all the time. We are
> looking to discontinue the Access database and migrate to either MS SQL
> Server or Oracle.
> We want to have local databases in each location and when ever there is
> connectivity we want to be able to update the main database in the US. What
> are the advantages of using SQL Server for this purpose and how can this be
> done?
> Thanks
>|||Thanks for the info, but what are the advantages of using MS SQL over Oracle?
ADW
"Alejandro Mesa" wrote:
> SQL Server 2000 Replication Overview
> http://www.microsoft.com/sql/evaluation/features/replication.asp
>
> AMB
> "ADW" wrote:
> > We currently have 8 locations around the world with Access database on a
> > local machine in each location. Some of these locations are in remote areas
> > where network or internet connectivity is not available all the time. We are
> > looking to discontinue the Access database and migrate to either MS SQL
> > Server or Oracle.
> >
> > We want to have local databases in each location and when ever there is
> > connectivity we want to be able to update the main database in the US. What
> > are the advantages of using SQL Server for this purpose and how can this be
> > done?
> >
> > Thanks
> >|||SQL Server is easier to admin if you don't plan to hire a dedicated
experienced Oracle DBA.
Its software license is also cheaper, dual core CPUs count as 1 CPU license.
SQL 2005 is just around the corner in November, you can check the June
preview.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
Advantages of using SQL Server vs Oracle for Small to Mdium Size N
We currently have 8 locations around the world with Access database on a
local machine in each location. Some of these locations are in remote areas
where network or internet connectivity is not available all the time. We are
looking to discontinue the Access database and migrate to either MS SQL
Server or Oracle.
We want to have local databases in each location and when ever there is
connectivity we want to be able to update the main database in the US. What
are the advantages of using SQL Server for this purpose and how can this be
done?
ThanksSQL Server 2000 Replication Overview
http://www.microsoft.com/sql/evalua...replication.asp
AMB
"ADW" wrote:
> We currently have 8 locations around the world with Access database on a
> local machine in each location. Some of these locations are in remote area
s
> where network or internet connectivity is not available all the time. We a
re
> looking to discontinue the Access database and migrate to either MS SQL
> Server or Oracle.
> We want to have local databases in each location and when ever there is
> connectivity we want to be able to update the main database in the US. Wha
t
> are the advantages of using SQL Server for this purpose and how can this b
e
> done?
> Thanks
>|||SQL Server is easier to admin if you don't plan to hire a dedicated
experienced Oracle DBA.
Its software license is also cheaper, dual core CPUs count as 1 CPU license.
SQL 2005 is just around the corner in November, you can check the June
preview.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
http://www.microsoft.com/sql/2005/p...05features.mspx
local machine in each location. Some of these locations are in remote areas
where network or internet connectivity is not available all the time. We are
looking to discontinue the Access database and migrate to either MS SQL
Server or Oracle.
We want to have local databases in each location and when ever there is
connectivity we want to be able to update the main database in the US. What
are the advantages of using SQL Server for this purpose and how can this be
done?
ThanksSQL Server 2000 Replication Overview
http://www.microsoft.com/sql/evalua...replication.asp
AMB
"ADW" wrote:
> We currently have 8 locations around the world with Access database on a
> local machine in each location. Some of these locations are in remote area
s
> where network or internet connectivity is not available all the time. We a
re
> looking to discontinue the Access database and migrate to either MS SQL
> Server or Oracle.
> We want to have local databases in each location and when ever there is
> connectivity we want to be able to update the main database in the US. Wha
t
> are the advantages of using SQL Server for this purpose and how can this b
e
> done?
> Thanks
>|||SQL Server is easier to admin if you don't plan to hire a dedicated
experienced Oracle DBA.
Its software license is also cheaper, dual core CPUs count as 1 CPU license.
SQL 2005 is just around the corner in November, you can check the June
preview.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx
http://www.microsoft.com/sql/2005/p...05features.mspx
Thursday, February 9, 2012
adjusting size of templog does not remain
A bit bizarre I could be overlooking something since tempdb is not like a us
er database.
Our log size for tempdb (templog) is 15mb, I need to increase this to 20mb.
I do so through the SQL Enterprise Manager. Adjust the size, hit apply and
the size is adjusted!
When I run a Financial apps that uses tempdb, I receive the message that the
templog files are full backup and ...
When I go back to tempdb the templog file is back at 15mb.
Jeff
Message posted via http://www.droptable.comPerhaps you restarted SQL Server in between. Size for tempdb at startup you
set using ALTER
DATABASE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeffrey Sheldon via droptable.com" <forum@.droptable.com> wrote in message
news:c83bbdcd541d46a4bb16394dcf882151@.SQ
droptable.com...
>A bit bizarre I could be overlooking something since tempdb is not like a u
ser database.
> Our log size for tempdb (templog) is 15mb, I need to increase this to 20mb
.
> I do so through the SQL Enterprise Manager. Adjust the size, hit apply an
d the size is adjusted!
> When I run a Financial apps that uses tempdb, I receive the message that t
he templog files are
> full backup and ...
> When I go back to tempdb the templog file is back at 15mb.
> Jeff
> --
> Message posted via http://www.droptable.com|||actually i thought the same..but when i change it on one of my local machine
using EM and restart sql server i see size of tempdb after the modification.
.
"Tibor Karaszi" wrote:
> Perhaps you restarted SQL Server in between. Size for tempdb at startup yo
u set using ALTER
> DATABASE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Jeffrey Sheldon via droptable.com" <forum@.droptable.com> wrote in messa
ge
> news:c83bbdcd541d46a4bb16394dcf882151@.SQ
droptable.com...
>
>|||Ahh yes, the lightbulb went off. tempdb needs the ALTERDATABASE command to
adjust its data/log files.
Thanks
Jeff
Message posted via http://www.droptable.com|||Ok now I am stumped.
I did
use master
ALTER DATABASE tempdb
MODIFY FILE
(name = templog,
size = 20MB)
go
The templog is then adjusted to 20mb.
I run my financial stored procedure and receive the message templog ran out
of space blah blah...
So I go back to review and increase so more, but lo and behold templog is Ba
ck at 15mb!!!!
A stored procedure that simply taking data from one database (less than 2000
records) and using temp tables to do some calculations make the log file sh
ift back to 15mb.
Any ideas?
Jeff
Message posted via http://www.droptable.com|||What size does master..sysaltfiles specify for the file? Also, perhaps you h
ave autoshrink turned on
for the tempdb database?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeffrey Sheldon via droptable.com" <forum@.droptable.com> wrote in message
news:29ce9a8218c945548d497982ae85ee55@.SQ
droptable.com...
> Ok now I am stumped.
> I did
> use master
> ALTER DATABASE tempdb
> MODIFY FILE
> (name = templog,
> size = 20MB)
> go
> The templog is then adjusted to 20mb.
> I run my financial stored procedure and receive the message templog ran ou
t of space blah blah...
> So I go back to review and increase so more, but lo and behold templog is
Back at 15mb!!!!
> A stored procedure that simply taking data from one database (less than 20
00 records) and using
> temp tables to do some calculations make the log file shift back to 15mb.
> Any ideas?
> Jeff
> --
> Message posted via http://www.droptable.com
er database.
Our log size for tempdb (templog) is 15mb, I need to increase this to 20mb.
I do so through the SQL Enterprise Manager. Adjust the size, hit apply and
the size is adjusted!
When I run a Financial apps that uses tempdb, I receive the message that the
templog files are full backup and ...
When I go back to tempdb the templog file is back at 15mb.
Jeff
Message posted via http://www.droptable.comPerhaps you restarted SQL Server in between. Size for tempdb at startup you
set using ALTER
DATABASE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeffrey Sheldon via droptable.com" <forum@.droptable.com> wrote in message
news:c83bbdcd541d46a4bb16394dcf882151@.SQ
droptable.com...
>A bit bizarre I could be overlooking something since tempdb is not like a u
ser database.
> Our log size for tempdb (templog) is 15mb, I need to increase this to 20mb
.
> I do so through the SQL Enterprise Manager. Adjust the size, hit apply an
d the size is adjusted!
> When I run a Financial apps that uses tempdb, I receive the message that t
he templog files are
> full backup and ...
> When I go back to tempdb the templog file is back at 15mb.
> Jeff
> --
> Message posted via http://www.droptable.com|||actually i thought the same..but when i change it on one of my local machine
using EM and restart sql server i see size of tempdb after the modification.
.
"Tibor Karaszi" wrote:
> Perhaps you restarted SQL Server in between. Size for tempdb at startup yo
u set using ALTER
> DATABASE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Jeffrey Sheldon via droptable.com" <forum@.droptable.com> wrote in messa
ge
> news:c83bbdcd541d46a4bb16394dcf882151@.SQ
droptable.com...
>
>|||Ahh yes, the lightbulb went off. tempdb needs the ALTERDATABASE command to
adjust its data/log files.
Thanks
Jeff
Message posted via http://www.droptable.com|||Ok now I am stumped.
I did
use master
ALTER DATABASE tempdb
MODIFY FILE
(name = templog,
size = 20MB)
go
The templog is then adjusted to 20mb.
I run my financial stored procedure and receive the message templog ran out
of space blah blah...
So I go back to review and increase so more, but lo and behold templog is Ba
ck at 15mb!!!!
A stored procedure that simply taking data from one database (less than 2000
records) and using temp tables to do some calculations make the log file sh
ift back to 15mb.
Any ideas?
Jeff
Message posted via http://www.droptable.com|||What size does master..sysaltfiles specify for the file? Also, perhaps you h
ave autoshrink turned on
for the tempdb database?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeffrey Sheldon via droptable.com" <forum@.droptable.com> wrote in message
news:29ce9a8218c945548d497982ae85ee55@.SQ
droptable.com...
> Ok now I am stumped.
> I did
> use master
> ALTER DATABASE tempdb
> MODIFY FILE
> (name = templog,
> size = 20MB)
> go
> The templog is then adjusted to 20mb.
> I run my financial stored procedure and receive the message templog ran ou
t of space blah blah...
> So I go back to review and increase so more, but lo and behold templog is
Back at 15mb!!!!
> A stored procedure that simply taking data from one database (less than 20
00 records) and using
> temp tables to do some calculations make the log file shift back to 15mb.
> Any ideas?
> Jeff
> --
> Message posted via http://www.droptable.com
adjusting size of templog does not remain
A bit bizarre I could be overlooking something since tempdb is not like a user database.
Our log size for tempdb (templog) is 15mb, I need to increase this to 20mb.
I do so through the SQL Enterprise Manager. Adjust the size, hit apply and the size is adjusted!
When I run a Financial apps that uses tempdb, I receive the message that the templog files are full backup and ...
When I go back to tempdb the templog file is back at 15mb.
Jeff
Message posted via http://www.sqlmonster.com
Perhaps you restarted SQL Server in between. Size for tempdb at startup you set using ALTER
DATABASE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c83bbdcd541d46a4bb16394dcf882151@.SQLMonster.c om...
>A bit bizarre I could be overlooking something since tempdb is not like a user database.
> Our log size for tempdb (templog) is 15mb, I need to increase this to 20mb.
> I do so through the SQL Enterprise Manager. Adjust the size, hit apply and the size is adjusted!
> When I run a Financial apps that uses tempdb, I receive the message that the templog files are
> full backup and ...
> When I go back to tempdb the templog file is back at 15mb.
> Jeff
> --
> Message posted via http://www.sqlmonster.com
|||actually i thought the same..but when i change it on one of my local machine
using EM and restart sql server i see size of tempdb after the modification...
"Tibor Karaszi" wrote:
> Perhaps you restarted SQL Server in between. Size for tempdb at startup you set using ALTER
> DATABASE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> news:c83bbdcd541d46a4bb16394dcf882151@.SQLMonster.c om...
>
>
|||Ahh yes, the lightbulb went off. tempdb needs the ALTERDATABASE command to adjust its data/log files.
Thanks
Jeff
Message posted via http://www.sqlmonster.com
|||Ok now I am stumped.
I did
use master
ALTER DATABASE tempdb
MODIFY FILE
(name = templog,
size = 20MB)
go
The templog is then adjusted to 20mb.
I run my financial stored procedure and receive the message templog ran out of space blah blah...
So I go back to review and increase so more, but lo and behold templog is Back at 15mb!!!!
A stored procedure that simply taking data from one database (less than 2000 records) and using temp tables to do some calculations make the log file shift back to 15mb.
Any ideas?
Jeff
Message posted via http://www.sqlmonster.com
|||What size does master..sysaltfiles specify for the file? Also, perhaps you have autoshrink turned on
for the tempdb database?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:29ce9a8218c945548d497982ae85ee55@.SQLMonster.c om...
> Ok now I am stumped.
> I did
> use master
> ALTER DATABASE tempdb
> MODIFY FILE
> (name = templog,
> size = 20MB)
> go
> The templog is then adjusted to 20mb.
> I run my financial stored procedure and receive the message templog ran out of space blah blah...
> So I go back to review and increase so more, but lo and behold templog is Back at 15mb!!!!
> A stored procedure that simply taking data from one database (less than 2000 records) and using
> temp tables to do some calculations make the log file shift back to 15mb.
> Any ideas?
> Jeff
> --
> Message posted via http://www.sqlmonster.com
Our log size for tempdb (templog) is 15mb, I need to increase this to 20mb.
I do so through the SQL Enterprise Manager. Adjust the size, hit apply and the size is adjusted!
When I run a Financial apps that uses tempdb, I receive the message that the templog files are full backup and ...
When I go back to tempdb the templog file is back at 15mb.
Jeff
Message posted via http://www.sqlmonster.com
Perhaps you restarted SQL Server in between. Size for tempdb at startup you set using ALTER
DATABASE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c83bbdcd541d46a4bb16394dcf882151@.SQLMonster.c om...
>A bit bizarre I could be overlooking something since tempdb is not like a user database.
> Our log size for tempdb (templog) is 15mb, I need to increase this to 20mb.
> I do so through the SQL Enterprise Manager. Adjust the size, hit apply and the size is adjusted!
> When I run a Financial apps that uses tempdb, I receive the message that the templog files are
> full backup and ...
> When I go back to tempdb the templog file is back at 15mb.
> Jeff
> --
> Message posted via http://www.sqlmonster.com
|||actually i thought the same..but when i change it on one of my local machine
using EM and restart sql server i see size of tempdb after the modification...
"Tibor Karaszi" wrote:
> Perhaps you restarted SQL Server in between. Size for tempdb at startup you set using ALTER
> DATABASE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> news:c83bbdcd541d46a4bb16394dcf882151@.SQLMonster.c om...
>
>
|||Ahh yes, the lightbulb went off. tempdb needs the ALTERDATABASE command to adjust its data/log files.
Thanks
Jeff
Message posted via http://www.sqlmonster.com
|||Ok now I am stumped.
I did
use master
ALTER DATABASE tempdb
MODIFY FILE
(name = templog,
size = 20MB)
go
The templog is then adjusted to 20mb.
I run my financial stored procedure and receive the message templog ran out of space blah blah...
So I go back to review and increase so more, but lo and behold templog is Back at 15mb!!!!
A stored procedure that simply taking data from one database (less than 2000 records) and using temp tables to do some calculations make the log file shift back to 15mb.
Any ideas?
Jeff
Message posted via http://www.sqlmonster.com
|||What size does master..sysaltfiles specify for the file? Also, perhaps you have autoshrink turned on
for the tempdb database?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:29ce9a8218c945548d497982ae85ee55@.SQLMonster.c om...
> Ok now I am stumped.
> I did
> use master
> ALTER DATABASE tempdb
> MODIFY FILE
> (name = templog,
> size = 20MB)
> go
> The templog is then adjusted to 20mb.
> I run my financial stored procedure and receive the message templog ran out of space blah blah...
> So I go back to review and increase so more, but lo and behold templog is Back at 15mb!!!!
> A stored procedure that simply taking data from one database (less than 2000 records) and using
> temp tables to do some calculations make the log file shift back to 15mb.
> Any ideas?
> Jeff
> --
> Message posted via http://www.sqlmonster.com
Subscribe to:
Posts (Atom)