Database Import/Export Question

I tried to export a database which includes tables and stored procedures from development environment to a production environment. For unknown reasons only the tables were copied whereas stored procedures were not copied and no error message shown what happened. Does anybody have a clue? I did the same export to an XP machine and it went through properly.How did you export the data? Did you use DTS?
Maybe you will find my previous post listing the steps I use to export objects to be helpful:http://forums.asp.net/1037418/showpost.aspx
|||Thanks. I got it. Don't know why the import/export said 100% complete but nothing showed up even I refreshed the stroed procedures in Enterprise Manager. And after a while (actually I went to pull someone to see the situation) the SP shown. Weird?|||

vljw8202 wrote:

Thanks. I got it. Don't know why theimport/export said 100% complete but nothing showed up even I refreshedthe stroed procedures in Enterprise Manager. And after a while(actually I went to pull someone to see the situation) the SPshown. Weird?

Enterprise Manager is often annoyingly unaware of schema changes. What I typically do is right-click on the server name and chooseRefresh, do the same for the Database node, the specific database, andthen the Tables node and any other node which should berefreshed. The new objects will then show up.
|||I see. Thanks for your advice.

Database Export Question

Hi All,
We have a procedure here we recently moved from Access 2000 to SQL Server
2000. Unfortunately, during the migration, we missed an export that is
needed (an index file). The prior indexes were stored in a CDX file. We
have a crystal reports routine running that needs this index file for proper
linking to a legacy app.
My question is "How can I export a CDX file to duplicate the results we had
from Access 2000?"
I hope someone here might have an answer and or another solution that might
work for me!
Thanks!
TravisTravis,
SQL Server does not use separate files for indexes. If you need a
particular index on a table in sql server you can generate one using CREATE
INDEX or you can use Enterprise Manager. If crystal is looking for this
file you might try a Crystal Reports news group or the Access newsgroup.
--
Andrew J. Kelly
SQL Server MVP
"REM7600" <rem7600@.hotmail.com> wrote in message
news:OhdiZjTgDHA.616@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> We have a procedure here we recently moved from Access 2000 to SQL Server
> 2000. Unfortunately, during the migration, we missed an export that is
> needed (an index file). The prior indexes were stored in a CDX file. We
> have a crystal reports routine running that needs this index file for
proper
> linking to a legacy app.
> My question is "How can I export a CDX file to duplicate the results we
had
> from Access 2000?"
> I hope someone here might have an answer and or another solution that
might
> work for me!
> Thanks!
> Travis
>|||A CDX file is not a native Access 2000 file (unless it's simply a MDB file
that has been renamed).
Possibly you have a FoxPro database (DBF) linked into Access? FoxPro uses
the CDX file extension for its indexes.
> have a crystal reports routine running that needs this index file for
proper
> linking to a legacy app.
Presumably this routine is looking for a unqiue key which you can easily
create yourself either as a PRIMARY KEY or UNIQUE constraint or using CREATE
INDEX:
CREATE UNIQUE [NON]CLUSTERED INDEX...
See Books Online for details.
There should be no need to import the index itself because an index doesn't
contain any additional data, but if it is a FoxPro index then the Visual
FoxPro upsizing wizard would be an alternative method of recreating it in
SQL.
--
David Portas
--
Please reply only to the newsgroup
--|||Hey David,
I already have created the indexes in SQL Server but the Crystal app is not
recognizing these as being unique.
Thanks for the help. I'm gonna have to find another way areound this one...
Travis
> A CDX file is not a native Access 2000 file (unless it's simply a MDB file
> that has been renamed).
> Possibly you have a FoxPro database (DBF) linked into Access? FoxPro uses
> the CDX file extension for its indexes.
>
> > have a crystal reports routine running that needs this index file for
> proper
> > linking to a legacy app.
> Presumably this routine is looking for a unqiue key which you can easily
> create yourself either as a PRIMARY KEY or UNIQUE constraint or using
CREATE
> INDEX:
> CREATE UNIQUE [NON]CLUSTERED INDEX...
> See Books Online for details.
> There should be no need to import the index itself because an index
doesn't
> contain any additional data, but if it is a FoxPro index then the Visual
> FoxPro upsizing wizard would be an alternative method of recreating it in
> SQL.|||Hey Andrew,
I was afraid that was going to be the answer! OUCH! :-)
I already have the indexes created on the table so I guess I'll need to look
at doing it differently in Crystal. Oh, how these little projects grow...
:-) Thanks for the reply.
Travis
> SQL Server does not use separate files for indexes. If you need a
> particular index on a table in sql server you can generate one using
CREATE
> INDEX or you can use Enterprise Manager. If crystal is looking for this
> file you might try a Crystal Reports news group or the Access newsgroup.sql

