|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sbd to mdfI'm starting to work with Microsoft Accounting which uses SQL 2005 database.
I'm going to use it's database structure (some tables, SPs etc) in my database on SQL 2000. Data file has an extension sbd. It's not compatible with SQL 2000. Is there any way to convert it to mdf in order to attach it to SQL 2000 server? DTS is very time consuming operation. vovan vovan (some***@vovan.com) writes:
> I'm starting to work with Microsoft Accounting which uses SQL 2005 I don't know what this sbd is, but from your description it sounds just> database. > I'm going to use it's database structure (some tables, SPs etc) in my > database on SQL 2000. Data file has an extension sbd. It's not compatible > with SQL 2000. Is there any way to convert it to mdf in order to attach it > to SQL 2000 server? > DTS is very time consuming operation. like they've called the file sbd rather than mdf. Or this sbd is something which is completely specific to Microsoft Accounting and unrelated to SQL Server. In any case, if you want to get the tables, SPs etc from SQL 2005 to SQL 2000, you will need to script it one way or the other. There is no tool that I know that can convert an SQL 2005 database to SQL 2000 format. -- Erland Sommarskog, SQL Server MVP, esq***@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 Thank you
I'm trying to do it that way. But due to many dependancies of one object from another scripts produce a lot of errors. For instance in the original DB there are 3 views. There names for instance vwFirst, vwSecond, vwThird In script they appear in the alphabetical order, but the code inside of vwFirst include vwThird. Because when the code for vwFirst includes vwThird, and that view should be created later, there is an error and vwFirst is not created. The number of object is huge and to edit manually is a very long time job, I'm looking for the way to copy all objects from sbd format DB into mdf format db. Maybe there is some settings in SQL 2005 allowing to run any script without producing an error? I did not find so far. vovan Show quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns992170674FAECYazorman@127.0.0.1... > vovan (some***@vovan.com) writes: >> I'm starting to work with Microsoft Accounting which uses SQL 2005 >> database. >> I'm going to use it's database structure (some tables, SPs etc) in my >> database on SQL 2000. Data file has an extension sbd. It's not compatible >> with SQL 2000. Is there any way to convert it to mdf in order to attach >> it >> to SQL 2000 server? >> DTS is very time consuming operation. > > I don't know what this sbd is, but from your description it sounds just > like they've called the file sbd rather than mdf. Or this sbd is something > which is completely specific to Microsoft Accounting and unrelated to > SQL Server. > > In any case, if you want to get the tables, SPs etc from SQL 2005 to > SQL 2000, you will need to script it one way or the other. There is no > tool that I know that can convert an SQL 2005 database to SQL 2000 format. > > -- > Erland Sommarskog, SQL Server MVP, esq***@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 vovan (some***@vovan.com) writes:
> I'm trying to do it that way. But due to many dependancies of one object In the scripting wizard, there is an option for "script depending objects".> from another scripts produce a lot of errors. > For instance in the original DB there are 3 views. There names for > instance vwFirst, vwSecond, vwThird > In script they appear in the alphabetical order, but the code inside of > vwFirst include vwThird. Because when the code for vwFirst includes > vwThird, and that view should be created later, there is an error and > vwFirst is not created. > The number of object is huge and to edit manually is a very long time job, > I'm looking for the way to copy all objects from sbd format DB into mdf > format db. > Maybe there is some settings in SQL 2005 allowing to run any script > without producing an error? I did not find so far. A problem is that dependency information in SQL Server is not always accurate, because if a table is dropped and recreated, all dependicies for it lose. If you have Service Pack 2 of SQL 2005 installed, you can run the stored procedure sp_refreshsqlmodule on all stored procedures, views etc to make sure that all dependency information is up to date. -- Erland Sommarskog, SQL Server MVP, esq***@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 Thanks a lot Erland
Show quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns9921B506E6779Yazorman@127.0.0.1... > vovan (some***@vovan.com) writes: >> I'm trying to do it that way. But due to many dependancies of one object >> from another scripts produce a lot of errors. >> For instance in the original DB there are 3 views. There names for >> instance vwFirst, vwSecond, vwThird >> In script they appear in the alphabetical order, but the code inside of >> vwFirst include vwThird. Because when the code for vwFirst includes >> vwThird, and that view should be created later, there is an error and >> vwFirst is not created. >> The number of object is huge and to edit manually is a very long time >> job, >> I'm looking for the way to copy all objects from sbd format DB into mdf >> format db. >> Maybe there is some settings in SQL 2005 allowing to run any script >> without producing an error? I did not find so far. > > In the scripting wizard, there is an option for "script depending > objects". > > A problem is that dependency information in SQL Server is not always > accurate, because if a table is dropped and recreated, all dependicies > for it lose. If you have Service Pack 2 of SQL 2005 installed, you can > run the stored procedure sp_refreshsqlmodule on all stored procedures, > views > etc to make sure that all dependency information is up to date. > > > -- > Erland Sommarskog, SQL Server MVP, esq***@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 wow
that's great info of course-- now we jsut need to get them to fix that damn sp_rename BUG in SQL 2000 until then it's jihad Show quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns9921B506E6779Yazorman@127.0.0.1... > vovan (some***@vovan.com) writes: > > I'm trying to do it that way. But due to many dependancies of one object > > from another scripts produce a lot of errors. > > For instance in the original DB there are 3 views. There names for > > instance vwFirst, vwSecond, vwThird > > In script they appear in the alphabetical order, but the code inside of > > vwFirst include vwThird. Because when the code for vwFirst includes > > vwThird, and that view should be created later, there is an error and > > vwFirst is not created. > > The number of object is huge and to edit manually is a very long time job, > > I'm looking for the way to copy all objects from sbd format DB into mdf > > format db. > > Maybe there is some settings in SQL 2005 allowing to run any script > > without producing an error? I did not find so far. > > In the scripting wizard, there is an option for "script depending objects". > > A problem is that dependency information in SQL Server is not always > accurate, because if a table is dropped and recreated, all dependicies > for it lose. If you have Service Pack 2 of SQL 2005 installed, you can > run the stored procedure sp_refreshsqlmodule on all stored procedures, views > etc to make sure that all dependency information is up to date. > > > -- > Erland Sommarskog, SQL Server MVP, esq***@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 I created several script files - For tables creation, for tables alteration
(keys, defaults etc), for SPs, for Views. I tried to run each of them several times. Each time I used to get more and more object. So, finally I could create all object. vovan Show quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns992170674FAECYazorman@127.0.0.1... > vovan (some***@vovan.com) writes: >> I'm starting to work with Microsoft Accounting which uses SQL 2005 >> database. >> I'm going to use it's database structure (some tables, SPs etc) in my >> database on SQL 2000. Data file has an extension sbd. It's not compatible >> with SQL 2000. Is there any way to convert it to mdf in order to attach >> it >> to SQL 2000 server? >> DTS is very time consuming operation. > > I don't know what this sbd is, but from your description it sounds just > like they've called the file sbd rather than mdf. Or this sbd is something > which is completely specific to Microsoft Accounting and unrelated to > SQL Server. > > In any case, if you want to get the tables, SPs etc from SQL 2005 to > SQL 2000, you will need to script it one way or the other. There is no > tool that I know that can convert an SQL 2005 database to SQL 2000 format. > > -- > Erland Sommarskog, SQL Server MVP, esq***@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  |
|||||||||||||||||||||||
Other interesting topics