Purchasing Microsoft SQL Server for small company

I currently have a database through a company that has been upkeeping SQL and
storing data. I am cancelling subscription and want to retrieve data. They
are sending me a backup DVD with all the files. How easy is it to use
Microsoft SQL and can the files be transfered to another program such as
Access or Excel'
ThanksAre you saying that you have data stored in a SQL Server database, which is
hosted by other company, and you now want to sotre your data by yourself? If
so, the best way to do is to set up your own SQL Server, have you data on
the other SQL Server backed up and restore it on your own SQL Server. (or
use detach/attach database from/to SQL Server).
There are different edition of SQL Server, from very expensive Enterprise
Edition, to free version of SQL Server Express/MSDE. If your data value is
not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
course, some basic knowledge on SQL Server is required (I mean a bit more
and complicated that required by using Access).
If you want those data being transferred to Access DB, then you can ask your
SQL Server host to export it to a *.mdb file. However, in general, only data
can be transferred, server object used in that database (view, sp... they
may contain critical logics for using the database) would not be
transferred. So, you would need to build a sort of front end app inorder to
use your data. Unless the only thing you need is the data.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||You are taking a big step backward going from SQL Server to MS Access and an
even bigger step if you go to Excel.
Microsoft SQL Server is an enterprise level relational database management
system.
Microsoft Access is a database engine but it is not quite enterprise level.
MS Excel is can be used to display information to management types and
create pretty reports, but it is by no means an enterprise storage
technology.
IF your host sends you the correct information -- backup files created via
the T-SQL BACKUP command OR database and log files after they ran
sp_detach_db -- you should be able to restore the database(s) to a SQL
Server in your environment.
SQL Server does not have "files" (like Excel). It is more similar to MS
Access in that it has tables within one container (a database).
Keith Kratochvil
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||The company is not using the system to it's fullest potential. The users are
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't be
using the system. We want to transfer it to Access.
Thanks
"Norman Yuan" wrote:
> Are you saying that you have data stored in a SQL Server database, which is
> hosted by other company, and you now want to sotre your data by yourself? If
> so, the best way to do is to set up your own SQL Server, have you data on
> the other SQL Server backed up and restore it on your own SQL Server. (or
> use detach/attach database from/to SQL Server).
> There are different edition of SQL Server, from very expensive Enterprise
> Edition, to free version of SQL Server Express/MSDE. If your data value is
> not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
> course, some basic knowledge on SQL Server is required (I mean a bit more
> and complicated that required by using Access).
> If you want those data being transferred to Access DB, then you can ask your
> SQL Server host to export it to a *.mdb file. However, in general, only data
> can be transferred, server object used in that database (view, sp... they
> may contain critical logics for using the database) would not be
> transferred. So, you would need to build a sort of front end app inorder to
> use your data. Unless the only thing you need is the data.
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
> >I currently have a database through a company that has been upkeeping SQL
> >and
> > storing data. I am cancelling subscription and want to retrieve data.
> > They
> > are sending me a backup DVD with all the files. How easy is it to use
> > Microsoft SQL and can the files be transfered to another program such as
> > Access or Excel'
> >
> > Thanks
>
>|||The company is not using the system to it's fullest potential. The users are
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't be
using the system. We want to transfer it to Access.
Thanks
"Keith Kratochvil" wrote:
> You are taking a big step backward going from SQL Server to MS Access and an
> even bigger step if you go to Excel.
> Microsoft SQL Server is an enterprise level relational database management
> system.
> Microsoft Access is a database engine but it is not quite enterprise level.
> MS Excel is can be used to display information to management types and
> create pretty reports, but it is by no means an enterprise storage
> technology.
>
> IF your host sends you the correct information -- backup files created via
> the T-SQL BACKUP command OR database and log files after they ran
> sp_detach_db -- you should be able to restore the database(s) to a SQL
> Server in your environment.
>
> SQL Server does not have "files" (like Excel). It is more similar to MS
> Access in that it has tables within one container (a database).
>
> --
> Keith Kratochvil
>
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
> >I currently have a database through a company that has been upkeeping SQL
> >and
> > storing data. I am cancelling subscription and want to retrieve data.
> > They
> > are sending me a backup DVD with all the files. How easy is it to use
> > Microsoft SQL and can the files be transfered to another program such as
> > Access or Excel'
> >
> > Thanks
>
>|||Maybe SQL Server Express combined with MS Access front-ends is the answer.
SS Express is free.
Randall Arnold
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:49490C53-3ADC-418F-8E8F-A7468A98DEE4@.microsoft.com...
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Keith Kratochvil" wrote:
>> You are taking a big step backward going from SQL Server to MS Access and
>> an
>> even bigger step if you go to Excel.
>> Microsoft SQL Server is an enterprise level relational database
>> management
>> system.
>> Microsoft Access is a database engine but it is not quite enterprise
>> level.
>> MS Excel is can be used to display information to management types and
>> create pretty reports, but it is by no means an enterprise storage
>> technology.
>>
>> IF your host sends you the correct information -- backup files created
>> via
>> the T-SQL BACKUP command OR database and log files after they ran
>> sp_detach_db -- you should be able to restore the database(s) to a SQL
>> Server in your environment.
>>
>> SQL Server does not have "files" (like Excel). It is more similar to MS
>> Access in that it has tables within one container (a database).
>>
>> --
>> Keith Kratochvil
>>
>> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>> >I currently have a database through a company that has been upkeeping
>> >SQL
>> >and
>> > storing data. I am cancelling subscription and want to retrieve data.
>> > They
>> > are sending me a backup DVD with all the files. How easy is it to use
>> > Microsoft SQL and can the files be transfered to another program such
>> > as
>> > Access or Excel'
>> >
>> > Thanks
>>|||Eddie,
You can certainly use Access as the front-end program for
your users, even if you maintain the data in SQL Server.
SQL Server in fact has no front-end, really - just a set of
management tools, so you have many options for your
users.
Since no one has mentioned it, don't overlook the Workgroup
Edition of SQL Server, which might be good for your needs.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Steve Kass
Drew University
Eddie wrote:
>The company is not using the system to it's fullest potential. The users are
>not computer savvy and would prefer a more simple system ie: Access. They
>don't want to be paying the fees associated to a program they don't use.
>They have 7 years of data they need to access and I have to figure out how.
>Once we access the data and can retrieve the reports and pictures we won't be
>using the system. We want to transfer it to Access.
>Thanks
>"Norman Yuan" wrote:
>
>>Are you saying that you have data stored in a SQL Server database, which is
>>hosted by other company, and you now want to sotre your data by yourself? If
>>so, the best way to do is to set up your own SQL Server, have you data on
>>the other SQL Server backed up and restore it on your own SQL Server. (or
>>use detach/attach database from/to SQL Server).
>>There are different edition of SQL Server, from very expensive Enterprise
>>Edition, to free version of SQL Server Express/MSDE. If your data value is
>>not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
>>course, some basic knowledge on SQL Server is required (I mean a bit more
>>and complicated that required by using Access).
>>If you want those data being transferred to Access DB, then you can ask your
>>SQL Server host to export it to a *.mdb file. However, in general, only data
>>can be transferred, server object used in that database (view, sp... they
>>may contain critical logics for using the database) would not be
>>transferred. So, you would need to build a sort of front end app inorder to
>>use your data. Unless the only thing you need is the data.
>>"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>>news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>>
>>I currently have a database through a company that has been upkeeping SQL
>>and
>>storing data. I am cancelling subscription and want to retrieve data.
>>They
>>are sending me a backup DVD with all the files. How easy is it to use
>>Microsoft SQL and can the files be transfered to another program such as
>>Access or Excel'
>>Thanks
>>
>>|||So, summarize what you want:
1. You have data stored in database of someone's SQL Server;
2. You need to get all data out in this database and svae them in some
formats you choose;
3. You do not need application related server objects/logics in the database
(views, stored procedures, UDFs) once you retrieved the data;
4. The SQL Server host would not do the data retrieving for you. They can
only give you the backup or data file of the database.
Since you want to transfer data from SQL Server to Access (more accurately,
Jet database), there may be some degree of data or data type or data
accuracy loss because of the differences of the two data engine.
Here is what I would do:
1. Get full backup or detached database file (latter would be better);
2. Install a MSDE, which is free version of SQL Server, if the data file of
the database (*.mdf) is less than 2GB.
3. Restore/attach the databse to MSDE.
4. Use Access as tool to connect to MSDE and start retrieve data. You can
create an Access ADP project to use as MSDE front end UI. Then you can open
each table to export, or write some macro/VBA code to retireve specific data
and output to specific format.
5. Since I have the database on my onw, no-cost MSDE engine, I can try and
try until satisfied totally (of course do it on a copy of the data).
6, Do the final retrieving and then uninstall the MSDE.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:E426270B-5851-456C-B190-1D747BAFA433@.microsoft.com...
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Norman Yuan" wrote:
>> Are you saying that you have data stored in a SQL Server database, which
>> is
>> hosted by other company, and you now want to sotre your data by yourself?
>> If
>> so, the best way to do is to set up your own SQL Server, have you data on
>> the other SQL Server backed up and restore it on your own SQL Server. (or
>> use detach/attach database from/to SQL Server).
>> There are different edition of SQL Server, from very expensive Enterprise
>> Edition, to free version of SQL Server Express/MSDE. If your data value
>> is
>> not so big (2G or 4G), you can use MSDE or SQL Server Express for free.
>> Of
>> course, some basic knowledge on SQL Server is required (I mean a bit more
>> and complicated that required by using Access).
>> If you want those data being transferred to Access DB, then you can ask
>> your
>> SQL Server host to export it to a *.mdb file. However, in general, only
>> data
>> can be transferred, server object used in that database (view, sp... they
>> may contain critical logics for using the database) would not be
>> transferred. So, you would need to build a sort of front end app inorder
>> to
>> use your data. Unless the only thing you need is the data.
>> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>> >I currently have a database through a company that has been upkeeping
>> >SQL
>> >and
>> > storing data. I am cancelling subscription and want to retrieve data.
>> > They
>> > are sending me a backup DVD with all the files. How easy is it to use
>> > Microsoft SQL and can the files be transfered to another program such
>> > as
>> > Access or Excel'
>> >
>> > Thanks
>>

