dbTalk Databases Forums  

Can I use SQL DB Publishing Wizard to transfer from SQL2005 to SQL

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools Can I use SQL DB Publishing Wizard to transfer from SQL2005 to SQL

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Can I use SQL DB Publishing Wizard to transfer from SQL2005 to SQL in the microsoft.public.sqlserver.tools forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM





Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
  #12  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM





Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
  #13  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM


Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
  #14  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM


Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
  #15  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM


Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
  #16  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM


Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
  #17  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM


Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
  #18  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM


Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
  #19  
Old   
Jason A Ash
 
Posts: n/a

Default Re: Can I use SQL DB Publishing Wizard to transfer from SQL2005 toSQL - 12-18-2008 , 07:37 PM


Excellent, thank you!

I'm going to give this a try tomorrow, in a test environment (thank you
MS for Hyper-V Server!)

Jason A.

Erland Sommarskog wrote:
Quote:
Jason A Ash (JasonAAsh (AT) discussions (DOT) microsoft.com) writes:
I have a DB that was put on a temporary server, which has SQL2005. I
need to transfer the DB back, but the original server is SQL2000 SP2. I
found a posting on another forum / newsgroup that seems to indicate that
the Microsoft SQL Server Database Publishing Wizard might work for this.
I realize that the SQL 2000 is behind a few service packs, and would
likely need to be updated, as well, this is not an issue.

Basicly, my question is, will this work? Will I be able to run this
utility, to move the DB, its associated views, etc, back to the SQL 2000
server?

I believe the Publishing wizard has an SQL 2000 mode, in which case
you should be fine, as long as you are not using features new in SQL 2005.

Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top