Getting stored procedures and permissions from 6.5 to 7.0

I am trying import my database from Sql Server 6.5 to 7.0 and can only
seem to get the tables.
I am using DTS and I can transfer the tables fine, but there doesn't
seem to be an option to move the other objects. There is a third button
that copies data between 7.0 databases, but that is greyed out since I
am coming from a 7.0 database.
There is a query button, but I don't how that would help me.
Thanks,
Tom.> I am trying import my database from Sql Server 6.5 to 7.0 and can only
> seem to get the tables.
> I am using DTS and I can transfer the tables fine, but there doesn't
> seem to be an option to move the other objects. There is a third
> button that copies data between 7.0 databases, but that is greyed out
> since I am coming from a 7.0 database.
You have to script your other objects to T-SQL script, but keep in mind that
your 6.5 stored procedures may need changing to work correctly in 7.0. You
may want to read in addition to above:
INF: Frequently Asked Questions - SQL Server 2000 - Upgrade
http://support.microsoft.com/defaul...b;en-us;q261334
INF: How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000 (White Paper)
http://support.microsoft.com/defaul...b;en-us;Q322620
SQL Server Upgrade Recommendations and Best Practices
http://www.edgewoodsolutions.com/re...erUpgrade_1.asp
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Although I suspect one of the articles Sebastion pointed you to contain this
information... You should consider using the database upgrade wizard... IT
should appear under a program group called "Microsoft SQL Server -
Switch"... It will move everything including permissions and logins...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:40622890.4020207@.deltanet.com...
> I am trying import my database from Sql Server 6.5 to 7.0 and can only
> seem to get the tables.
> I am using DTS and I can transfer the tables fine, but there doesn't
> seem to be an option to move the other objects. There is a third button
> that copies data between 7.0 databases, but that is greyed out since I
> am coming from a 7.0 database.
> There is a query button, but I don't how that would help me.
> Thanks,
> Tom.
>|||Wayne Snyder wrote:

> Although I suspect one of the articles Sebastion pointed you to contain th
is
> information... You should consider using the database upgrade wizard... I
T
> should appear under a program group called "Microsoft SQL Server -
> Switch"... It will move everything including permissions and logins...
Found it.
I tried to run this and got the message "The local Sql Server is running
under LocalSystem priviledges, preventing the Upgrade Wizard to connect
to the Export Server". Why is this? How do I get it to run the way the
wizard wants?
Thanks,
Tom.

>

Getting nulls in SQL2005 table while importing from EXCEL spreadsheet

I am trying to import an Excel Spreadsheet into SQL2005. There is a column in the spreadsheet that has character values, and numbers. I have formatted the numbers as text on the spreadsheet. I have declared the column on the table as char/varchar/nchar, but whatever I do, the numbers don't get imported into the table, but show up as nulls. Any idea why?

Thanks

Mangala

Search the forum. It's a common issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1872950&SiteID=1

Getting null values while importing data from excel sheet to sqql server

Hai Friends,

Actually i want to import excel sheet in to sql server tables. I am writing the following query SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Book1.xls','SELECT * FROM [Sheet1$]') and able to retireve the data but the problem is the data present in the excel sheet is

Usernamepasswordhello1234512345hellohai-123haihaihaihellohello-123

Once i run this query i am getting it as

Username Password hello NULL
NULL hello
hai-123 haihai
haihello hello-123
can anybody please help me out in this case and how to solve this problem and if you have any piece of code please pass it on to me and i am in very urgent need waiting for your replies thanks in advance.

Friends, what i mean to say is i am getting null values in the results.