Problem while using import/export wizard

I did use Import/Export wizard to convert MS-Access db into MS-SQL Server,
while doing so few of the tables were not converted and many of the tables
were blank.
What's the fix.
TIA
RAJ.
Any errors?
Have you tried fom Access side with the Upsize Wizard?
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"krisrajz" <krisrajz@.discussions.microsoft.com> wrote in message
news:DC16E7D0-9FE0-45A0-AAA0-92E891C8D596@.microsoft.com...
> I did use Import/Export wizard to convert MS-Access db into MS-SQL Server,
> while doing so few of the tables were not converted and many of the tables
> were blank.
> What's the fix.
> TIA
> RAJ.

Problem w/ SQL Server Database Wizard

I'm relatively new to VB.NET and Database programming, so I don't know a WHOLE lot about both, but I've recently purchased Wrox's "Beginning Visual Basic .NET Databases" and I've run into a snag on page 48.

The text says to fill in the Login ID and Password ("sa" and blank) on the first screen of the Microsoft SQL Server Database Wizard in Access, but when I do, I get an Overflow error. I get the same error if I try to Use Trusted Connection. I can't get past this screen.

I'm running Access 2000, and the SQL Desktop Engine 2000, and I don't have Enterprise Manager. Anyone know how to help me?

Please!!! Help me!!!Do you have latest service packs on SQL SErver and OFfice tools?|||No, I don't. Would I get those from Microsoft's site? (Damn, I hate navigating that website.)|||Hey, Satya, service pack 3 did the trick.

Thanks for the help.

Sean

Problem Using Copy Database Wizard in SSMS

I am having a problem copying a database on a server back to the same server
from a remote computer using SSMS. I have 2 remote computers (WinXP) running
SSMS on the same domain as the server. I log in as an administrative user on
both, but can only run the Copy Database Wizard successfully from one of the
remote computers.
On the computer that fails, it does so at the Create Package step and
returns an error message saying "No description found". Anyone have an idea
how I should begin troubleshooting this problem? I can not find anything in
the event logs on the remote system or server that sheds a clue, or in the
SQL server logs.
Don Sivitz (DonSivitz@.discussions.microsoft.com) writes:
> I am having a problem copying a database on a server back to the same
> server from a remote computer using SSMS. I have 2 remote computers
> (WinXP) running SSMS on the same domain as the server. I log in as an
> administrative user on both, but can only run the Copy Database Wizard
> successfully from one of the remote computers.
> On the computer that fails, it does so at the Create Package step and
> returns an error message saying "No description found". Anyone have an
> idea how I should begin troubleshooting this problem? I can not find
> anything in the event logs on the remote system or server that sheds a
> clue, or in the SQL server logs.
That's not an error that I've seen. Which method are you trying to use?
Direct copy of the files, or the SMO method?
There is a CTP of SP2 out, and Microsoft claims that there are a lot of
fixes to the Copy Database Wizard. I have not tested it myself, though,
yet. I don't really want to recommend you to install beta software, but
if you are desperate you can try it.
However, there plenty of other ways of achieving what the wizard does,
so you may want to explore those options instead.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx