Google Groups Home
Help | Sign in
microsoft.public.access.sqlupsizing
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Access to SQL2K5 - Selective Migration...
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   3 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Subbu  
View profile
  More options Jul 21, 5:42 am
Newsgroups: microsoft.public.access.sqlupsizing
From: Subbu <Su...@discussions.microsoft.com>
Date: Mon, 21 Jul 2008 02:42:00 -0700
Subject: Access to SQL2K5 - Selective Migration...
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Hi all,

I need to migrate Access tables to SQL Server 2005 (Structure and Data), but
only the selected ones and not all the tables from the access mdb.
Q1) What is a good way of doing this?
Q2) Any method that would allow me to reuse it later on, for example create
a script or something that would do the migration?
Q3) How best can SSIS be used here?

Thanks a lot
- Subbu
============


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Stefan Hoffmann  
View profile
  More options Jul 21, 7:12 am
Newsgroups: microsoft.public.access.sqlupsizing
From: Stefan Hoffmann <stefan.hoffm...@explido.de>
Date: Mon, 21 Jul 2008 13:12:04 +0200
Local: Mon, Jul 21 2008 7:12 am
Subject: Re: Access to SQL2K5 - Selective Migration...
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
hi,

Subbu wrote:
> I need to migrate Access tables to SQL Server 2005 (Structure and Data), but
> only the selected ones and not all the tables from the access mdb.
> Q1) What is a good way of doing this?

Using the built-in wizard in Access was always sufficent for me.

> Q2) Any method that would allow me to reuse it later on, for example create
> a script or something that would do the migration?
> Q3) How best can SSIS be used here?

You may take a look at

http://www.microsoft.com/sql/solutions/migration/default.mspx

mfG
--> stefan <--


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brent Spaulding (datAdrenaline)  
View profile
  More options Jul 30, 8:16 am
Newsgroups: microsoft.public.access.sqlupsizing
From: "Brent Spaulding \(datAdrenaline\)" <datadrenal...@sbcglobal.net>
Date: Wed, 30 Jul 2008 07:16:46 -0500
Local: Wed, Jul 30 2008 8:16 am
Subject: Re: Access to SQL2K5 - Selective Migration...
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
I like to do thing like this outside of wizard, so ... check out this thread
on utteraccess I participated in a while back.  It has a procedure in it
that you can use to more just one table ...

http://www.utteraccess.com/forums/showflat.php?Number=1639193&fpart=a...

--
Brent Spaulding | datAdrenaline | Access MVP

"Subbu" <Su...@discussions.microsoft.com> wrote in message

news:3F5C406D-7775-4CCD-BE64-582DCD99921A@microsoft.com...


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google