Punctuation

I am trying to improve searching performance ... but I am storing data that
contains punctuation marks ... such as "E.L.O." and "R.E.M." (names of song
artists/groups).
Does this mean that I cannot use full-text searching at all for searching
for these artist names?
Is there a work-breaker that will allow the punctuation marks (fullstops in
particular), or is this a search issue rather than a word-breaker issue (i.e.
CONTAINS clause does not allow punctuation anyway)?
Wozza,
Can you post the full output of -- SELECT @.@.version -- where you have this
problem?
Have you removed all single letter from the language-specific noise word
files (under \FTDATA\SQLServer\Config where you have SQL Server installed)
and ran a Full Population after these modifications? If not, then please do
this. The default wordbreaker behavior for punctuation is dependent upon the
OS-supplied wordbreaker and the @.@.version info will provide that.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Wozza" <Wozza@.discussions.microsoft.com> wrote in message
news:4FCD6297-AF76-4DE0-A43F-9FE2B667BAB2@.microsoft.com...
>I am trying to improve searching performance ... but I am storing data that
> contains punctuation marks ... such as "E.L.O." and "R.E.M." (names of
> song
> artists/groups).
> Does this mean that I cannot use full-text searching at all for searching
> for these artist names?
> Is there a work-breaker that will allow the punctuation marks (fullstops
> in
> particular), or is this a search issue rather than a word-breaker issue
> (i.e.
> CONTAINS clause does not allow punctuation anyway)?
>
|||Hi John,
select @.@.version produces ...
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"John Kane" wrote:

> Wozza,
> Can you post the full output of -- SELECT @.@.version -- where you have this
> problem?
> Have you removed all single letter from the language-specific noise word
> files (under \FTDATA\SQLServer\Config where you have SQL Server installed)
> and ran a Full Population after these modifications? If not, then please do
> this. The default wordbreaker behavior for punctuation is dependent upon the
> OS-supplied wordbreaker and the @.@.version info will provide that.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Wozza" <Wozza@.discussions.microsoft.com> wrote in message
> news:4FCD6297-AF76-4DE0-A43F-9FE2B667BAB2@.microsoft.com...
>
>
|||John,
I have also cleared the Noise.dat file (my index set up to use the Neutral
language).
If I have done this ... how do I serach for "r.e.m." for instance.
Warren
"John Kane" wrote:

> Wozza,
> Can you post the full output of -- SELECT @.@.version -- where you have this
> problem?
> Have you removed all single letter from the language-specific noise word
> files (under \FTDATA\SQLServer\Config where you have SQL Server installed)
> and ran a Full Population after these modifications? If not, then please do
> this. The default wordbreaker behavior for punctuation is dependent upon the
> OS-supplied wordbreaker and the @.@.version info will provide that.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Wozza" <Wozza@.discussions.microsoft.com> wrote in message
> news:4FCD6297-AF76-4DE0-A43F-9FE2B667BAB2@.microsoft.com...
>
>
|||Wozza,
Ok, as you're using Win2003 (Windows NT 5.2) and therefore using the
langwrbk.dll wordbreaker (vs. Win2K's infosoft.dll), you can search for the
three single letters using CONTAINS, for example: Note, the use of double
quotes to contain all single letters:
SELECT * FROM MyTable where CONTAINS(*,'"R.E.M"')
If you continue to get an error, then add back a single space character in
the noise.dat file under \FTDATA where SQL Server 2000 is installed and run
a Full Population, then re-run the above query.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Wozza" <Wozza@.discussions.microsoft.com> wrote in message
news:28143E7D-BA1E-47EE-9C86-CB95D4A428ED@.microsoft.com...[vbcol=seagreen]
> John,
> I have also cleared the Noise.dat file (my index set up to use the Neutral
> language).
> If I have done this ... how do I serach for "r.e.m." for instance.
> Warren
> "John Kane" wrote:
|||ok, I tried
SELECT * FROM Track where CONTAINS(*,'"R.E.M."')
and
SELECT * FROM Track where CONTAINS(*,'"R.E.M"')
and got the same error each time ...
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query contained
only ignored words.
... so I added a space to Noise.dat and am repopulating.
"John Kane" wrote:

> Wozza,
> Ok, as you're using Win2003 (Windows NT 5.2) and therefore using the
> langwrbk.dll wordbreaker (vs. Win2K's infosoft.dll), you can search for the
> three single letters using CONTAINS, for example: Note, the use of double
> quotes to contain all single letters:
> SELECT * FROM MyTable where CONTAINS(*,'"R.E.M"')
> If you continue to get an error, then add back a single space character in
> the noise.dat file under \FTDATA where SQL Server 2000 is installed and run
> a Full Population, then re-run the above query.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Wozza" <Wozza@.discussions.microsoft.com> wrote in message
> news:28143E7D-BA1E-47EE-9C86-CB95D4A428ED@.microsoft.com...
>
>

Pull data from different database server

Hi,

In my application i am storing the data in a database(server A). And i have a scenario where in a middle server(server B) is there in which i need to create a table and pull the data from one of the tables from my original database server(server A) into second database server(server B). Where can i get the code to write a job script which can connect from server B to server A and pull the data from the table and delete that data from the table in server A. Can any give me the code or link where i can find the code. Please help.

Thanks

If they are SQL Server databases you can create a DTS job to copy the tables and data. Or within you SQL, you can reference the other SQL server from the following

SELECT *FROM <serverName>.<ownerName>.<table>

Where the serverName is the other server, ownerName is the owner of the table you want to access.|||

There are 2 ways of doing this.

1) You can use Linked Server.

2) Use DTS or SSIS Packages to transfer data from one server and database to another.