Database export from Vwd 2005

I recently posted this question to MSDN forum and was directed to re-ask it on this forum. Following are the question and answer I got...

>>>>>>>>>>

I am trying to export a table from VWD into a CSV, MySQL or text file so I can transmit it to my hosting manager. They won't take it in as a .mdf - After browsing around on VWD Options & Help I can't find someting that specifically has export options for database.

Anyone ?

Answer :

you maybe best asking the gurus over at the ASP.NET forums:

http://forums.asp.net

I think this would come from the database manager itself on options to export data, not within VWD however. Again, best to ask there

I am looking for the same thing--please let me know when/if you find out how.

L

Database export

Hi
When exporting a database from one server to another is
it then somehow possible to make sure that both the users
in the database and the server logins are being exported
too.
It seems that only the users in the database are being
exported. I know that you afterwards can use sp_addlogin
and sp_change_users_login. But this will force one to
change the existing passwords.
TIA
KlausI suggest you search KB for sp_help_revlogins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Klaus" <anonymous@.discussions.microsoft.com> wrote in message
news:067301c49188$fe271350$a401280a@.phx.gbl...
> Hi
> When exporting a database from one server to another is
> it then somehow possible to make sure that both the users
> in the database and the server logins are being exported
> too.
> It seems that only the users in the database are being
> exported. I know that you afterwards can use sp_addlogin
> and sp_change_users_login. But this will force one to
> change the existing passwords.
> TIA
> Klaus|||Klaus
Here a links to a lot of articles which will give you help when moving
databases between servers.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
Hope this helps
John|||Thanks for your answer, Tibor.
This may be a stupid question but what is KB. The online
books don't seem to say anything about sp_help_revlogins.
-- Klaus
>--Original Message--
>I suggest you search KB for sp_help_revlogins.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Klaus" <anonymous@.discussions.microsoft.com> wrote in
message
>news:067301c49188$fe271350$a401280a@.phx.gbl...
>> Hi
>> When exporting a database from one server to another is
>> it then somehow possible to make sure that both the
users
>> in the database and the server logins are being
exported
>> too.
>> It seems that only the users in the database are being
>> exported. I know that you afterwards can use
sp_addlogin
>> and sp_change_users_login. But this will force one to
>> change the existing passwords.
>> TIA
>> Klaus
>
>.
>|||KB = Knowledge Base.
Collection of 'How it works' technical descriptions on the
Microsoft web site.
Peter
"Cauliflower is nothing but cabbage with a college
education."
Mark Twain
>--Original Message--
>Thanks for your answer, Tibor.
>This may be a stupid question but what is KB. The online
>books don't seem to say anything about sp_help_revlogins.
>-- Klaus
>
>>--Original Message--
>>I suggest you search KB for sp_help_revlogins.
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"Klaus" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:067301c49188$fe271350$a401280a@.phx.gbl...
>> Hi
>> When exporting a database from one server to another is
>> it then somehow possible to make sure that both the
>users
>> in the database and the server logins are being
>exported
>> too.
>> It seems that only the users in the database are being
>> exported. I know that you afterwards can use
>sp_addlogin
>> and sp_change_users_login. But this will force one to
>> change the existing passwords.
>> TIA
>> Klaus
>>
>>.
>.
>

Database export

Hi
When exporting a database from one server to another is
it then somehow possible to make sure that both the users
in the database and the server logins are being exported
too.
It seems that only the users in the database are being
exported. I know that you afterwards can use sp_addlogin
and sp_change_users_login. But this will force one to
change the existing passwords.
TIA
KlausI suggest you search KB for sp_help_revlogins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Klaus" <anonymous@.discussions.microsoft.com> wrote in message
news:067301c49188$fe271350$a401280a@.phx.gbl...
> Hi
> When exporting a database from one server to another is
> it then somehow possible to make sure that both the users
> in the database and the server logins are being exported
> too.
> It seems that only the users in the database are being
> exported. I know that you afterwards can use sp_addlogin
> and sp_change_users_login. But this will force one to
> change the existing passwords.
> TIA
> Klaus|||Klaus
Here a links to a lot of articles which will give you help when moving
databases between servers.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
Hope this helps
John|||Thanks for your answer, Tibor.
This may be a stupid question but what is KB. The online
books don't seem to say anything about sp_help_revlogins.
-- Klaus

