How to migrate the Access database to MOSS 2007 sql server with the use of SSMA (sql server migratio

Posted by pointlesspolitics on Stack Overflow See other posts from Stack Overflow or by pointlesspolitics
Published on 2010-03-23T14:18:44Z Indexed on 2010/03/23 14:23 UTC
Read the original article Hit count: 280

Filed under:

sharepoint

|

moss

|

2007

|

sql

|

server

Hi,

One of my friends got the access database with Forms (VBA) and wish to migrate all the database table to the newly installed MOSS 2007 site.

He is using SSMI for this purpose. He cannot do it because there are plenty of errors and warnings. I think it is due to the old Access queries.

Is there any other way to import the database to sql 2005 from access ?

Thanks

© Stack Overflow or respective owner

Related posts about sharepoint

SharePoint 2010 MSDN Labs

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Eric Ligman, from Microsoft, posted a great blog post this week listing all of the SharePoint 2010 Virtual Labs that are available from Microsoft. His blog entry is here: http://blogs.msdn.com/b/mssmallbiz/archive/2012/03/13/sharepoint-server-2010-msdn-virtual-labs-available-to-you-online-plus-more-sharepoint-2010-resources… >>> More
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hos

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hosting, Michigan Sclera, a Microsoft Hosted Services Provider Partner, is offering key Service Offerings around the Microsoft SharePoint Server 2010 stack. Specifically – if you’re looking for SharePoint… >>> More
SharePoint Personalization Site Links - Les liens personnalis?s des MySite SharePoint

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Nous avons vu dans les articles pr?c?dents comment agr?menter les pages de recherche afin de permettre une meilleure adoption du produit par les utilisateurs. Il existe une autre fonctionnalit? de Microsoft Office SharePoint Server 2007 (MOSS) qui permet aussi de personnaliser un peu le MySite des… >>> More
Auditer une ferme SharePoint - Assurer le bon fonctionnement de SharePoint

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Dans le cadre de la bonne gestion de son environnement SharePoint, il est utile de faire un contr?le de son installation afin d'assurer le bon fonctionnement des fermes et donc, la meilleure disponibilit? pour les usagers. Dans ce but, nous verrons comment auditer sa ferme facilement et les traitements… >>> More
Using jQuery and SPServices to Display List Items

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I had an interesting challenge recently that I turned to Marc Anderson’s wonderful SPServices project for. If you haven’t already seen or used SPServices, please do. It’s a jQuery library that does primarily two things. First, it wraps up all of the SharePoint web services in a nice little AJAX wrapper… >>> More

Related posts about moss

Am?lioration du Search MOSS: synonyme et Best Bet - La gestion des synonymes dans MOSS Search

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Le moteur de recherche de MOSS permet la configuration d'une liste de synonymes. Nous verrons donc dans cet article comment effectuer cette tache et ce que cela peut apporter ? vos utilisateurs. Nous verrons aussi comment automatiser un peu plus cette configuration par l'utilisation de code ou d'outils… >>> More
Utiliser un MOSS 2007 Search avec SPS 2003 - Comment utiliser un MOSS Search avec SPS Portail

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Microsoft Office SharePoint Server 2007 (MOSS) fournit de nombreuses fonctionnalit?s qui ne sont pas disponibles sous SharePoint Portal Server 2003 (SPS). C'est particuli?rement vrai pour le moteur de recherche. Ce moteur de recherche peut pourtant ?tre utilis? sans attendre une ?volution du site… >>> More
MOSS - Mon Profil - Personnalisation des profils utilisateurs de MOSS

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
La gestion des profils utilisateurs de SharePoint fait partie des fonctionnalit?s de base de Microsoft Office SharePoint Server (MOSS). Nous verrons dans cet article comment ajouter de nouveaux champs ? ceux d?j? disponibles. >>> More
Search MOSS : Advanced Scopes - La gestion avanc?e des Scopes dans MOSS Search

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Le moteur de recherche de SharePoint 2007 est tr?s puissant dans sa configuration. Nous avons vu dans un pr?c?dent article la configuration et l'utilisation d'un scope. Nous pouvons aller encore plus loin dans cette cr?ation et c'est le sujet de cet article. >>> More
Cannot access MOSS site from within MOSS server

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to access my MOSS site through the browser on the web server itself. I am using the same URL that is used for external access to the site. When I hit it from outside the server, I can see most of the site, which has anonymous access, and can use a domain account to get into secure areas… >>> More