Migrating from Enterprise to SQL Server 2000 Standard

We are migrating a browser based application developed
with the Enterprise version to a server running the
standard edition. There will be some development on the
standard version before a new vresion of the application
is deployed. Can anyone help me to understand what
issues/problems we should look out for?Since most of the difference between Standard Edition and Enterprise Edition
involves scalability and availability features (>4 processors, large memory
support, clusters) there generally will be no problems migrating
applications from Enterprise to Standard. The few small gotchas include
Transparent Materialized Views and Distributed Partitioned Views, both of
which are only included in Enterprise Edition. (For completeness, Analysis
Services has some similar differences between Standard and Enterprise). If
you have not used these few scalability-related features then you will not
notice application level differences between these editions.
See "Features Supported by the Editions of SQL Server 2000" in Books Online.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"rez" <rezam@.go.com> wrote in message
news:039601c37bc5$bda02a30$a401280a@.phx.gbl...
> We are migrating a browser based application developed
> with the Enterprise version to a server running the
> standard edition. There will be some development on the
> standard version before a new vresion of the application
> is deployed. Can anyone help me to understand what
> issues/problems we should look out for?

Migrating Crystal Reports from 8x to 11x

Hi All,

I have an application in Crystal Report 8x version which needs to be migrated to 11x. Also assume that the Database is also changing. Maybe from one server to another server or one RDBMS to other RDBMS.

My questions are as follows.

1. How to migrate from version 8.x to 11.x, what are all the steps?
2. How to do database changes in the Crystal Reports?
3. Is there any client version for Crystal Reports? If so, how to view that and what are all the changes in the client version that needs to be done.
4. How do we access the crystal reports externally where we don't install the software? Is there any external components that will be used? If so, what is that?

Kindly clarify me the above questions ASAP.See if you find answer here
www.Businessobjects.com|||Hi,

Can you be more specific about how your reports are currently deployed? I'm moving Crystal 8 reports deployed in ASP using the Web Component Server to ASP using RAS (Report Application Server). The steps are as follows:

Open the version 8 report in 10 and save as a 10 report

Rewrite the ASP to call the report using RAS

Currently I'm running 8 and 10 on the same server and am migrating one report at a time, because the newer versions of Crystal will run side-by-side with previous versions.......of course you want to test that carefully before deploying both versions on a production server!

Changing the database "shouldn't" be a big deal, depending again on what you end up with. I go to set location inside the report designer and handle it there. If you change RDBMS' and your table/field names change, you may as well plan on rewriting the reports.

Hope that helps!

Linda

Migrating a db from SSE 2005 December CTP to SSE 2005 Release Version

I have a developer who built an application using the SSE 2005 December CTP and I would like to bring the db's into the official SSE 2005 released version. I have attempted the following:

1. Create the db's in the released version, detach and re-attach the CTP db's. I got an error telling me they were incompatible.

2. Installed CTP version on one server, backed up the db's and then attempted to restore the db's on another server running the official released version of SSE 2005. Got an error attempting that too.

3. Installed the Management Studio for SS 2005 Developer edition thinking that I could connect to the two seperate instances of each server and like I could in EM 2000 run the transfer wizard to move the db's and data from one server to the next. Problem with this is that I can't get an object browser connection established. I have TCP/IP all config'd correctly, too.

Any other ideas where I can go with this at this time?

Thanks in advance.

Bill

Often the easiest way to move databases is to do a Backup and Restore.|||

As you can see from # 2 of my attempts at this, that didn't work. Actual error was:

Database 'xyz' cannot be upgraded because its non-release version (590) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. (.Net SqlClient Data Provider)

|||

December CTP of what year? 590 is a pre-RTM version of SQL Server from well over a year ago. There is no way to upgrade this database to the current SP2 version, in fact I don't believe you could even open this database in RTM. The only way to move this database would be to go back to the version where it was created, script the database out to T-SQL and run the scripts on a released version of SQL Server.

