|
Home > Archive > Microsoft Content Management Server > July 2005 > Dynamic migration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Is there a way to automatically move content from a standalone SQL db into
MCMS postings?
My company will soon be moving our static ASP site into MCMS 2002. Part of
our current site offers access to a large SQL db that holds nearly 70,000
article abstracts. Rather than create a sparate CMS posting using a
copy-and-past technique I'm hoping we can migrate all of the abstracts
through some sort of export/import or batch process. We have a few other
databases that we would like to migrate as well, all of which are in MS
Access.
Thanks in advance for any insights.
| |
| AC [MVP MCMS] 2005-07-27, 2:48 am |
| You bet!!! In fact, that's how we migrated all of our content on our sites
(all the content we could move).
I included a script in my MCMS talk at the recent Tampa Code Camp. You can
download it here:
http://andrewconnell.com/blog/archi...07/18/1756.aspx
In the ZIP that's linked, you will see something named
"CreatePostingCode.cs". If I remember correctly, there may have been a typo,
but it should get you far enough along to see how it works. Pretty easy!!!!
--
----------------------------------------
-AC [MVP MCMS]
www.andrewconnell.com
www.andrewconnell.com/mvp
"nick" <nick@discussions.microsoft.com> wrote in message
news:06C763F0-ACDC-4293-A841-1BD0DD084E64@microsoft.com...
> Is there a way to automatically move content from a standalone SQL db into
> MCMS postings?
>
> My company will soon be moving our static ASP site into MCMS 2002. Part of
> our current site offers access to a large SQL db that holds nearly 70,000
> article abstracts. Rather than create a sparate CMS posting using a
> copy-and-past technique I'm hoping we can migrate all of the abstracts
> through some sort of export/import or batch process. We have a few other
> databases that we would like to migrate as well, all of which are in MS
> Access.
>
> Thanks in advance for any insights.
| |
|
|
Wow thank you so much.
I'm the Web team manager for our company. I have basic coding skills in ASP,
JS, HTML, CSS, and I have two developers with mutch more experience in the
same areas. What advice as far as training would you recommend for our team
in terms of ASP.NET and utilizing MCMS? What version of Visual Studio should
we be looking at?
"AC [MVP MCMS]" wrote:
> You bet!!! In fact, that's how we migrated all of our content on our sites
> (all the content we could move).
>
> I included a script in my MCMS talk at the recent Tampa Code Camp. You can
> download it here:
> http://andrewconnell.com/blog/archi...07/18/1756.aspx
| |
| AC [MVP MCMS] 2005-07-29, 2:48 am |
| First, I'd get Visual Studio .NET 2003Professional.
If you haven't picked up ASP.NET or any of the .NET technologies, I'd look
at the higest rated books for ASP.NET on Amazon.
Finally, for MCMS, there's no better place to start than:
http://www.amazon.com/exec/obidos/A...3&link_code=as1
--
----------------------------------------
-AC [MVP MCMS]
www.andrewconnell.com
www.andrewconnell.com/mvp
"nick" <nick@discussions.microsoft.com> wrote in message
news:02298846-3840-442E-9E49-4164C1092803@microsoft.com...
>
> Wow thank you so much.
>
> I'm the Web team manager for our company. I have basic coding skills in
> ASP,
> JS, HTML, CSS, and I have two developers with mutch more experience in the
> same areas. What advice as far as training would you recommend for our
> team
> in terms of ASP.NET and utilizing MCMS? What version of Visual Studio
> should
> we be looking at?
>
> "AC [MVP MCMS]" wrote:
>
>
| |
| Angus Logan [MVP] 2005-07-29, 8:07 am |
| You could try what Andrew said but you may also want to consider some
targetted class room training that would only cover very high level .NET
concepts and the actual code that would be required for MCMS.
ie. using the MCMS Publishing API (PAPI);
basic ASP.NET concepts such as Web Forms, User controls, Server Controls
etc.
Regards
--
________________________________________
Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
Product Specialist
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
________________________________________
"nick" <nick@discussions.microsoft.com> wrote in message
news:02298846-3840-442E-9E49-4164C1092803@microsoft.com...
>
> Wow thank you so much.
>
> I'm the Web team manager for our company. I have basic coding skills in
> ASP,
> JS, HTML, CSS, and I have two developers with mutch more experience in the
> same areas. What advice as far as training would you recommend for our
> team
> in terms of ASP.NET and utilizing MCMS? What version of Visual Studio
> should
> we be looking at?
>
> "AC [MVP MCMS]" wrote:
>
>
| |
|
| You might also want to look at the following book, which also has code
samples for programmatic migration of content from SQL (or any data
source) to MCMS.
(since Andrew shamelessly plugged his book, I felt better about doing
the same)
http://www.amazon.com/exec/obidos/t...=books&n=507846
AC [MVP MCMS] wrote:[vbcol=seagreen]
> First, I'd get Visual Studio .NET 2003Professional.
>
> If you haven't picked up ASP.NET or any of the .NET technologies, I'd look
> at the higest rated books for ASP.NET on Amazon.
>
> Finally, for MCMS, there's no better place to start than:
> http://www.amazon.com/exec/obidos/A...3&link_code=as1
>
> --
> ----------------------------------------
> -AC [MVP MCMS]
> www.andrewconnell.com
> www.andrewconnell.com/mvp
>
>
> "nick" <nick@discussions.microsoft.com> wrote in message
> news:02298846-3840-442E-9E49-4164C1092803@microsoft.com...
|
|
|
|
|