Migrate DTC

Hi guys,
I have an existing sql 2k enterprise server and we're going to configure it
for server clustering. We have custom made DTC package and most of the
application use it very often.
My concern is how do we migrate this custom made DTC package to the new
environment(sql cluster)?
Appreaciate ur guys help.
Hidayat
Message posted via http://www.droptable.com
I maybe missing something; due my true lack of understanding MSDTC, but I
don't think you have anything to migrate. MSDTC as far as I know, is just a
log file, and a new install will use a new log file. This should be a walk
in the park.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
"Hidayat via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:4FE03924D8C20@.droptable.com...
> Hi guys,
> I have an existing sql 2k enterprise server and we're going to configure
> it
> for server clustering. We have custom made DTC package and most of the
> application use it very often.
> My concern is how do we migrate this custom made DTC package to the new
> environment(sql cluster)?
> Appreaciate ur guys help.
> Hidayat
> --
> Message posted via http://www.droptable.com
|||tks for your prompt reply.
Another question i would like to ask is do we need different virtual ip for
MSDTC & SQL cluster? Can we use the existing virtual ip that we configure for
MSCS?
Tks
Message posted via http://www.droptable.com
|||If MSDTC has heavy usage then give it its own Group - with an Virtual IP,
Virtual Name, Physical Disk, and the MSDTC resource. If it is not a heavy
hitter, then don't worry about it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
"Hidayat via droptable.com" <forum@.droptable.com> wrote in message
news:4FE4339FB56C0@.droptable.com...
> tks for your prompt reply.
> Another question i would like to ask is do we need different virtual ip
> for
> MSDTC & SQL cluster? Can we use the existing virtual ip that we configure
> for
> MSCS?
> Tks
> --
> Message posted via http://www.droptable.com
|||Can the physical disk for MSDTC be the same(sharing) for the SQL cluster
physical disk?
In SQL cluster environment, how is the procedure of restoring the database?
Is it the same as normal SQL restore using it's own utility. As i know the
data will centrally reside in the SAN(EMC) storage.
Tks
Message posted via http://www.droptable.com
|||You can share the space. But if it is heavily used that maybe a bad idea.
Everything about a database is the same, restore, attach, etc. The Books
Online are wonderful and full of great information.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
"Hidayat via droptable.com" <forum@.droptable.com> wrote in message
news:4FE89EBC9A9E0@.droptable.com...
> Can the physical disk for MSDTC be the same(sharing) for the SQL cluster
> physical disk?
> In SQL cluster environment, how is the procedure of restoring the
> database?
> Is it the same as normal SQL restore using it's own utility. As i know the
> data will centrally reside in the SAN(EMC) storage.
> Tks
> --
> Message posted via http://www.droptable.com
|||Clustered SQL servers look and act just like normal SQL servers for amost
every purpose, including backup and restore. There are some extra steps for
things like restoring master, adding disks, and adding/dropping cluster
nodes but these are well documented. From the client's point of view, they
look and act exactly like any other SQL server.
Geoff N. Hiten
Microsoft SQL Server MVP
"Hidayat via droptable.com" <forum@.droptable.com> wrote in message
news:4FE89EBC9A9E0@.droptable.com...
> Can the physical disk for MSDTC be the same(sharing) for the SQL cluster
> physical disk?
> In SQL cluster environment, how is the procedure of restoring the
> database?
> Is it the same as normal SQL restore using it's own utility. As i know the
> data will centrally reside in the SAN(EMC) storage.
> Tks
> --
> Message posted via http://www.droptable.com
|||Tks for the explaination. Just to confirm with u guys. Let's say that i have
2 node(A & B). I install and configure SQL cluster on Node A. Must i install
the SQL cluster on Node B?
Message posted via http://www.droptable.com
|||Tks a million guys. Let's say that i have 5GB each on 2 servers. Should i
enabled /3GB or /PAE or AWE? What is u guys best recommendation. I'm going to
configure clustering this Saturday and will be in production.
This clustering is new to me so tks for your patient in answering my question.
U guys have been very helpful.
Tks.
Message posted via http://www.droptable.com
|||Great question. You need to 1) talk to you hardware vendor and find out if
/PAE or /AWE are even supported. 2) test the /3GB with whatever the vendor
supports, you may not see any difference or worse, things could get slower,
3) I am guessing you will only need /PAE to see the 5 GB of memory, but this
is a guess - testing will tell all.
Lastly, you are on a very aggressive schedule. It sounds like you need more
testing time to me BEFORE you go live. This being your first cluster, can
you restore it or a node in the case of a failure? Do you fully understand
how to handle service packs, etc. I am not trying to beat you up, you have a
learning curve ahead. After you in production is really not the way to
manage and maintain your Highly Available SQL Failover Cluster.
Just my two cents...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
"Hidayat via droptable.com" <forum@.droptable.com> wrote in message
news:4FF0A99441520@.droptable.com...
> Tks a million guys. Let's say that i have 5GB each on 2 servers. Should i
> enabled /3GB or /PAE or AWE? What is u guys best recommendation. I'm going
> to
> configure clustering this Saturday and will be in production.
> This clustering is new to me so tks for your patient in answering my
> question.
>
> U guys have been very helpful.
> Tks.
> --
> Message posted via http://www.droptable.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
|||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!
> >
>