Mike

sql

Migrating a db from SSE 2005 December CTP to SSE 2005 Release Version

I have a developer who built an application using the SSE 2005 December CTP and I would like to bring the db's into the official SSE 2005 released version. I have attempted the following:

1. Create the db's in the released version, detach and re-attach the CTP db's. I got an error telling me they were incompatible.

2. Installed CTP version on one server, backed up the db's and then attempted to restore the db's on another server running the official released version of SSE 2005. Got an error attempting that too.

3. Installed the Management Studio for SS 2005 Developer edition thinking that I could connect to the two seperate instances of each server and like I could in EM 2000 run the transfer wizard to move the db's and data from one server to the next. Problem with this is that I can't get an object browser connection established. I have TCP/IP all config'd correctly, too.

Any other ideas where I can go with this at this time?

Thanks in advance.

Bill

Often the easiest way to move databases is to do a Backup and Restore.|||

As you can see from # 2 of my attempts at this, that didn't work. Actual error was:

Database 'xyz' cannot be upgraded because its non-release version (590) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. (.Net SqlClient Data Provider)

|||

December CTP of what year? 590 is a pre-RTM version of SQL Server from well over a year ago. There is no way to upgrade this database to the current SP2 version, in fact I don't believe you could even open this database in RTM. The only way to move this database would be to go back to the version where it was created, script the database out to T-SQL and run the scripts on a released version of SQL Server.

Mike

Migrate subset of data from 2000 to 2005

First a little background.

Production server is SQL Server 2000. Various clients will be installing a desktop version of our web application. The desktop app will be running SQL Server 2005 Express (MSDE replacement, correct?). When the client downloads the package, the installer will import their data from the SQL Server 2000 production database into the SQL Server 2005 database. The production database contains numerous clients, so it doesn't make sense to migrate ALL of the data, only the data that belongs to the client.

My question is what method(s) would allow this to be done? The databases will NOT be connected to one another so using DTS packages is not an option.

After doing some research I came to the conclusion that the only way I could see this working, would be to output each tables data (just the data that belongs to the particular client) into its own text file and then import them individually on the SQL Server 2005 side.

Does anyone have any other ideas?

Kevin - I have the same dilemma currently and wondered if you had found a solution to this?

Migrate Higher version of MDAC

Hi Friends,

I have a system with windows 2000 advanced server SP4 OS. In that system, How can i upgrade MDAC version from 2.5 to 2.8 sp2.

This is use of,

I am going to install sql server 2005 express edition advanced services SP2.

Please help me, how can i upgrade higher version of MDAC?

Thanks in Advance

Rameshkumar Thirumalaisamy

You just download the version you want from the Microsoft Download Center and install it. I believe that MDAC 2.8 is currently at SP1, not SP2 as you've indicated. You can find MDAC 2.8 SP1 here.

Mike

|||

Actually, if you install the SQL Server 2005 on the machine you can connect using the SNAC provider instead of using the MDAC stack. Although you should be up-to-date in the case another application needs parts of the MDAC stack.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

When installing SQL Server 2005 (any edition) on Windows 2000 there actually is a minimum version of MDAC that is required, although I can't recall what version is required, but 2.8 SP1 will certainly qualify since it's the newest. I don't know why this requirement exists only on Windows 2000.

Mike

Migrate Higher version of MDAC

Hi Friends,

I have a system with windows 2000 advanced server SP4 OS. In that system, How can i upgrade MDAC version from 2.5 to 2.8 sp2.

This is use of,

I am going to install sql server 2005 express edition advanced services SP2.

Please help me, how can i upgrade higher version of MDAC?

Thanks in Advance

Rameshkumar Thirumalaisamy

You just download the version you want from the Microsoft Download Center and install it. I believe that MDAC 2.8 is currently at SP1, not SP2 as you've indicated. You can find MDAC 2.8 SP1 here.