>--Original Message--
>I suggest you search KB for sp_help_revlogins.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Klaus" <anonymous@.discussions.microsoft.com> wrote in
message
>news:067301c49188$fe271350$a401280a@.phx.gbl...
users[vbcol=seagreen]
exported[vbcol=seagreen]
sp_addlogin[vbcol=seagreen]
>
>.
>|||KB = Knowledge Base.
Collection of 'How it works' technical descriptions on the
Microsoft web site.
Peter
"Cauliflower is nothing but cabbage with a college
education."
Mark Twain

>--Original Message--
>Thanks for your answer, Tibor.
>This may be a stupid question but what is KB. The online
>books don't seem to say anything about sp_help_revlogins.
>-- Klaus
>
>message
>users
>exported
>sp_addlogin
>.
>

Database export

Hi
When exporting a database from one server to another is
it then somehow possible to make sure that both the users
in the database and the server logins are being exported
too.
It seems that only the users in the database are being
exported. I know that you afterwards can use sp_addlogin
and sp_change_users_login. But this will force one to
change the existing passwords.
TIA
Klaus
I suggest you search KB for sp_help_revlogins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Klaus" <anonymous@.discussions.microsoft.com> wrote in message
news:067301c49188$fe271350$a401280a@.phx.gbl...
> Hi
> When exporting a database from one server to another is
> it then somehow possible to make sure that both the users
> in the database and the server logins are being exported
> too.
> It seems that only the users in the database are being
> exported. I know that you afterwards can use sp_addlogin
> and sp_change_users_login. But this will force one to
> change the existing passwords.
> TIA
> Klaus
|||Klaus
Here a links to a lot of articles which will give you help when moving
databases between servers.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
Hope this helps
John
|||Thanks for your answer, Tibor.
This may be a stupid question but what is KB. The online
books don't seem to say anything about sp_help_revlogins.
-- Klaus

>--Original Message--
>I suggest you search KB for sp_help_revlogins.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Klaus" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:067301c49188$fe271350$a401280a@.phx.gbl...
users[vbcol=seagreen]
exported[vbcol=seagreen]
sp_addlogin
>
>.
>
|||KB = Knowledge Base.
Collection of 'How it works' technical descriptions on the
Microsoft web site.
Peter
"Cauliflower is nothing but cabbage with a college
education."
Mark Twain

>--Original Message--
>Thanks for your answer, Tibor.
>This may be a stupid question but what is KB. The online
>books don't seem to say anything about sp_help_revlogins.
>-- Klaus
>
>message
>users
>exported
>sp_addlogin
>.
>

Database Diagrams export

Hi, Can someone help me?
I need to create a tree structured diagram of our Server databases. I know how to create diagrams via the Enterprise manager, but I don't know how I can export them into some format, that I can further work with (doc., txt.,etc.). Is there some other tool, then the one in enterprise manager?
Thanks in advance.
Magdalena.That may be helpful:

Script SQL Server 2005 diagrams to a file

Database diagrams

Does anyone know if there is a way to export a database diagram from SQL
enterprise manager to either Microsoft visio or any other paint program?
thanx PapaniiHi,
The only way to export them out is via Copy and Paste or you can get a
graphic print driver (Postscript driver) and save the print to a file. Then
you may be able to import it into another program.
There is no option from SQL Sever to do this.
regards
Greg O
AGS SQL Server Documentation Builder - MS SQL Server
http://www.ag-software.com/ags_scribe_index.aspx
"Papanii Okai" <papanii58@.hotmail.com> wrote in message
news:uUesp8jBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Does anyone know if there is a way to export a database diagram from SQL
> enterprise manager to either Microsoft visio or any other paint program?
> thanx Papanii
>|||visio enterprise has the ability to Reverse Engineer your DB.
Visio will Build the ERD for you if you point it at your Database.
Greg Jackson
PDX, Oregon