myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleBackup for SQL Server (2000, 2005, 2008, 2012) » Support Queries » Data Publishing Wizard

Data Publishing Wizard Options · View
Previous Topic · Next Topic
minessence
Posted: Sunday, December 20, 2009 12:03:47 AM
Rank: Newbie
Groups: Member

Joined: 12/19/2009
Posts: 2
Points: 6
Location: Australia
Can I use Microsoft's Data Publishing Wizard to script all objects in my SQL 2005 database to a .SQL file & then use this file to create all the object & data in my new SQL 2008 database using myLittleTools?
Back to top
 
elian
Posted: Tuesday, December 22, 2009 6:50:48 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Yes this is something you can do.
Even if the best solution would be that your hosting company provides myLittleBackup ( http://www.mylittlebackup.com )
Back to top
 
minessence
Posted: Tuesday, December 22, 2009 9:35:19 PM
Rank: Newbie
Groups: Member

Joined: 12/19/2009
Posts: 2
Points: 6
Location: Australia
elian wrote:
Yes this is something you can do.
Even if the best solution would be that your hosting company provides myLittleBackup ( http://www.mylittlebackup.com )


How do I execute the .sql file? I tried cutting & pasting the file con tents to myLittleTools query window but the file is 100mb & it didn't work?
Back to top
 
elian
Posted: Wednesday, December 23, 2009 7:40:11 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
100MB?!!
Do not waste your time it won't work...
The only solution is to restore a backup file. Contact your webhoster for that.
Back to top
 
Users browsing this topic
Guest

myLittleTools Community Forum » myLittleBackup for SQL Server (2000, 2005, 2008, 2012) » Support Queries » Data Publishing Wizard


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.