Mike

|||

Actually, if you install the SQL Server 2005 on the machine you can connect using the SNAC provider instead of using the MDAC stack. Although you should be up-to-date in the case another application needs parts of the MDAC stack.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

When installing SQL Server 2005 (any edition) on Windows 2000 there actually is a minimum version of MDAC that is required, although I can't recall what version is required, but 2.8 SP1 will certainly qualify since it's the newest. I don't know why this requirement exists only on Windows 2000.

Mike

Migrate from SQL Server 2005 to MS Access 2000

I need to migrate some tables from a SQL Server 2005 full version (trial) database to a MS Access 2000 database. The situation is that a search program is available online (with SQL Server database) and also as a CD based desktop version ( that uses MS Access 2000). I have made corrections to the text contents of the online SQL Server DB and would like to make a MS Access 2000 database version for desktop application, rather than have to manually make the hundreds of corrections again in the MS Access DB. Is this type of migration possible? If so, where do I begin. I tried the export function in SQL Server but there is no option for the type of migration I need. Thanks for any help you can provide.I suggest using SQlExpress or SQl Everywhere on the client rather than this old version of Acccess however, Integration Services should be able to do it, is there an error?|||

Euan: Thanks for your help. I researched Integration Services and did the migration successfully by exporting from SQL Server Management Studio. I am dealing with a legacy desktop search program that only uses MS Access and needed to update some data from a new SQL online database version.

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

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

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

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

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

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

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate Database from SQL Server 2005 beta 3 to Sql Server 2005 Release

Do you now, How can I move database with datas to release version of sql server?
Procedores backup/restore can't help becouse of unsuported version database.

Any ideas?What about generate a schema script? Then run an install of your schema in a new query. You could at least get the db schema but not the data.|||but I have many datas

Migrate AS2005 Cube to New Version of Source DB