Hope this will help.

|||

Hi,

Could you please tell me what are the steps i need to follow in order to pull the data by using Linker Server option. or else any site which has step by step details to work with linker server and pull the data.

Thanks

|||

If i user linked server and write a stored procedure to do my job, how can i schedule the script to work for every 5 min's. I want to pull pull the data for every 5 mins. Can i close the connection every time when i finish my job and reconnect again after 5 min's when i want to pull the data again. Please help

Thanks

|||

tgopi99:

If i user linked server and write a stored procedure to do my job, how can i schedule the script to work for every 5 min's. I want to pull pull the data for every 5 mins. Can i close the connection every time when i finish my job and reconnect again after 5 min's when i want to pull the data again.

You can schedule the SP to run at a regular interval using SQL Jobs. One more thing, if you use any of the features like Jobs or DTS or SSIS, they themselves manage the connections to the server and you don't need to worry about them.

Well, linked server is one of the options. Below is a link which can be useful for linked servers:

http://msdn.microsoft.com/msdnmag/issues/04/11/DataPoints/

But there is another way around, that is to create a DTS ( if you are using SQL Server 2000 ) or SSIS ( if you are using SQL Server 2005 ) package. If your purpose is to transfer data between 2 servers then you can achieve this by writing a DTS or SSIS.

Below are some links for creating and using DTS:

http://www.databasejournal.com/features/mssql/article.php/3579941

http://www.verio.com/support/documents/view_article.cfm?doc_id=3846

Below are some links for creating and using SSIS:

http://msdn2.microsoft.com/en-us/library/ms167031.aspx

http://aspalliance.com/947_Building_a_SQL_Server_2005_Integration_Services_Package_Using_Visual_Studio_2005

http://www.databasejournal.com/features/mssql/article.php/3503996

Hope the links are sufficient and helpful.