Is it possible -- and how straightforward is it -- to migrate an existing AS2005 Cube (and/or at least it's dimensions) to an updated version of my source DB (SQL 2005)? I had little choice but to establish a "dev-and-test" version of the source DB during enhancements that coincided with production analysis and reporting. Now that I've approved the "dev-and-test" version, I want to make it our production master for OLAP.

As a note, I don't believe that any of the fields used in the cube have been modified. We've just added some new calculated fields (and sp's).

I have little idea of whether this will be simple, hard or impossible. I'm planning to try, but wanted expert feedback first.

There is a feature in BI Dev Studio specifically designed for the scenario you describe.

Open up your DSV and right click on the empty space anywhere. Select a "Refresh" option.

At this moment BI Dev Studio connects to the relational database and verifies if all the tables and all the coluns you build your Analysis Services objects upon are there. If it detects any changes in the relational database it will give you the list of the objects and will ask you if you would like that BI Dev studio will fix them for you automatically.
If the case is simple, just go ahead. If you see lots of changes, you save the list and try to takle every problem separately.

Hope that helps.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Yes, the DSV refresh will help. However, just to clarify my situation...

I need to disconnect an existing cube away from it's source DB and connect it to a new database, (which is a modified, renamed copy of the original), not just refresh the DSV connection after some mods.

Two questions:

(1) In light of my situation,then prior to following your guidance above, would it work for me to (1st b/u everything, then) restore the new database into/overwriting the old database?

(2) Is there a better way involving DB file renaming, etc.? (Specifically, I'm looking for alternatives to re-building my cube and/or dimensions.)

I think I'm half way to resolving this problem. Thank you, Edward!

|||

Again, DSV refresh not only going to synchronize your DSV with relational database, it also checks and changes properties of attributes and measures. You should try it to see what it does for you and if it works.

Make a copy of your database and try your experiments on the copy.

You can also make backup of your database and then resore it with different name.

You can script your database Create script and modify the script to change the database name and ID.

You have quite a few options here. I suggest you just try and few and see what works.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward. Your replies are illuminating and helpful.

In light of a new SSIS package connected to the new "dev-and-test" db, I'd like to inquire about simply changing the data source for an existing AS2005 cube, but will start a new thread on that subject.

Migrate Access 2002 to SQL Express 2005

Hello
I'm trying to migrate my access mdb (XP version) to SqlExpress 2005. I use Updating wizzard from Access and i get an error saying that my sql server is not compatible and that i have to use SQL 6,5 SP 5 or later. What i'm doing wrong?The best way to migrate your data would be to use the new integration services in sql server 2005. However, I'm not sure what Express edition offers in this way.|||I believe that you are right but this feature is not supported in SQL Express
Thanks|||Well you can download demo version of the full sql server 2005. Perhaps you should look at purchasing the developer version or an MSDN subscription to get the tools you need.|||This is possible but not in the default configuration. See the blog post at http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx for more info on how to configure to do this. Thanks< MJ

Migrate / Read Access data file(s) in SQL Server

Dear Experts,
I have some Access .mde files from a custom application.
The runtime version of Access is 2002. I don't have
a developer's version of Access. I also don't have the
schema design of the app.
I'd like to import or migrate the data file into SQL Server
schemas (databases) somehow. Or, another database
like Oracle.
Is it possible to do this from SQL Server?
What is the buzzword that I can search on?
Is there a link you can forward?
Thanks a lot!
Migrating Access databases to SQL Server can be done different ways from
both sides. Also, depending on the version of SQL Server that you target you
can use different tools too.
Here are a few links that will give you a good start:
SQL Server Migration Assistant for Access (for migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
Moving Your Access 2002 Database to SQL Server 2000 (look at the Data
Transformation Services section for importing Access data to SQL Server):
http://msdn2.microsoft.com/en-us/library/aa902657(SQL.80).aspx
How to use the Upsizing wizard in Access 2002:
http://support.microsoft.com/default.aspx/kb/330468
Access 2002 Upsizing Tools white paper:
http://support.microsoft.com/default.aspx/kb/294407
In the past I have used many times the Data Transformation Services in SQL
Server 2000 to import data from Access databases and it has been working
very well. Recently I used the SQL Server Import and Export Wizard in SQL
Server 2005 to import a few tables from .mde files and no problems there
too.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
|||I tried the simplest method I could. In SQL 2000, using enterprise manager,
I imported the mde. In source, I chose the Access type. I then chose the
file (after changing the file filter from *.mdb to all files). After
accepting the SQL Server data source, I checked all of the tables in the mde.
The import wizard created my tables and imported the data.
Russel Loski, MCSD.Net
"dba_222@.yahoo.com" wrote:

> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>
|||<dba_222@.yahoo.com> wrote in message
news:1169516295.667810.162270@.51g2000cwl.googlegro ups.com...
> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>
|||you should use DTS or something similiar in order to import all of your
Access Databases into SQL Server
"la playa mas bella" <thepadrino_1@.hotmail.com> wrote in message
news:eSt2kaXgHHA.588@.TK2MSFTNGP06.phx.gbl...
> <dba_222@.yahoo.com> wrote in message
> news:1169516295.667810.162270@.51g2000cwl.googlegro ups.com...
>

Migrate / Read Access data file(s) in SQL Server

Dear Experts,
I have some Access .mde files from a custom application.
The runtime version of Access is 2002. I don't have
a developer's version of Access. I also don't have the
schema design of the app.
I'd like to import or migrate the data file into SQL Server
schemas (databases) somehow. Or, another database
like Oracle.
Is it possible to do this from SQL Server?
What is the buzzword that I can search on?
Is there a link you can forward?
Thanks a lot!Migrating Access databases to SQL Server can be done different ways from
both sides. Also, depending on the version of SQL Server that you target you
can use different tools too.
Here are a few links that will give you a good start:
SQL Server Migration Assistant for Access (for migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/soluti...ss/default.mspx
Moving Your Access 2002 Database to SQL Server 2000 (look at the Data
Transformation Services section for importing Access data to SQL Server):
http://msdn2.microsoft.com/en-us/library/aa902657(SQL.80).aspx
How to use the Upsizing wizard in Access 2002:
http://support.microsoft.com/default.aspx/kb/330468
Access 2002 Upsizing Tools white paper:
http://support.microsoft.com/default.aspx/kb/294407
In the past I have used many times the Data Transformation Services in SQL
Server 2000 to import data from Access databases and it has been working
very well. Recently I used the SQL Server Import and Export Wizard in SQL
Server 2005 to import a few tables from .mde files and no problems there
too.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||I tried the simplest method I could. In SQL 2000, using enterprise manager,
I imported the mde. In source, I chose the Access type. I then chose the
file (after changing the file filter from *.mdb to all files). After
accepting the SQL Server data source, I checked all of the tables in the mde
.
The import wizard created my tables and imported the data.
--
Russel Loski, MCSD.Net
"dba_222@.yahoo.com" wrote:

> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>|||<dba_222@.yahoo.com> wrote in message
news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>|||you should use DTS or something similiar in order to import all of your
Access Databases into SQL Server
"la playa mas bella" <thepadrino_1@.hotmail.com> wrote in message
news:eSt2kaXgHHA.588@.TK2MSFTNGP06.phx.gbl...
> <dba_222@.yahoo.com> wrote in message
> news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
>

Migrate / Read Access data file(s) in SQL Server

Dear Experts,
I have some Access .mde files from a custom application.
The runtime version of Access is 2002. I don't have
a developer's version of Access. I also don't have the
schema design of the app.
I'd like to import or migrate the data file into SQL Server
schemas (databases) somehow. Or, another database
like Oracle.
Is it possible to do this from SQL Server?
What is the buzzword that I can search on?
Is there a link you can forward?
Thanks a lot!Migrating Access databases to SQL Server can be done different ways from
both sides. Also, depending on the version of SQL Server that you target you
can use different tools too.
Here are a few links that will give you a good start:
SQL Server Migration Assistant for Access (for migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
Moving Your Access 2002 Database to SQL Server 2000 (look at the Data
Transformation Services section for importing Access data to SQL Server):
http://msdn2.microsoft.com/en-us/library/aa902657(SQL.80).aspx
How to use the Upsizing wizard in Access 2002:
http://support.microsoft.com/default.aspx/kb/330468
Access 2002 Upsizing Tools white paper:
http://support.microsoft.com/default.aspx/kb/294407
In the past I have used many times the Data Transformation Services in SQL
Server 2000 to import data from Access databases and it has been working
very well. Recently I used the SQL Server Import and Export Wizard in SQL
Server 2005 to import a few tables from .mde files and no problems there
too.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||<dba_222@.yahoo.com> wrote in message
news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>|||you should use DTS or something similiar in order to import all of your
Access Databases into SQL Server
"la playa mas bella" <thepadrino_1@.hotmail.com> wrote in message
news:eSt2kaXgHHA.588@.TK2MSFTNGP06.phx.gbl...
> <dba_222@.yahoo.com> wrote in message
> news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
> > Dear Experts,
> >
> > I have some Access .mde files from a custom application.
> >
> > The runtime version of Access is 2002. I don't have
> > a developer's version of Access. I also don't have the
> > schema design of the app.
> >
> > I'd like to import or migrate the data file into SQL Server
> > schemas (databases) somehow. Or, another database
> > like Oracle.
> >
> > Is it possible to do this from SQL Server?
> > What is the buzzword that I can search on?
> > Is there a link you can forward?
> >
> > Thanks a lot!
> >
>

Microsoft's Connectivity White Paper is officially published

Hello All!

Many of you have seen the draft version, but we finally have it out the door. You can download the new version directly from Microsoft's official site.

The momentum in our connecitivty wiki is growing! so check back and see if you can get useful information on 64bit, Office 2007 connecitivity, and samples.

Some of the recent activity in our connectivity portal:

***************

The new connectivity white paper is now officially available, click here (http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc) to download.

***************

There's a new article from Deniz Erkan on Office 2007 Connectivity (Data Sources/Microsoft Office (2007)).

***************

Bob Beauschemin provided us a sample package to connect to Excel 2007.

***************

Microsoft's Partner ETI has a new separate page for connectivity offerings for SSIS (Data Sources/ETI High Performance Data Integration).

***************

Microsoft's Partner Persistent (Data Sources/Persistent Systems Products for SSIS) has put together a list of options for SSIS connectivity.

********************************************************************

The link to the official Microsoft's official site is broken, it displays a white page and no download, i use I.E. 6.

http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc

Philippe

|||

Philippe wrote:

The link to the official Microsoft's official site is broken, it displays a white page and no download, i use I.E. 6.

http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc

Philippe

Works great for me. Firefox and IE 6|||I tried again, it worked.

Microsoft’s SQL Server Version support

Does anybody no where Microsoft publishes a listing of supported SQL Server versions with final support dates?

Thanks,

Dave

Here you go:

http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=sql+server&x=8&y=10

Peter

Microsoft.VC80.CRT.mui

I have SQL 2005, 64bit version installed with SP1. I am seeing the following
errors in the Windows event log:
Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.
Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.
Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.
Does anyone know what the problem is?
Thanks
--
LehrSJHello LehrSJ,
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you'd like to know what this problem is.
Based on my experience, this issue could occur if the "Performance Logs and
Alerts" service runs as "Network Service", which is member of "Performance
Log Users" local user group, does not have enough permission to SQL setup
folder.
SQL Setup grants read/execute permissions to "Performance Log Users" local
user group for the DLL only. "Performance Log Users" doesn?t have any
permissions for the containing folder. Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory) may fix this problem:
D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
If you have any update or the issue is not resolved, please feel free to
let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks. That solved the problem.
--
LehrSJ
""privatenews"" wrote:
> Hello LehrSJ,
> I understand that you found some SQL related events on a SQL 2005 SP1 64bit
> server, and you'd like to know what this problem is.
> Based on my experience, this issue could occur if the "Performance Logs and
> Alerts" service runs as "Network Service", which is member of "Performance
> Log Users" local user group, does not have enough permission to SQL setup
> folder.
> SQL Setup grants read/execute permissions to "Performance Log Users" local
> user group for the DLL only. "Performance Log Users" doesnâ't have any
> permissions for the containing folder. Granting "List folder contents"
> permission to "Performance Log Users" for the containing folder (SQL Server
> binn directory) may fix this problem:
> D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
> D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
> If you have any update or the issue is not resolved, please feel free to
> let's know. I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||I was having this problem as well on a 32 bit system and that fixed it.
Can you explain why that fixed it? I'm asking because I was also having
2 other problems that I think this fixed as well.
first one: There is a Java program that inserts updates and deletes
records in a very large table on the sql server. It spawns 12 processes
that each have a connection to the DB and every time this program ran,
2 of them would hang up and would not receive any errors. I looked and
they were no longer connected.
second one: The users of this server have pocket pcs that connect using
sql ce server with RDA. They use an app that we wrote to replicate
their data. Along with all the pushing and pulling of tables, there is
one stored procedure that the client runs on the server. Apparently
randomly this stored procedure stops working for about 30 minutes at a
time. What happens on the client is when it calls that sp, it just
hangs there maintaining it's connection until all the sudden the sp
start working again. During the 30 minutes nobody can run the sp.
Both of these problems did not exist before we got Error 59 or after it
was fixed.
Does anybody have any clue as to why this would fix these 2 problems or
has anybody experienced anything like this?
thanks,
cob